Doltgresql does not yet support PostgreSQL's JDBC connection

[Ambitie]

Doltgresql does not yet support PostgreSQL's JDBC connection

I can only connect to the doltgresql database after setting assumeMinServerVersion=15. But after connecting to the doltgresql database, I cannot execute any queries.

[zachmu]

Thanks for the report @Ambitie. We're looking into this and should have an estimate for when you can expect this work in the near future.

[jennifersp]

Hi @Ambitie, I just got a PR out that might fix this issue here. Can you try testing with this change?

[timsehn]

Testing will require building from source: https://github.com/dolthub/doltgresql/blob/main/CONTRIBUTING.md#getting-set-up

[zachmu]

If you don't want to build from source, can you confirm the error you were getting looked like this?

org.postgresql.util.PSQLException: A result was returned when none was expected.

example.zip

I have a simple repro that fails with this error before Jennifer's change and passes after.

[zachmu]

@Ambitie we are pretty sure this is fixed in release 0.7.5, which is going out now.

To close this bug out, we need an automated client test of the JDBC functionality, similar to what Dolt has.

[bpf120]

@Ambitie , thanks again for filing this. We'd love to learn about your Doltgres use case. You can email me or swing by our Discord if you'd like to share.

[jennifersp]

Closing the issue as a test for it has been added #297