CVE-2024-1597
Fixed in a distro release EPSS 5%CVSS 10.0
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.
Products: pgjdbc
Fixed upstream
| Ecosystem | Package | Fixed in |
|---|---|---|
| Maven | org.postgresql:postgresql | 42.2.28 |
| Maven | org.postgresql:postgresql | 42.3.9 |
| Maven | org.postgresql:postgresql | 42.4.4 |
| Maven | org.postgresql:postgresql | 42.5.5 |
| Maven | org.postgresql:postgresql | 42.6.1 |
| Maven | org.postgresql:postgresql | 42.7.2 |
Distro releases
| Release | Package | Fixed in |
|---|---|---|
| AlmaLinux 8 | postgresql-jdbc | 42.2.14-3.el8_9 |
| AlmaLinux 8 | postgresql-jdbc-javadoc | 42.2.14-3.el8_9 |
| AlmaLinux 9 | postgresql-jdbc | 42.2.28-1.el9_3 |
| Chainguard | dependency-track | 4.10.1-r1 |
| Chainguard | dependency-track-bundled | 4.10.1-r1 |
| Chainguard | keycloak | 23.0.7-r0 |
| Chainguard | mariadb-10.11 | 10.11.8-r2 |
| Chainguard | mariadb-10.11-backup | 10.11.8-r2 |
| Chainguard | mariadb-10.11-bench | 10.11.8-r2 |
| Chainguard | mariadb-10.11-client | 10.11.8-r2 |
| Chainguard | mariadb-10.11-dev | 10.11.8-r2 |
| Chainguard | mariadb-10.11-doc | 10.11.8-r2 |
| Chainguard | mariadb-10.11-embedded | 10.11.8-r2 |
| Chainguard | mariadb-10.11-oci-entrypoint | 10.11.8-r2 |
| Chainguard | mariadb-10.6 | 10.6.17-r0 |
| Chainguard | mariadb-10.6-backup | 10.6.17-r0 |
| Chainguard | mariadb-10.6-bench | 10.6.17-r0 |
| Chainguard | mariadb-10.6-client | 10.6.17-r0 |
| Chainguard | mariadb-10.6-dev | 10.6.17-r0 |
| Chainguard | mariadb-10.6-doc | 10.6.17-r0 |
| Chainguard | mariadb-10.6-embedded | 10.6.17-r0 |
| Chainguard | mariadb-10.6-oci-entrypoint | 10.6.17-r0 |
| Chainguard | mariadb-10.6-test | 10.6.17-r0 |
| Chainguard | mariadb-11.2 | 11.2.3-r2 |
| Chainguard | mariadb-11.2-backup | 11.2.3-r2 |
| Chainguard | mariadb-11.2-bench | 11.2.3-r2 |
| Chainguard | mariadb-11.2-client | 11.2.3-r2 |
| Chainguard | mariadb-11.2-dev | 11.2.3-r2 |
| Chainguard | mariadb-11.2-doc | 11.2.3-r2 |
| Chainguard | mariadb-11.2-embedded | 11.2.3-r2 |
| Chainguard | mariadb-11.2-oci-entrypoint | 11.2.3-r2 |
| Chainguard | trino | 439-r2 |
| Chainguard | trino-config | 439-r2 |
| Chainguard | trino-oci-entrypoint | 439-r2 |
| Chainguard | trino-plugin-ai-functions | 439-r2 |
| Chainguard | trino-plugin-bigquery | 439-r2 |
| Chainguard | trino-plugin-blackhole | 439-r2 |
| Chainguard | trino-plugin-cassandra | 439-r2 |
| Chainguard | trino-plugin-clickhouse | 439-r2 |
| Chainguard | trino-plugin-delta-lake | 439-r2 |
| Chainguard | trino-plugin-druid | 439-r2 |
| Chainguard | trino-plugin-duckdb | 439-r2 |
| Chainguard | trino-plugin-elasticsearch | 439-r2 |
| Chainguard | trino-plugin-exasol | 439-r2 |
| Chainguard | trino-plugin-exchange-filesystem | 439-r2 |
| Chainguard | trino-plugin-exchange-hdfs | 439-r2 |
| Chainguard | trino-plugin-faker | 439-r2 |
| Chainguard | trino-plugin-functions-python | 439-r2 |
| Chainguard | trino-plugin-geospatial | 439-r2 |
| Chainguard | trino-plugin-google-sheets | 439-r2 |
| Chainguard | trino-plugin-hive | 439-r2 |
| Chainguard | trino-plugin-http-event-listener | 439-r2 |
| Chainguard | trino-plugin-http-server-event-listener | 439-r2 |
| Chainguard | trino-plugin-hudi | 439-r2 |
| Chainguard | trino-plugin-iceberg | 439-r2 |
| Chainguard | trino-plugin-ignite | 439-r2 |
| Chainguard | trino-plugin-jmx | 439-r2 |
| Chainguard | trino-plugin-kafka | 439-r2 |
| Chainguard | trino-plugin-kafka-event-listener | 439-r2 |
| Chainguard | trino-plugin-lakehouse | 439-r2 |
| Chainguard | trino-plugin-ldap-group-provider | 439-r2 |
| Chainguard | trino-plugin-loki | 439-r2 |
| Chainguard | trino-plugin-mariadb | 439-r2 |
| Chainguard | trino-plugin-memory | 439-r2 |
| Chainguard | trino-plugin-ml | 439-r2 |
| Chainguard | trino-plugin-mongodb | 439-r2 |
| Chainguard | trino-plugin-mysql | 439-r2 |
| Chainguard | trino-plugin-mysql-event-listener | 439-r2 |
| Chainguard | trino-plugin-opa | 439-r2 |
| Chainguard | trino-plugin-openlineage | 439-r2 |
| Chainguard | trino-plugin-opensearch | 439-r2 |
| Chainguard | trino-plugin-oracle | 439-r2 |
| Chainguard | trino-plugin-password-authenticators | 439-r2 |
| Chainguard | trino-plugin-pinot | 439-r2 |
| Chainguard | trino-plugin-postgresql | 439-r2 |
| Chainguard | trino-plugin-prometheus | 439-r2 |
| Chainguard | trino-plugin-ranger | 439-r2 |
| Chainguard | trino-plugin-redis | 439-r2 |
| Chainguard | trino-plugin-redshift | 439-r2 |
| Chainguard | trino-plugin-resource-group-managers | 439-r2 |
| Chainguard | trino-plugin-session-property-managers | 439-r2 |
| Chainguard | trino-plugin-singlestore | 439-r2 |
| Chainguard | trino-plugin-snowflake | 439-r2 |
| Chainguard | trino-plugin-spooling-filesystem | 439-r2 |
| Chainguard | trino-plugin-sqlserver | 439-r2 |
| Chainguard | trino-plugin-teradata-functions | 439-r2 |
| Chainguard | trino-plugin-thrift | 439-r2 |
| Chainguard | trino-plugin-tpcds | 439-r2 |
| Chainguard | trino-plugin-tpch | 439-r2 |
| Chainguard | trino-plugin-vertica | 439-r2 |
| Debian 10 | libpgjava | 42.2.5-2+deb10u4 |
| Debian 11 | libpgjava | 42.2.15-1+deb11u2 |
| Debian 12 | libpgjava | 42.5.5-0+deb12u1 |
| Debian 13 | libpgjava | 42.7.2-1 |
| Debian 14 | libpgjava | 42.7.2-1 |
| Red Hat Enterprise Linux 8 | postgresql-jdbc | 0:42.2.14-3.el8_9 |
| Red Hat Enterprise Linux 8 | postgresql-jdbc-javadoc | 0:42.2.14-3.el8_9 |
| Red Hat Enterprise Linux 9 | postgresql-jdbc | 0:42.2.28-1.el9_3 |
| Red Hat rhel aus 8.2 | postgresql-jdbc | 0:42.2.3-5.el8_2 |
| Red Hat rhel aus 8.2 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_2 |
| Red Hat rhel aus 8.4 | postgresql-jdbc | 0:42.2.3-7.el8_4 |
| Red Hat rhel aus 8.4 | postgresql-jdbc-javadoc | 0:42.2.3-7.el8_4 |
| Red Hat rhel aus 8.6 | postgresql-jdbc | 0:42.2.3-5.el8_6 |
| Red Hat rhel aus 8.6 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_6 |
| Red Hat rhel e4s 8.2 | postgresql-jdbc | 0:42.2.3-5.el8_2 |
| Red Hat rhel e4s 8.2 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_2 |
| Red Hat rhel e4s 8.4 | postgresql-jdbc | 0:42.2.3-7.el8_4 |
| Red Hat rhel e4s 8.4 | postgresql-jdbc-javadoc | 0:42.2.3-7.el8_4 |
| Red Hat rhel e4s 8.6 | postgresql-jdbc | 0:42.2.3-5.el8_6 |
| Red Hat rhel e4s 8.6 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_6 |
| Red Hat rhel eus 8.8 | postgresql-jdbc | 0:42.2.14-5.el8_8 |
| Red Hat rhel eus 8.8 | postgresql-jdbc-javadoc | 0:42.2.14-5.el8_8 |
| Red Hat rhel eus 9.0 | postgresql-jdbc | 0:42.2.28-1.el9_0 |
| Red Hat rhel eus 9.2 | postgresql-jdbc | 0:42.2.28-1.el9_2 |
| Red Hat rhel tus 8.2 | postgresql-jdbc | 0:42.2.3-5.el8_2 |
| Red Hat rhel tus 8.2 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_2 |
| Red Hat rhel tus 8.4 | postgresql-jdbc | 0:42.2.3-7.el8_4 |
| Red Hat rhel tus 8.4 | postgresql-jdbc-javadoc | 0:42.2.3-7.el8_4 |
| Red Hat rhel tus 8.6 | postgresql-jdbc | 0:42.2.3-5.el8_6 |
| Red Hat rhel tus 8.6 | postgresql-jdbc-javadoc | 0:42.2.3-5.el8_6 |
| Rocky Linux 8 | postgresql-jdbc | 0:42.2.14-3.el8_9 |
| Rocky Linux 9 | postgresql-jdbc | 0:42.2.28-1.el9_3 |
| SUSE Enterprise Storage 7.1 | postgresql-jdbc | 42.2.25-150300.3.14.1 |
| SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS | postgresql-jdbc | 42.2.25-150300.3.14.1 |
| SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Linux Enterprise Module for Server Applications 15 SP5 | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Linux Enterprise Server 12 SP5 | postgresql-jdbc | 9.4-3.12.1 |
| SUSE Linux Enterprise Server 15 SP3-LTSS | postgresql-jdbc | 42.2.25-150300.3.14.1 |
| SUSE Linux Enterprise Server 15 SP4-LTSS | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Linux Enterprise Server for SAP Applications 12 SP5 | postgresql-jdbc | 9.4-3.12.1 |
| SUSE Linux Enterprise Server for SAP Applications 15 SP3 | postgresql-jdbc | 42.2.25-150300.3.14.1 |
| SUSE Linux Enterprise Server for SAP Applications 15 SP4 | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Manager Proxy 4.3 | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| SUSE Manager Server 4.3 | postgresql-jdbc | 42.2.25-150400.3.12.1 |
| Ubuntu 14.04 LTS | libpgjava | no fix |
| Ubuntu 16.04 LTS | libpgjava | no fix |
| Ubuntu 22.04 LTS | libpgjava | no fix |
| Ubuntu Pro 18.04 LTS | libpgjava | no fix |
| Ubuntu Pro 20.04 LTS | libpgjava | no fix |
| Wolfi | dependency-track | 4.10.1-r1 |
| Wolfi | dependency-track-bundled | 4.10.1-r1 |
| Wolfi | keycloak | 23.0.7-r0 |
| Wolfi | mariadb-10.11 | 10.11.8-r2 |
| Wolfi | mariadb-10.11-backup | 10.11.8-r2 |
| Wolfi | mariadb-10.11-bench | 10.11.8-r2 |
| Wolfi | mariadb-10.11-client | 10.11.8-r2 |
| Wolfi | mariadb-10.11-dev | 10.11.8-r2 |
| Wolfi | mariadb-10.11-doc | 10.11.8-r2 |
| Wolfi | mariadb-10.11-embedded | 10.11.8-r2 |
| Wolfi | mariadb-10.11-oci-entrypoint | 10.11.8-r2 |
| Wolfi | mariadb-10.6 | 10.6.17-r0 |
| Wolfi | mariadb-10.6-backup | 10.6.17-r0 |
| Wolfi | mariadb-10.6-bench | 10.6.17-r0 |
| Wolfi | mariadb-10.6-dev | 10.6.17-r0 |
| Wolfi | mariadb-10.6-doc | 10.6.17-r0 |
| Wolfi | mariadb-10.6-embedded | 10.6.17-r0 |
| Wolfi | mariadb-10.6-oci-entrypoint | 10.6.17-r0 |
| Wolfi | mariadb-10.6-test | 10.6.17-r0 |
| Wolfi | mariadb-11.2 | 11.2.3-r2 |
| Wolfi | mariadb-11.2-backup | 11.2.3-r2 |
| Wolfi | mariadb-11.2-bench | 11.2.3-r2 |
| Wolfi | mariadb-11.2-client | 11.2.3-r2 |
| Wolfi | mariadb-11.2-dev | 11.2.3-r2 |
| Wolfi | mariadb-11.2-doc | 11.2.3-r2 |
| Wolfi | mariadb-11.2-embedded | 11.2.3-r2 |
| Wolfi | mariadb-11.2-oci-entrypoint | 11.2.3-r2 |
| Wolfi | trino | 439-r2 |
| Wolfi | trino-config | 439-r2 |
| Wolfi | trino-oci-entrypoint | 439-r2 |
| Wolfi | trino-plugin-ai-functions | 439-r2 |
| Wolfi | trino-plugin-bigquery | 439-r2 |
| Wolfi | trino-plugin-blackhole | 439-r2 |
| Wolfi | trino-plugin-cassandra | 439-r2 |
| Wolfi | trino-plugin-clickhouse | 439-r2 |
| Wolfi | trino-plugin-delta-lake | 439-r2 |
| Wolfi | trino-plugin-druid | 439-r2 |
| Wolfi | trino-plugin-duckdb | 439-r2 |
| Wolfi | trino-plugin-elasticsearch | 439-r2 |
| Wolfi | trino-plugin-exasol | 439-r2 |
| Wolfi | trino-plugin-exchange-filesystem | 439-r2 |
| Wolfi | trino-plugin-exchange-hdfs | 439-r2 |
| Wolfi | trino-plugin-faker | 439-r2 |
| Wolfi | trino-plugin-functions-python | 439-r2 |
| Wolfi | trino-plugin-geospatial | 439-r2 |
| Wolfi | trino-plugin-google-sheets | 439-r2 |
| Wolfi | trino-plugin-hive | 439-r2 |
| Wolfi | trino-plugin-http-event-listener | 439-r2 |
| Wolfi | trino-plugin-http-server-event-listener | 439-r2 |
| Wolfi | trino-plugin-hudi | 439-r2 |
| Wolfi | trino-plugin-iceberg | 439-r2 |
| Wolfi | trino-plugin-ignite | 439-r2 |
| Wolfi | trino-plugin-jmx | 439-r2 |
| Wolfi | trino-plugin-kafka | 439-r2 |
| Wolfi | trino-plugin-kafka-event-listener | 439-r2 |
| Wolfi | trino-plugin-lakehouse | 439-r2 |
| Wolfi | trino-plugin-ldap-group-provider | 439-r2 |
| Wolfi | trino-plugin-loki | 439-r2 |
| Wolfi | trino-plugin-mariadb | 439-r2 |
| Wolfi | trino-plugin-memory | 439-r2 |
| Wolfi | trino-plugin-ml | 439-r2 |
| Wolfi | trino-plugin-mongodb | 439-r2 |
| Wolfi | trino-plugin-mysql | 439-r2 |
| Wolfi | trino-plugin-mysql-event-listener | 439-r2 |
| Wolfi | trino-plugin-opa | 439-r2 |
| Wolfi | trino-plugin-openlineage | 439-r2 |
| Wolfi | trino-plugin-opensearch | 439-r2 |
| Wolfi | trino-plugin-oracle | 439-r2 |
| Wolfi | trino-plugin-password-authenticators | 439-r2 |
| Wolfi | trino-plugin-pinot | 439-r2 |
| Wolfi | trino-plugin-postgresql | 439-r2 |
| Wolfi | trino-plugin-prometheus | 439-r2 |
| Wolfi | trino-plugin-ranger | 439-r2 |
| Wolfi | trino-plugin-redis | 439-r2 |
| Wolfi | trino-plugin-redshift | 439-r2 |
| Wolfi | trino-plugin-resource-group-managers | 439-r2 |
| Wolfi | trino-plugin-session-property-managers | 439-r2 |
| Wolfi | trino-plugin-singlestore | 439-r2 |
| Wolfi | trino-plugin-snowflake | 439-r2 |
| Wolfi | trino-plugin-spooling-filesystem | 439-r2 |
| Wolfi | trino-plugin-sqlserver | 439-r2 |
| Wolfi | trino-plugin-teradata-functions | 439-r2 |
| Wolfi | trino-plugin-thrift | 439-r2 |
| Wolfi | trino-plugin-tpcds | 439-r2 |
| Wolfi | trino-plugin-tpch | 439-r2 |
| Wolfi | trino-plugin-vertica | 439-r2 |
| openSUSE Leap 15.5 | postgresql-jdbc | 42.2.25-150400.3.12.1 |