SQL injection via unescaped refreshRow column identifiers
Published Aug 3, 2022 · Updated Nov 3, 2025
SQL injection in PostgreSQL JDBC Driver before 42.2.26 and 42.3.0 through 42.4.0 allows attackers to execute SQL as the JDBC user. PgResultSet.refreshRow() copies key and data column names into generated SQL without identifier escaping, so a statement terminator creates extra commands. Exploitation requires a maliciously controlled database schema and an application that queries the crafted table and calls ResultSet.refreshRow(); injected SQL runs with the application's JDBC privileges.
Summary
What happened
SQL injection in PostgreSQL JDBC Driver before 42.2.26 and 42.3.0 through 42.4.0 allows attackers to execute SQL as the JDBC user. PgResultSet.refreshRow() copies key and data column names into generated SQL without identifier escaping, so a statement terminator creates extra commands. Exploitation requires a maliciously controlled database schema and an application that queries the crafted table and calls ResultSet.refreshRow(); injected SQL runs with the application's JDBC privileges.
The record
- CVE
- CVE-2022-31197
- Published
- Aug 3, 2022
- Updated
- Nov 3, 2025
- Vendor
- PostgreSQL Global Development Group
- Product
- PostgreSQL JDBC Driver
- Classifications
- CWE-89
- Attack vector
- network
- Privileges
- authenticated
Timeline
How it unfolded
- Aug 3, 2022CVE publishedPublication date reported by the CVE source.
- Nov 3, 2025Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=>= 42.2.0, < 42.2.26
- Affected versionversion=>= 42.3.0, < 42.4.1
What conditions does exploitation require?
What is affected?
Published CVSS scores
CVSS describes severity. EPSS estimates exploitation probability.
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
- Malicious column-name refreshRow proof of conceptproof of concept · demonstrated
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo