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.
CVSS 3.x Severity and Vector Strings:
Vector:
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H
CVSS 2.0 Severity and Vector Strings:
Base
Score:
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].
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
|