JDBC Connection error with Exasol

Jonathan_Walker1 · August 28, 2024, 4:28pm

*WmJDBCAdapter used and **JDBC_9.0_Fix8* - on 9.8 but will be trying on 10.15 soon

Error enabling jdbc connection with Exasol database

*Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource uuBsSharedStatusUpdatesConns.connections:exasol.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
com.exasol.jdbc.EXADriver cannot be cast to javax.sql.DataSource*

I’ve installed exajdbc.jar in to the WmJDBCAdapter jars folder

I’ve tried a couple of different approaches re:config set up (and variations of these), but no success yet.

JDBC | Exasol DB Documentation

Holger_von_Thomsen · August 28, 2024, 5:00pm

Hi Jonathan,

as the error message indicates the Driver class cannot be used with the JDBC Adapter package, as it cannot be directly casted to base java DataSource class.

Please try to connect using the EXADataSource class instead.
This information can be found in the Exasol driver documentation you have already referenced above under the chapter “Supported Interfaces”.

The config variant in the first screenshot should be the preferred one as it is easier to maintain.

Regards,
Holger

Jonathan_Walker1 · August 29, 2024, 8:16am

Hi, i had thought that , but also got

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource uuBsSharedStatusUpdatesConns.connections:exasol. [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. com.exasol.jdbc.EXADataSource cannot be cast to javax.sql.DataSource

But then i was assured by our Exasol team that it was the EXADriver that was needed. Thanks for your response, i’ll keep plodding on!

Holger_von_Thomsen · August 29, 2024, 12:43pm

Hi Jonathan,

hopefully, you have access to Exasol support team. In this case, report this issue to them to get this verified why the ExaDataSource class is not implementing or extending the javax.sql.DataSource class.

If this is not possible, you willl have to fall back to WmDB package, which works with the Driver class and not with the DataSource class.