How do I update the JDBC driver?

[admin]

I’m querying clickhouse and DolhpinDB but the drivers bundled with Pulse/qStudio seem to be a few versions behind.
Can you upgrade them? Or how can I run the newest drivers?

[admin]

Both qStudio and Pulse dynamically download drivers on first use.

The locations they store drivers are:
C:\Users\{windows-username}\pulse\libs
C:\Users\{windows-username}\qstudio\libs
./lib

Notice that last ./lib is the current directory that you are running pulse from.

If you have used clickhouse or dolphindb, they should already contain files named:
clickhouse-jdbc-0.4.6.jar
jdbc-1.30.22.5-jar-with-dependencies.jar

To use new versions, you can delete and replace those files with any newer version from a maven repository.
For example from here https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc/0.6.0 the files section has a link to .jar file:
https://repo1.maven.org/maven2/com/clickhouse/clickhouse-jdbc/0.6.0/clickhouse-jdbc-0.6.0.jar

Then restart the application to pick up the new drivers.

We will update the drivers within Pulse and qStudio regularly but it requires manual testing and we won’t be doing this quickly for every version of all 30+ databases we support. So I hope this helps.

[Author]

Posts