webMethods

*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

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/0e3101b3c5228b628df7380f5724ffc9054bfda0.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/0e3101b3c5228b628df7380f5724ffc9054bfda0.jpeg 2x" data-dominant-color="D5D6CE">

Exasol1551×538 74.9 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/0a4cb30e9cf979f2834cae5d1d15a8776dba5258.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/0a4cb30e9cf979f2834cae5d1d15a8776dba5258.jpeg 2x" data-dominant-color="D6D6CE">

Exasol2617×547 81.1 KB

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

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!

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.

Regards,
Holger

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/b0e0ef624ec5942d89a91db85040ca30289f1711_2_1035x598.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/b0e0ef624ec5942d89a91db85040ca30289f1711.png 2x" data-dominant-color="EFEFEF">

Exasol31112×644 51.8 KB

Hi, i have now got it configured on 10.15 with the following set up and the connection enables. Thanks for your help.