How to connect Hypersonic's query program to jboss' cmp?

[alexmack]

For debugging, I'd like to see what JBoss is writing via CMP. I see the QueryTool class in hsql.jar, but can't figure out the correct connection params to hook it to the running jboss instance of the database. Is there a shell script that accomplishes this anywhere?

(cross-posted from FAQ forum)

[banigreyling]

Alter your log4j.properties file so that your console appender is set to DEBUG instead of INFO i.e.

change line
log4j.appender.Console.Threshold=INFO

to
log4j.appender.Console.Threshold=DEBUG

(Assuming you are using JBoss.2.4.x)

This should print a lot of CMP activity to the console.

[sikandar]

Assuming you are using Hypersonic database for bean persistence.

You can query database through Hypersonic query manager.

Try java.exe -classpath %JBOSS_HOME%\lib\ext\hsql.jar org.hsql.util.DatabaseManager

Select database type as "HypersoncSQL server" and url "jdbc:HypersonicSQL:hsql://localhost:1476" assuming you are running jboss on local machine.

[youandwhosearmy]

This is the best tip I have read so far!

Thanks sikander!

[brucec]

Update on the great tip for 3.0.4 (probably same for 3.2, but haven't switched yet) from Linux. The following commands work for Hypersonic utilities:

$ java -cp $JBOSS_HOME/server/default/lib/hsqldb.jar org.hsqldb.util.DatabaseManager

$ java -cp $JBOSS_HOME/server/default/lib/hsqldb.jar org.hsqldb.util.QueryTool

$ java -cp $JBOSS_HOME/server/default/lib/hsqldb.jar org.hsqldb.util.Transfer

[colway]

I've been trying this (for the follwoing url: -url jdbc:hsqldb:hsql://:1476) but get the following error...
java.sql.SQLException: Connection is broken: Connection refused: connect
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.(jdbcConnection.java:678)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.hsqldb.util.ConnectionDialog.createConnection(ConnectionDialog.ja
va:107)
at org.hsqldb.util.ConnectionDialog.actionPerformed(ConnectionDialog.jav
a:276)
at java.awt.Button.processActionEvent(Button.java:381)
at java.awt.Button.processEvent(Button.java:350)
at java.awt.Component.dispatchEventImpl(Component.java:3526)
at java.awt.Component.dispatchEvent(Component.java:3367)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:445)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:191)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)

Any ideas?

[colway]

ok, just worked this out...
at some point the files under server/default/db/hypersonic had been created by root and the UNIX account running jboss did not have write permission to these files.
Fix was to chmod & chgrp files to the jboss user.

[74greg]

I've tried it, but it can't find the database manager:

C:\>java -classpath $JBOSS_HOME/server/default/lib/hsqldb.jar org.hsqldb.util.DatabaseManager

Exception in thread "main" java.lang.NoClassDefFoundError: org/hsqldb/util/DatabaseManager

what's wrong?

[daborg]

This will (probably) give you the information you need to figure out what's wrong:

unzip -l $JBOSS_HOME/server/default/lib/hsqldb.jar org/hsqldb/util/DatabaseManager.class

[74greg]

Thanks for replying Daborg.