-
1. Re: How to connect Hypersonic's query program to jboss' cmp?
banigreyling Nov 7, 2001 9:15 AM (in response to alexmack)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. -
2. Re: How to connect Hypersonic's query program to jboss' cmp?
sikandar Nov 9, 2001 5:06 PM (in response to alexmack)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. -
3. Re: How to connect Hypersonic's query program to jboss' cmp?
youandwhosearmy Nov 14, 2001 3:33 PM (in response to alexmack)This is the best tip I have read so far!
Thanks sikander! -
4. Re: How to connect Hypersonic's query program to jboss' cmp?
brucec Apr 18, 2003 3:20 PM (in response to alexmack)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 -
5. Re: How to connect Hypersonic's query program to jboss' cmp?
colway May 27, 2003 11:23 AM (in response to alexmack)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? -
6. Re: How to connect Hypersonic's query program to jboss' cmp?
colway May 27, 2003 11:44 AM (in response to alexmack)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. -
7. Re: How to connect Hypersonic's query program to jboss' cmp?
74greg Aug 20, 2003 8:16 AM (in response to alexmack)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? -
8. Re: How to connect Hypersonic's query program to jboss' cmp?
daborg Sep 2, 2003 6:25 AM (in response to alexmack)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 -
9. Re: How to connect Hypersonic's query program to jboss' cmp?
74greg Sep 2, 2003 6:31 AM (in response to alexmack)Thanks for replying Daborg.