-
1. Re: Using DB browsing tools (like Squirrel)
tbfmicke Aug 8, 2002 12:57 PM (in response to olevy)I'm not sure how a thirdparty tool would do it, but there is a simple tool included with hypersonic.
Below is the content of my file 'run_hsql.bat' that I have created in my jboss/bin directory
-------------------------------
java -classpath ..\server\all\lib\hsqldb.jar org.hsqldb.util.DatabaseManager
------------------------------------
Running that file brings up the tool.
To connect when jboss is running you can select
Type: HSQL Database Engine Server with
URL: jdbc:hsqldb:hsql://localhost:1476
(User, sa, empty password).
To connect when jboss is not running you can give a path to the database and use
Type: HSQL Database Engine Standalone
URL: jdbc:hsqldb:..\server\default\db\hypersonic\default
Btw, the name of the driver is org.hsqldb.jdbcDriver so a thirdparty that understands JDBC might be able to connect with the same driver and URL's
Regards
Mikael