Connect to hsqldb in jbuilder?
As a test i've created a project with a session bean and a cmp 2.0 entity bean. I've also created a test client. My test client calls a method getName() on the session bean, then the methode getName() calls findByPrimaryKey() of the home interface of the cmp bean to find a record. Works great!
When i'm in jbuilder7 and have started a jboss server via jbuilder (key F9) (with the opentools from protega) i can't access the hsqldb (hypersonic?) which is integrated into jboss. I think i've tryed every possible url:
===========
jdbc:hsqldb:hsql://localhost
===========
See com.borland.dx.dataset.DataSetException error code: BASE+66com.borland.dx.dataset.DataSetException: Connection is broken: Connection refused: connect at com.borland.dx.dataset.DataSetException.a(Unknown Source)
..Chained exception:java.sql.SQLException: Connection is broken: Connection refused: connect at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source)..
===========
jdbc:hsqldb:hsql://localhost:1476
===========
See com.borland.dx.dataset.DataSetException error code: BASE+62com.borland.dx.dataset.DataSetException: Execution of query failed. at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.queryFailed(Unknown Source)
..Chained exception:java.sql.SQLException: Transfer corrupted at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source)
..
===========
jdbc:hsqldb:http://localhost
===========
See com.borland.dx.dataset.DataSetException error code: BASE+66com.borland.dx.dataset.DataSetException: Connection is broken: Connection refused: connect at com.borland.dx.dataset.DataSetException.a(Unknown Source)
..Chained exception:java.sql.SQLException: Connection is broken: Connection refused: connect at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source)..
I tryed the manager supplied with hsqldb and the Database Pilot supplied with jbuilder.
When i quit jbuilder and start jboss via the commandline (run.bat) i can access the hsqldb integrated in jboss with hsqldb's manager jbuilder's and database pilot.
Best regards,
Twan Kogels