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.
The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.
Name | Vendor | Start Version | End Version |
---|---|---|---|
Postgresql_jdbc_driver | Postgresql | * | 42.2.28 (excluding) |
Postgresql_jdbc_driver | Postgresql | 42.3.0 (including) | 42.3.9 (excluding) |
Postgresql_jdbc_driver | Postgresql | 42.4.0 (including) | 42.4.4 (excluding) |
Postgresql_jdbc_driver | Postgresql | 42.5.0 (including) | 42.5.5 (excluding) |
Postgresql_jdbc_driver | Postgresql | 42.6.0 (including) | 42.6.1 (excluding) |
Postgresql_jdbc_driver | Postgresql | 42.7.0 (including) | 42.7.2 (excluding) |
Red Hat build of Apache Camel 4.4.1 for Spring Boot 3.2 | RedHat | pgjdbc | * |
Red Hat build of Keycloak 24 | RedHat | pgjdbc | * |
Red Hat build of Quarkus 2.13.9.SP2 | RedHat | org.postgresql/postgresql:42.5.6.redhat-00001 | * |
Red Hat build of Quarkus 3.2.11.Final | RedHat | org.postgresql/postgresql:42.6.1.redhat-00001 | * |
Red Hat Enterprise Linux 8 | RedHat | postgresql-jdbc-0:42.2.14-3.el8_9 | * |
Red Hat Enterprise Linux 8.2 Advanced Update Support | RedHat | postgresql-jdbc-0:42.2.3-5.el8_2 | * |
Red Hat Enterprise Linux 8.2 Telecommunications Update Service | RedHat | postgresql-jdbc-0:42.2.3-5.el8_2 | * |
Red Hat Enterprise Linux 8.2 Update Services for SAP Solutions | RedHat | postgresql-jdbc-0:42.2.3-5.el8_2 | * |
Red Hat Enterprise Linux 8.4 Advanced Mission Critical Update Support | RedHat | postgresql-jdbc-0:42.2.3-7.el8_4 | * |
Red Hat Enterprise Linux 8.4 Telecommunications Update Service | RedHat | postgresql-jdbc-0:42.2.3-7.el8_4 | * |
Red Hat Enterprise Linux 8.4 Update Services for SAP Solutions | RedHat | postgresql-jdbc-0:42.2.3-7.el8_4 | * |
Red Hat Enterprise Linux 8.6 Advanced Mission Critical Update Support | RedHat | postgresql-jdbc-0:42.2.3-5.el8_6 | * |
Red Hat Enterprise Linux 8.6 Telecommunications Update Service | RedHat | postgresql-jdbc-0:42.2.3-5.el8_6 | * |
Red Hat Enterprise Linux 8.6 Update Services for SAP Solutions | RedHat | postgresql-jdbc-0:42.2.3-5.el8_6 | * |
Red Hat Enterprise Linux 8.8 Extended Update Support | RedHat | postgresql-jdbc-0:42.2.14-5.el8_8 | * |
Red Hat Enterprise Linux 9 | RedHat | postgresql-jdbc-0:42.2.28-1.el9_3 | * |
Red Hat Enterprise Linux 9.0 Extended Update Support | RedHat | postgresql-jdbc-0:42.2.28-1.el9_0 | * |
Red Hat Enterprise Linux 9.2 Extended Update Support | RedHat | postgresql-jdbc-0:42.2.28-1.el9_2 | * |
RHEL-8 based Middleware Containers | RedHat | rh-sso-7/sso76-openshift-rhel8:7.6-42 | * |
RHEL-8 based Middleware Containers | RedHat | rh-sso-7/sso7-rhel8-operator-bundle:7.6.7-4 | * |
RHINT Camel-K 1.10.7 | RedHat | pgjdbc | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-data-index-ephemeral-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-data-index-postgresql-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-jobs-service-ephemeral-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-jobs-service-postgresql-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-kn-workflow-cli-artifacts-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-operator-bundle:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-rhel8-operator:1.33.0-3 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-swf-builder-rhel8:1.33.0-5 | * |
RHOSS-1.33-RHEL-8 | RedHat | openshift-serverless-1/logic-swf-devmode-rhel8:1.33.0-5 | * |
Libpgjava | Ubuntu | bionic | * |
Libpgjava | Ubuntu | focal | * |
Libpgjava | Ubuntu | mantic | * |
Libpgjava | Ubuntu | trusty | * |
Libpgjava | Ubuntu | trusty/esm | * |
Libpgjava | Ubuntu | upstream | * |
Libpgjava | Ubuntu | xenial | * |