Hello,
I see that there are two JDBC drivers available for crate to connect from Java code. First is GitHub - crate/crate-jdbc: A JDBC driver for CrateDB.
and second is GitHub - pgjdbc/pgjdbc: Postgresql JDBC Driver. I tried some proof of concept using the first one and my target was achieved. But I later realized that you recommend second driver. There is not much development happening on the one I used and there is no release on it after April 2023. Is it that this driver will go out of support ? If yes what is end of life for first driver?
Any help appreciated.
Hi @gorde.akshay,
you are right, we do recommend using official Postgresl Driver for general purpose use.
However, there are some cases where crate-jdbc driver is needed and therefore this driver is still supported.
Thank you for replying. Which cases are not solved by the official Postgresl Driver. That will help me decide to select the correct driver to use in my code.
Some differences are noted here Internals
For example, if your app uses transactions which are not supported by CrateDB, you need to use crate-jdbc as it will turn ROLLBACK to a no-op.
Some tools can issue queries against pg_catalog tables and functions that we don’t currently support.
I would recommend trying official Postgresql Driver first and check if it works (make sure to check all aspects).
If it doesn’t work then try crate-jdbc.