Re: HSQLDB connection

 --- Felipe Palma Dias <palmadias-/E1597aS9LRfJ/[email protected]>
escreveu: 
> 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
> _______________________________________________
> openjms-user mailing list
> [email protected]
>
https://lists.sourceforge.net/lists/listinfo/openjms-user
>  

=====
------------------------------------------------------- 
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