CVE-2024-1597: pgjdbc SQL Injection via line comment generation

Severity: critical (CVSS 9.8 v3.1)
Exploited in the wild: not listed in CISA KEV
EPSS: 4.8% probability of exploitation in the next 30 days
Public exploit or detection template: none known
Published: 2024-02-19 · updated 2026-06-17
Weakness: CWE-89

Description

pgjdbc, the PostgreSQL JDBC Driver, allows attacker to inject SQL if using PreferQueryMode=SIMPLE. Note this is not the default. In the default mode there is no vulnerability. A placeholder for a numeric value must be immediately preceded by a minus. There must be a second placeholder for a string value after the first placeholder; both must be on the same line. By constructing a matching string payload, the attacker can inject SQL to alter the query,bypassing the protections that parameterized queries bring against SQL Injection attacks. Versions before 42.7.2, 42.6.1, 42.5.5, 42.4.4, 42.3.9, and 42.2.28 are affected.

Affected products

Fedoraproject Fedora: 40
Postgresql Jdbc Driver: before 42.2.28; from 42.3.0 before 42.3.9; from 42.4.0 before 42.4.4; from 42.5.0 before 42.5.5; from 42.6.0 before 42.6.1; from 42.7.0 before 42.7.2 — fixed in 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2

How to fix

Upgrade to a fixed version: Postgresql Jdbc Driver 42.2.28, 42.3.9, 42.4.4, 42.5.5. Check the vendor advisory for mitigations.

References

Get alerted when CVE-2024-1597 or the next vulnerability affects your stack