JDBC: Updating to pgjdbc 42.7.5 and 42.7.6 blocked

[amotl]

Problem

pgjdbc 42.7.5 does not work well together with CrateDB, some of the qa tests started failing on it.

• Bump org.postgresql:postgresql from 42.7.4 to 42.7.5 in /by-language/java-qa cratedb-examples#804
• JDBC: Update to pgjdbc 42.7.7 crate-qa#333

Downstream

• Build(deps): Bump org.postgresql:postgresql from 42.7.3 to 42.7.5 cratedb-flink-jobs#56
• Bump org.postgresql:postgresql from 42.7.4 to 42.7.5 in /modules/cratedb testcontainers/testcontainers-java#9835

[amotl]

@mackerl also reported this recently. Thank you!

The PostgreSQL driver seems to have added changes to getColumn, getTables, etc. CrateDB seems to return an empty resultSet on many occasions which makes our application unusable.

I nailed it down to commit pgjdbc/pgjdbc@17cac52 "Fix PgDatabaseMetaData implementation of catalog as param and return value".

[amotl]

@kneth staged reports and patches to crate/crate and pgjdbc/pgjdbc. Thanks!

• Column name for scalar function call should be the function name, not the evaluated literal (JDBC compat issue) crate#17393
• Improve compatibility with non-Postgres databases pgjdbc/pgjdbc#3527
• Set column name explicitely when using current_database() in queries pgjdbc/pgjdbc#3526

[amotl]

Status

pgjdbc 42.7.6, released yesterday, still does not work well together with CrateDB.

• Bump org.postgresql:postgresql from 42.7.4 to 42.7.6 in /by-language/java-qa cratedb-examples#952

Problem

PSQL ERROR: Column current_catalog unknown

-- https://github.com/crate/cratedb-examples/actions/runs/15315448586/job/43088313012?pr=952#step:8:1472

[kneth]

Currently waiting for crate/crate#17951

[amotl]

Let's resolve this, while accompanying it with some notes about relevant limitations?

• Document limitations of PG JDBC versions crate#18041

Thanks to all who participated to improve the situation.