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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.