You can translate the question and the replies:

Denodo driver does not support datasource pooling

I am trying to connect to Denodo server using VDB JDBC driver. I want to access it through a WebSphere Application Server Application where I am trying to set a Pooled data source with following config: Implementation class: com.denodo.vdb.jdbcdriver.x.VDBJDBCConnectionPoolDataSource Helper class: com.ibm.websphere.rsadapter.GenericDataStoreHelper But I am getting back: java.sql.SQLException: This driver does not support datasource pooling. DSRA0010E: SQL State = null, Error Code = 0 Did anyone face similar issue? Am I using wrong Implementation class name? Also what property will be driver looking at for URL ?
Driver JDBC
user
01-02-2017 17:43:34 -0500
code

3 Answers

Hi, I was able to connect VDP server from WebSphere, to get it work I suggest you to copy the files $DENODO_HOME/lib/vdp-jdbcdriver-core/denodo-vdp-jdbcdriver-basic.jar $DENODO_HOME/lib/contrib/commons-dbcp.jar $DENODO_HOME/lib/contrib/commons-pool.jar to the directory $WEBSPHERE_HOME/AppServer/lib/denodo_jdbc_driver Create a New JDBC provider, Select Database type = User-defined and Implementation class name = org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS In Custom properties, of the created JDBC Data source Set the following values. Database Driver Class: com.denodo.vdp.jdbc.Driver Connection String: jdbc:vdb://<hostname>:<port>/<databasename> Username: <VDP Username> Password: <VDP Password> Hope this helps.
Denodo Team
03-02-2017 07:11:51 -0500
code
I tried following exactly as mentioned above, I got following error: java.sql.SQLException: No suitable driver found for jdbc:vdb://server-name:9999/admin DSRA0010E: SQL State = 08001, Error Code = 0 I tried all the following custome property values: url: jdbc:vdb://lvappdno000002x:9999/admin DriverClass: com.denodo.vdp.jdbc.Driver driver: com.denodo.vdp.jdbc.Driver user: admin password: <password> username: admin Connection String: jdbc:vdb://lvappdno000002x:9999/admin Database Driver Class: com.denodo.vdp.jdbc.Driver Following was class provider Class path: ${DENODO_JDBC_DRIVER}/commons-dbcp.jar ${DENODO_JDBC_DRIVER}/commons-pool.jar ${DENODO_JDBC_DRIVER}/denodo-vdp-jdbcdriver-basic.jar Am I doing any step wrong?
user
06-02-2017 16:55:14 -0500
Probably, Denodo JDBC driver jar file was not correctly added to the classpath of the application.
Denodo Team
16-10-2019 08:24:44 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here