CVE-2024-1597
pgjdbc SQL Injection via line comment generation
- Published
- Updated
- Reserved
- Assigned by
- PostgreSQL
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.
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 8.0% of all CVEs (7 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.
Weakness
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 (9)
- 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)
- 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://trackcve.app/cve/CVE-2024-1597)Record last updated .