-
1. Re: Exception: No suitable driver found for jdbc:hsqldb:mem:test
bitec_alisovenko Aug 2, 2011 8:24 AM (in response to bitec_alisovenko)I really cannot understand, why hsql driver is not seen... Here is the snapshot for my bundle, you can see, that the hsql driver is the fragment of my bundle, so it should be seen by all related bundles....
Symbolic Name drfusion-ws
Version 1.0.0.SNAPSHOT
Bundle Location file:/C:/apache-servicemix-4.3.1-fuse-00-00/deploy/drfusion-ws-1.0-SNAPSHOT.jar
Last Modification Tue Aug 02 16:12:37 MSD 2011
Description DRFusion Web service
Start Level 60
Fragments Attached com.springsource.org.hsqldb (233)
Exported Packages com.mycompany.drf.cxf,version=1.0.0.SNAPSHOT
org.hsqldb,version=1.8.0.10
org.hsqldb.index,version=1.8.0.10
org.hsqldb.jdbc,version=1.8.0.10
org.hsqldb.lib,version=1.8.0.10
org.hsqldb.lib.java,version=1.8.0.10
org.hsqldb.persist,version=1.8.0.10
org.hsqldb.resources,version=1.8.0.10
org.hsqldb.rowio,version=1.8.0.10
org.hsqldb.sample,version=1.8.0.10
org.hsqldb.scriptio,version=1.8.0.10
org.hsqldb.store,version=1.8.0.10
org.hsqldb.types,version=1.8.0.10
org.hsqldb.util,version=1.8.0.10
org.hsqldb.util.sqltool,version=1.8.0.10
The exception is raised when the spring context is initialised and the database is generated () but this fails:
java.sql.SQLException: No suitable driver found for jdbc:hsqldb:mem:test
at java.sql.DriverManager.getConnection(DriverManager.java:602)[:1.6.0_20]
at java.sql.DriverManager.getConnection(DriverManager.java:154)[:1.6.0_20]
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)[225:com.springsource.org.hibernate:3.3.2.GA]
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)[225:com.springsource.org.hibernate
.3.2.GA]
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)[225:com.springsource.org.hibernate:3.3.2.GA]
Any help is appreciated!
-
2. Re: Exception: No suitable driver found for jdbc:hsqldb:mem:test
bitec_alisovenko Aug 2, 2011 8:55 AM (in response to bitec_alisovenko)Ok, I soved this.
HSQL driver should be the bundle not for my own bundle, but for the hibernate itself.
So, I added this row to the Manifest file for hsql bundle:
Fragment-Host: com.springsource.org.hibernate
and finally hibernate managed to connect to hsql db.
Very pity, that this wasn't described anywhere, this is a very common task - to communicate to db through connection pool/orm engine and so on.
-
3. Re: Exception: No suitable driver found for jdbc:hsqldb:mem:test
ffang Aug 8, 2011 12:19 AM (in response to bitec_alisovenko)Hi,
We've discussed similar issues before, please take a look at
http://fusesource.com/forums/thread.jspa?messageID=9780☴
Freeman