VOOZH about

URL: https://nvd.nist.gov/vuln/detail/CVE-2024-1597

⇱ NVD - CVE-2024-1597


  1. Vulnerabilities

CVE-2024-1597 Detail

Modified After Enrichment

This CVE record has been updated after NVD enrichment efforts were completed. Enrichment data supplied by the NVD may require amendment due to these changes.

Current 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.


View Analysis Description

Analysis 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.8 are affected.

Metrics

 
NVD enrichment efforts reference publicly available information to associate vector strings. CVSS information contributed by other sources is also displayed.
CVSS 4.0 Severity and Vector Strings:

NVD assessment not yet provided.

References to Advisories, Solutions, and Tools

By selecting these links, you will be leaving NIST webspace. We have provided these links to other web sites because they may have information that would be of interest to you. No inferences should be drawn on account of other sites being referenced, or not, from this page. There may be other web sites that are more appropriate for your purpose. NIST does not necessarily endorse the views expressed, or concur with the facts presented on these sites. Further, NIST does not endorse any commercial products that may be mentioned on these sites. Please address comments about this page to [email protected].

URL Source(s) Tag(s)
http://www.openwall.com/lists/oss-security/2024/04/02/6 CVE, PostgreSQL
https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 CVE, PostgreSQL Third Party Advisory 
https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html CVE, PostgreSQL
https://lists.debian.org/debian-lts-announce/2024/12/msg00017.html CVE
https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/ CVE, PostgreSQL Mailing List  Third Party Advisory 
https://security.netapp.com/advisory/ntap-20240419-0008/ CVE, PostgreSQL
https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ CVE, PostgreSQL Release Notes 
https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ CVE, PostgreSQL Third Party Advisory 
https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/ CVE

Weakness Enumeration

CWE-ID CWE Name Source
CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') πŸ‘ cwe source acceptance level
NIST  
PostgreSQL  

Known Affected Software Configurations Switch to CPE 2.2

CPEs loading, please wait.

Denotes Vulnerable Software
Are we missing a CPE here? Please let us know.

Change History

14 change records found show changes

CVE Modified by CISA-ADP 6/17/2026 3:04:36 AM

Action Type Old Value New Value
Added Affected
[{"vendor":"pgjdbc","product":"pgjdbc","defaultStatus":"unknown","cpes":["cpe:2.3:a:pgjdbc:pgjdbc:*:*:*:*:*:*:*:*"],"versions":[{"version":"0","lessThan":"42.7.2","versionType":"custom","status":"affected"},{"version":"0","lessThan":"42.6.1","versionType":"custom","status":"affected"},{"version":"0","lessThan":"42.5.5","versionType":"custom","status":"affected"},{"version":"0","lessThan":"42.4.4","versionType":"custom","status":"affected"},{"version":"0","lessThan":"42.3.9","versionType":"custom","status":"affected"},{"version":"0","lessThan":"42.2.28","versionType":"custom","status":"affected"}]}]


Added SSVC
{"timestamp":"2024-04-10T04:00:36.120593Z","id":"CVE-2024-1597","options":[{"exploitation":"poc"},{"automatable":"yes"},{"technicalImpact":"total"}],"role":"CISA Coordinator","version":"2.0.3"}


CVE Modified by PostgreSQL 6/17/2026 3:04:36 AM

Action Type Old Value New Value
Added Affected
[{"vendor":"pgjdbc","product":"pgjdbc","versions":[{"version":"< 42.7.2","status":"affected"},{"version":"< 42.6.1","status":"affected"},{"version":"< 42.5.5","status":"affected"},{"version":"< 42.4.4","status":"affected"},{"version":"< 42.3.9","status":"affected"},{"version":"< 42.2.28","status":"affected"}]}]


CVE Modified by CVE 11/03/2025 5:16:40 PM

Action Type Old Value New Value
Added Reference
https://lists.debian.org/debian-lts-announce/2024/12/msg00017.html


CVE Modified by CVE 6/12/2025 12:15:21 PM

Action Type Old Value New Value
Added Reference
https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/


CVE Modified by CVE 11/21/2024 3:50:54 AM

Action Type Old Value New Value
Added Reference
http://www.openwall.com/lists/oss-security/2024/04/02/6


Added Reference
https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56


Added Reference
https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html


Added Reference
https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/


Added Reference
https://security.netapp.com/advisory/ntap-20240419-0008/


Added Reference
https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/


Added Reference
https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/


CVE Modified by PostgreSQL 6/10/2024 1:16:17 PM

Action Type Old Value New Value
Added Reference
PostgreSQL https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html [No types assigned]


CVE Modified by PostgreSQL 5/14/2024 10:48:10 AM

Action Type Old Value New Value

CVE Modified by PostgreSQL 5/01/2024 2:15:13 PM

Action Type Old Value New Value
Added Reference
PostgreSQL http://www.openwall.com/lists/oss-security/2024/04/02/6 [No types assigned]


CVE Modified by PostgreSQL 4/19/2024 3:15:09 AM

Action Type Old Value New Value
Added Reference
PostgreSQL https://security.netapp.com/advisory/ntap-20240419-0008/ [No types assigned]


CVE Modified by PostgreSQL 4/18/2024 3:15:08 PM

Action Type Old Value New Value
Changed 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.8 are affected.


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.


Initial Analysis by NIST 3/25/2024 12:42:20 PM

Action Type Old Value New Value
Added CVSS V3.1
NIST AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H


Added CWE
NIST CWE-89


Added CPE Configuration
OR
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions up to (excluding) 42.2.28
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions from (including) 42.3.0 up to (excluding) 42.3.9
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions from (including) 42.4.0 up to (excluding) 42.4.4
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions from (including) 42.5.0 up to (excluding) 42.5.5
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions from (including) 42.6.0 up to (excluding) 42.6.1
 *cpe:2.3:a:postgresql:postgresql_jdbc_driver:*:*:*:*:*:*:*:* versions from (including) 42.7.0 up to (excluding) 42.7.2


Added CPE Configuration
OR
 *cpe:2.3:o:fedoraproject:fedora:40:*:*:*:*:*:*:*


Changed Reference Type
https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 No Types Assigned


https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 Third Party Advisory


Changed Reference Type
https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/ No Types Assigned


https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/ Mailing List, Third Party Advisory


Changed Reference Type
https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ No Types Assigned


https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ Release Notes


Changed Reference Type
https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ No Types Assigned


https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ Third Party Advisory


CVE Modified by PostgreSQL 3/22/2024 11:15:10 PM

Action Type Old Value New Value
Added Reference
PostgreSQL https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/ [No types assigned]


CVE Modified by PostgreSQL 2/27/2024 9:15:24 PM

Action Type Old Value New Value
Added Reference
PostgreSQL https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ [No types assigned]


Added Reference
PostgreSQL https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ [No types assigned]


New CVE Received from PostgreSQL 2/19/2024 8:15:07 AM

Action Type Old Value New Value
Added 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.8 are affected.


Added CVSS V3.1
PostgreSQL AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H


Added CWE
PostgreSQL CWE-89


Added Reference
PostgreSQL https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 [No types assigned]


Quick Info

CVE Dictionary Entry:
CVE-2024-1597
NVD Published Date:
02/19/2024
NVD Last Modified:
06/17/2026
Source:
PostgreSQL