How to use HSQLDB as a datasource in Websphere Application Server?

In the example given in BDCP docs, the org.hsqldb. JdbcDriver class is used as the driver. The org.hsqldb.jdbc.

JDBCDriver is supported only in HSQLDB 2. X, but the other class is supported by all versions of HSQLDB.

Up vote 0 down vote favorite share g+ share fb share tw.

I try to set up a local development infrastructure and I want to use HSQLDB as a datasource with my WAS 6.1. I already know that I have to use Apache DBCP to get a connection pooling, but I'm stuck when my application tries to get the first connection. What I've done In WAS I created a JDBC provider with the class org.apache.commons.dbcp.cpdsadapter. DriverAdapterCPDS and removed everything from the classpath input field.

Then I put commons-dbcp. Jar, commons-pool. Jar and hsqldb.

Jar in MYAPPSERVERDIRECTORY/lib/ext. Then I created a new datasource with that provider. I added the following custom properties: driver=org.hsqldb.jdbc.

JDBCDriver url=jdbc:hsqldb:file:///C:/mydatabase. Db;shutdown=true user=SA password= My Problem When I run my application and the first connection to the database is made, I get the following exception: ---- Begin backtrace for Nested Throwables java.sql. SQLException: No suitable driverDSRA0010E: SQL-Status = 08001, Fehlercode = 0 at java.sql.DriverManager.

GetConnection(DriverManager. Java:592) at java.sql.DriverManager. GetConnection(DriverManager.

Java:196) at org.apache.commons.dbcp.cpdsadapter. DriverAdapterCPDS. GetPooledConnection(DriverAdapterCPDS.

Java:205) at com.ibm.ws.rsadapter.spi. InternalGenericDataStoreHelper$1. Run(InternalGenericDataStoreHelper.

Java:918) at com.ibm.ws.security.util. AccessController. DoPrivileged(AccessController.

Java:118) at com.ibm.ws.rsadapter.spi. InternalGenericDataStoreHelper. GetPooledConnection(InternalGenericDataStoreHelper.

Java:955) at com.ibm.ws.rsadapter.spi.WSRdbDataSource. GetPooledConnection(WSRdbDataSource. Java:1437) at com.ibm.ws.rsadapter.spi.

WSManagedConnectionFactoryImpl. CreateManagedConnection(WSManagedConnectionFactoryImpl. Java:1089) at com.ibm.ejs.

J2c.FreePool. CreateManagedConnectionWithMCWrapper(FreePool. Java:1837) at com.ibm.ejs.

J2c.FreePool. CreateOrWaitForConnection(FreePool. Java:1568) at com.ibm.ejs.

J2c.PoolManager. Reserve(PoolManager. Java:2338) at com.ibm.ejs.

J2c. ConnectionManager. AllocateMCWrapper(ConnectionManager.

Java:909) at com.ibm.ejs. J2c. ConnectionManager.

AllocateConnection(ConnectionManager. Java:599) at com.ibm.ws.rsadapter.jdbc. WSJdbcDataSource.

GetConnection(WSJdbcDataSource. Java:439) at com.ibm.ws.rsadapter.jdbc. WSJdbcDataSource.

GetConnection(WSJdbcDataSource. Java:408) Any tips on this? I suspect I'm using a wrong class from hsqldb, or maybe my JDBC url is wrong... jdbc websphere hsqldb link|improve this question asked May 20 '11 at 6:43cringe1,25511544 67% accept rate.

Ah, ok. I'm using hsqldb 2.0 for my tests. – cringe May 22 '11 at 17:12 And it is likely BDCP does not know about the new class name, so you need to use the old class name.

– fredt May 22 '11 at 18:41.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.