total noob: java, hsqldb, FreeQueryBuilder

[Megan Garrison]

Hi - I am totally new all this (including java and cmd line) but am eager to learn - I am running windows 2k and am wanting to learn to use hsqldb but am not thrilled with the dbmanager that comes with.  I did a search and found your freequerybuilder and downloaded the latest jar file.  could you tell me in baby steps where to put the jar file and what to do next to be able to use it as an interface to hsqldb.  Or if you think I should use something else to interface, could you tell me that too? thanks, megan

[nickyb]

Hi megan,
put the FQB jar file where you want (example c:\FreeQueryBuilder).
To run doubleclick or run a cmd window and type this 2 commands:
  cd c:\FreeQueryBuilder

  java -jar fqb2005xx.jar

Open the JDBC Administrator window, choose the $Runtime tab and 'add...' the hsqldb.jar file.
Add a new <driver-item> on the <jdbc-tree> and fill fields:
   name = HSQLDB
   file = (select 'hsqldb.jar' previously added)
   driver = org.hsqldb.jdbcDriver
   example = jdbc:hsqldb:<file>

Apply!

Add a new <connection-item> on the <jdbc-tree> and fill fields:
   name = Test
   url = jdbc:hsqldb:c:\freequerybuilder\db\test
(example directory 'c:\freequerybuilder\db' must exists, 'test' is database file name, it would created if not found, read HSQLDB documentation)
   user = sa
   password = <nothing>
  
Apply! Connect!

Now at 'c:\freequerybuilder\db' a database named 'test' would exists!

To build tables and more you can use the 'sql command view' and refer to hsqldb manual for sql-syntax.
Example:
CREATE TABLE mytable(myfield1 char(50));

Note: after table creation refresh the browser to view changes.

sorry for my bad english... ;)

[Megan Garrison]

Hi Nicky - Thanks! and you don't need to apologize for your English - your instructions were/are very clear and helpful - thanks again, :D Megan