CVE-2024-1597: pgjdbc, the PostgreSQL JDBC Driver, allows attacker to inject SQL if using PreferQueryMode=SIMPLE. Note this is not the default. In the default mode t...

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.

Metrics

CVSS 3.1

9.8/10

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

EPSS Probability

4.81%

90.8th percentile

Probability of exploitation in the next 30 days. Learn more

Weakness Enumeration

Affected Software

Vendor	Product	Versions
Postgresql	Postgresql Jdbc Driver	< 42.2.28
Postgresql	Postgresql Jdbc Driver	>= 42.3.0, < 42.3.9
Postgresql	Postgresql Jdbc Driver	>= 42.4.0, < 42.4.4
Postgresql	Postgresql Jdbc Driver	>= 42.5.0, < 42.5.5
Postgresql	Postgresql Jdbc Driver	>= 42.6.0, < 42.6.1
Postgresql	Postgresql Jdbc Driver	>= 42.7.0, < 42.7.2
Fedoraproject	Fedora	40

References

Timeline

Published: Feb 19, 2024
Last Modified: Jun 17, 2026
Status: Modified

Frequently Asked Questions

What is CVE-2024-1597?

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.

How severe is CVE-2024-1597?

CVE-2024-1597 has a CVSS score of 9.8/10 (CRITICAL severity). The EPSS model estimates a 4.81% probability of exploitation in the next 30 days.

How do I fix CVE-2024-1597?

Check the vendor references and advisories linked above for patched versions and mitigation guidance. You can also run a Strix scan to test if your systems are affected.