0 Replies Latest reply on Nov 6, 2002 9:26 AM by Twan Prive

    Connect to hsqldb in jbuilder?

    Twan Prive Newbie

      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