HSQLDB connection
Felipe Palma Dias <palmadias-/E1597aS9LRfJ/[email protected]>
| Newsgroups | gmane.comp.java.openjms.user |
|---|---|
| Message-ID | <[email protected]> |
I am try to use HSQLDB together openJMS. When I start
the openJMS service, the follow exception is showed:
org.exolab.jms.server.ServerException:
org.exolab.jms.persistence.PersistenceException:
org.apache.commons.dbcp.SQLNestedException: Cannot
create PoolableConnectionFactory, cause:
java.sql.SQLException: Connection is broken:
localhost/pakcon
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:205)
at
org.hsqldb.jdbcConnection.reconnectHSQL(jdbcConnection.java:865)
at
org.hsqldb.jdbcConnection.openHSQL(jdbcConnection.java:833)
at
org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:678)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at
org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:119)
at
org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:709)
at
org.exolab.jms.persistence.RDBMSAdapter.<init>(RDBMSAdapter.java:180)
at
org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(DatabaseService.java:236)
at
org.exolab.jms.persistence.DatabaseService.<init>(DatabaseService.java:163)
at
org.exolab.jms.persistence.DatabaseService.instance(DatabaseService.java:115)
at
org.exolab.jms.server.JmsServer.registerServices(JmsServer.java:274)
at
org.exolab.jms.server.JmsServer.init(JmsServer.java:185)
at
org.exolab.jms.server.JmsServer.main(JmsServer.java:229)
at
com.pakprint.pakcon.client.service.PCAgent.startOpenJMS(PCAgent.java:248)
at
com.pakprint.pakcon.client.service.PCAgent.start(PCAgent.java:322)
at
org.tanukisoftware.wrapper.WrapperManager.startInner(WrapperManager.java:1785)
at
org.tanukisoftware.wrapper.WrapperManager.handleSocket(WrapperManager.java:2384)
at
org.tanukisoftware.wrapper.WrapperManager.run(WrapperManager.java:2696)
at java.lang.Thread.run(Thread.java:534)
My HSQLSB is running!
---------- openjms.xml ----------------------
<DatabaseConfiguration>
<RdbmsDatabaseConfiguration
driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/pakcon"
user="sa"
password="" />
</DatabaseConfiguration>
----------------------------------------------
If I run a simple java test I connect in the database.
For example:
----------------------------------------------
Class.forName("org.hsqldb.jdbcDriver");
Connection connection =
DriverManager.getConnection(
"jdbc:hsqldb:hsql://localhost/pakcon", "sa",
"");
----------------------------------------------
=====
-------------------------------------------------------
Felipe F. Palma Dias
http://geocities.yahoo.com.br/palmadias/
_______________________________________________________
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click