CVE-2024-1597pgjdbc SQL Injection via line comment generation
- 10.0CriticalCVSS base score
- 4.8%Exploitation in 30 daysEPSS · top 7.9% of all CVEs
- NoKnown exploitednot in CISA's KEV catalog
- YesPublic exploitsa reference or SSVC says so
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.
Public exploit
An exploit or proof of concept is public: anyone can try it against an unpatched system. CISA's SSVC rates its exploitation: a proof of concept is public.
Timeline
ID reserved
By PostgreSQL
- 3 days later
· 3 days later
Published
- 21 months later
· 21 months later
Record updated
Changes after publication (a new score, a public exploit, EPSS crossing 1, 10 or 50 %, leaving KEV) are kept since November 2026; earlier ones are not known.
Scores
| Scored by | CVSS | Score | Vector |
|---|---|---|---|
| PostgreSQLCNA (assigner) | 3.1 | Critical10.0 | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H |
| NVDNVD · Modified | 3.1 | Critical9.8 | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H |
- EPSS (exploitation in 30 days)
- 4.8% · top 7.9% of all CVEs (14 Nov 2026)
- CISA SSVC
- Exploitation: poc · Automatable: yes · Technical impact: total
The list uses the assigner's score when there is one, then CISA's, then NVD's: Critical 10.0.
Affected products
Affected packages
From reviewed advisories of the GitHub Advisory Database.
- Mavenorg.postgresql:postgresqlGHSA-24rp-q3w6-vc56 (opens in a new tab)
What to do
Workaround: Don't use SimpleQuery mode
References
References9
- https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 (opens in a new tab)x_transferred
- https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ (opens in a new tab)x_transferred
- https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ (opens in a new tab)x_transferred
- https://lists.fedoraproject.org/archives/list/[email protected]/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/ (opens in a new tab)x_transferred
- https://security.netapp.com/advisory/ntap-20240419-0008/ (opens in a new tab)x_transferred
- http://www.openwall.com/lists/oss-security/2024/04/02/6 (opens in a new tab)x_transferred
- https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html (opens in a new tab)x_transferred
- https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/ (opens in a new tab)
- https://lists.debian.org/debian-lts-announce/2024/12/msg00017.html (opens in a new tab)
Sources
The same CVE in the primary databases and aggregators, to check against.
- CVE.org record (opens in a new tab)
- CVE List JSON (GitHub) (opens in a new tab)
- NVD (opens in a new tab)
- FIRST EPSS (opens in a new tab)
- EUVD EUVD-2024-0465 (opens in a new tab)
- OSV.dev (opens in a new tab)
- GitHub Advisory GHSA-24rp-q3w6-vc56 (opens in a new tab)
- CIRCL Vulnerability-Lookup (opens in a new tab)
Badge for a README or a ticket
[](https://cveledger.app/cve/CVE-2024-1597)Record last updated .