Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

PostgreSQL jdbc driver no longer works

JDBC consumer states "Note: When connecting to a PostgreSQL database, you do not need to install a JDBC driver. Data Collector includes the JDBC driver required for PostgreSQL." I see the file as postgresql-42.2.2.jar in the jdbc internal libraries, and use it successfully to read and write via JDBC.

I subsequently installed a MySQL driver in to the Extras directory, as specified by the JDBC Consumer and External Libraries documentation. It took 2 restarted to recognize the new JDBC driver, not one (contrary to documentation), but I am now successfully using the MySQL driver in JDBC and MySQL BinLog libs.

However, afterwards, I am now getting errors with Postgres JDBC access that JDBC driver is not found.

It seems that installing a 3rd party JDBC library prevents the JDBC lib from utilizing the pre-provided JDBC driver for Postgres. This is contrary to the above snippet from the documentation that I do NOT have to install Postgres JDBC driver.

So it seems a bug. I am going to try to install a 3rd party Postgres JDBC driver to circumvent the one that is pre-installed to see if that repairs it.

PostgreSQL jdbc driver no longer works

JDBC consumer states "Note: When connecting to a PostgreSQL database, you do not need to install a JDBC driver. Data Collector includes the JDBC driver required for PostgreSQL." I see the file as postgresql-42.2.2.jar in the jdbc internal libraries, and use it successfully to read and write via JDBC.

I subsequently installed a MySQL driver in to the Extras directory, as specified by the JDBC Consumer and External Libraries documentation. It took 2 restarted restarts to recognize the new JDBC driver, not one (contrary to documentation), but I am now successfully using the MySQL driver in JDBC and MySQL BinLog libs.

However, afterwards, I am now getting errors with Postgres JDBC access that JDBC driver is not found.

It seems that installing a 3rd party JDBC library prevents the JDBC lib from utilizing the pre-provided JDBC driver for Postgres. This is contrary to the above snippet from the documentation that I do NOT have to install Postgres JDBC driver.

So it seems a bug. I am going to try to install a 3rd party Postgres JDBC driver to circumvent the one that is pre-installed to see if that repairs it.