{"dataType":"CVE_RECORD","cveMetadata":{"cveId":"CVE-2024-1597","assignerOrgId":"f86ef6dc-4d3a-42ad-8f28-e6d5547a5007","state":"PUBLISHED","assignerShortName":"PostgreSQL","dateReserved":"2024-02-16T22:29:21.969Z","datePublished":"2024-02-19T12:58:48.620Z","dateUpdated":"2025-11-03T21:52:29.022Z"},"containers":{"cna":{"providerMetadata":{"orgId":"f86ef6dc-4d3a-42ad-8f28-e6d5547a5007","shortName":"PostgreSQL","dateUpdated":"2024-06-10T16:14:25.740Z"},"title":"pgjdbc SQL Injection via line comment generation","descriptions":[{"lang":"en","value":"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":[{"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"}]}],"problemTypes":[{"descriptions":[{"lang":"en","cweId":"CWE-89","type":"CWE","description":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')"}]}],"references":[{"url":"https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56"},{"url":"https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/"},{"url":"https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/"},{"url":"https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/"},{"url":"https://security.netapp.com/advisory/ntap-20240419-0008/"},{"url":"http://www.openwall.com/lists/oss-security/2024/04/02/6"},{"url":"https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html"}],"metrics":[{"cvssV3_1":{"version":"3.1","vectorString":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","attackVector":"NETWORK","attackComplexity":"LOW","privilegesRequired":"NONE","userInteraction":"NONE","scope":"CHANGED","confidentialityImpact":"HIGH","integrityImpact":"HIGH","availabilityImpact":"HIGH","baseScore":10,"baseSeverity":"CRITICAL"}}],"configurations":[{"lang":"en","value":"Client must run code with PreferQueryMode=Simple"}],"workarounds":[{"lang":"en","value":"Don't use SimpleQuery mode"}],"credits":[{"lang":"en","value":"The pgjdbc project thanks Paul Gerste for reporting this problem."}]},"adp":[{"affected":[{"vendor":"pgjdbc","product":"pgjdbc","cpes":["cpe:2.3:a:pgjdbc:pgjdbc:*:*:*:*:*:*:*:*"],"defaultStatus":"unknown","versions":[{"version":"0","status":"affected","lessThan":"42.7.2","versionType":"custom"},{"version":"0","status":"affected","lessThan":"42.6.1","versionType":"custom"},{"version":"0","status":"affected","lessThan":"42.5.5","versionType":"custom"},{"version":"0","status":"affected","lessThan":"42.4.4","versionType":"custom"},{"version":"0","status":"affected","lessThan":"42.3.9","versionType":"custom"},{"version":"0","status":"affected","lessThan":"42.2.28","versionType":"custom"}]}],"metrics":[{"other":{"type":"ssvc","content":{"timestamp":"2024-04-10T04:00:36.120593Z","id":"CVE-2024-1597","options":[{"Exploitation":"poc"},{"Automatable":"yes"},{"Technical Impact":"total"}],"role":"CISA Coordinator","version":"2.0.3"}}}],"title":"CISA ADP Vulnrichment","providerMetadata":{"orgId":"134c704f-9b21-4f2e-91b3-4a467353bcc0","shortName":"CISA-ADP","dateUpdated":"2024-07-30T16:53:44.796Z"}},{"title":"CVE Program Container","references":[{"url":"https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/"},{"tags":["x_transferred"],"url":"https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56"},{"tags":["x_transferred"],"url":"https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/"},{"tags":["x_transferred"],"url":"https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/"},{"tags":["x_transferred"],"url":"https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/"},{"tags":["x_transferred"],"url":"https://security.netapp.com/advisory/ntap-20240419-0008/"},{"tags":["x_transferred"],"url":"http://www.openwall.com/lists/oss-security/2024/04/02/6"},{"tags":["x_transferred"],"url":"https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html"},{"url":"https://lists.debian.org/debian-lts-announce/2024/12/msg00017.html"}],"providerMetadata":{"orgId":"af854a3a-2127-422b-91ae-364da2661108","shortName":"CVE","dateUpdated":"2025-11-03T21:52:29.022Z"}}]},"dataVersion":"5.2"}