Installation of Nukes - HSQLDb

[regismelo]

Hello!

From Nukes Installation guide:

"Set the environment variable JBOSS_HOME to the jboss installation.
Create Nukes tables by sourcing the file nukes/nukes/src/resources/hsqldb/setup.ddl into hsqldb. The best way to achieve that is to connect to hsqldb through an util like squirrel sql."

I've to install HSQLDB? HSQLDB comes with Nukes? How can I do that?

I never use HSQLDB....

[jmatt]

HSQLdb comes with JBoss. It is the default datasource mapped to DefaultDS. point what ever database tool you use, I prefer dbVisualizer from www.minq.se. The jdbc url is jdbc:hsqldb:hsql://localhost:1701 and the driver is org.hsqldb.jdbcDriver username sa no password.

[julien1]

HSQLDB is the database embedded with JBoss, si you have nothing to do to install it.

julien

[h2o_polo]

It comes with jboss
just start the server and run squirrel or whatever you use connect to the port 1701 with the hsqldb driver and run the script. Should work

[theute]

If i can help, i try.

Lucky you, HSQLDB is included.

To create the table using the file setup.dll, you can use as suggested SquirrelSql, i guess you won't have troubles to install it, i don't know about Windows, if you have troubles with Linux i can help.

You should see a list of servers, select HSQLDB Server (double click on it)
you will see the propoerties, for the Example URL enter:
jdbc:hsqldb:hsql://localhost:1701
You may have to add jboss-3.2.0RC4/server/all/lib/hsqldb.jar to your classpath.

Then in aliases, you enter 'sa' as user and no password you should see a place to put your requests.

Welcome to the world.


Nukes is Magic, merci Coop'
Thomas.

[theute]

If i can help, i try.

Lucky you, HSQLDB is included.

To create the table using the file setup.dll, you can use as suggested SquirrelSql, i guess you won't have troubles to install it, i don't know about Windows, if you have troubles with Linux i can help.

You should see a list of servers, select HSQLDB Server (double click on it)
you will see the propoerties, for the Example URL enter:
jdbc:hsqldb:hsql://localhost:1701
You may have to add jboss-3.2.0RC4/server/all/lib/hsqldb.jar to your classpath.

Then in aliases, you enter 'sa' as user and no password you should see a place to put your requests.

Welcome to the world.


Nukes is Magic, merci Coop'
Thomas.

[theute]

If i can help, i try.

Lucky you, HSQLDB is included.

To create the table using the file setup.dll, you can use as suggested SquirrelSql, i guess you won't have troubles to install it, i don't know about Windows, if you have troubles with Linux i can help.

You should see a list of servers, select HSQLDB Server (double click on it)
you will see the propoerties, for the Example URL enter:
jdbc:hsqldb:hsql://localhost:1701
You may have to add jboss-3.2.0RC4/server/all/lib/hsqldb.jar to your classpath.

Then in aliases, you enter 'sa' as user and no password you should see a place to put your requests.

Welcome to the world.


Nukes is Magic, merci Coop'
Thomas.

[rsaccon]

HSQLDB is already embedded in Jboss. You just have to import the tables, otherwise nukes will not work.
But if you don't want HSQLDB, you can also use mysql, which you have to install by yourself seperatly.

[h2o_polo]

theese forums really suck.
Look at all this latency in posting the messages.

on the other hand the guy got six answers instead of one!!!! wow :-)

[theute]

Yes, sorry for my many messages, i hope it made things clearer :)

The latency is aweful, i thought nobody replied as i didn't see any reply, i post and reload and nothing so i did again and nothing and again...

One hour later my messages were there with few other before mine...

Cooper, during your free time, you should finish the forums on JBoss :)

[yanikc]

Lets start to be serious.

1. What is the suggested way to setup and populate the HSQL database?

Answer: Use GUI based open source (free) SQL client like Squirel SQL.

2- Where can I find Squirel SQL?

Answer: At http://sourceforge.net/projects/squirrel-sql/

3- There is many file that could be donwloaded, which one should I use?

Answer: If you have not figured out yet, you are probably a Windows user. (Linux users never ask such a question). So choose win9598-squirrel-sql-1.1final1-install.jar.

4- I have downloaded win9598-squirrel-sql-1.1final1-install.jar from sourceforge, how can I run it?

Answer: Open a console window on your PC running Windows and type java -jar win9598-squirrel-sql-1.1final1-install.jar. That should launch the installation program.

5- Squirel SQL client is installed. How can I start it?

Answer: Go to the C:\Program Files\SQuirreL SQL Client directory and double-click on squirrel-sql.bat

6-How can I tell Squirrel SQL client to connect with the HSQL running within the jBoss environement?

Answers:
a) You have to install the correct driver. To do that, you go on the "Drivers" pannel, single click on the HSQLDB_Server in the list and click on the + at the top.

b)You click on "Extra Class Path" tab and make sure to add the following file:
"C:\jboss-3.2.0RC4\server\default\lib\hsqldb.jar"

c)On the Class Name field you type org.hsqldb.jdbcDriver.

d) The Name: field (at the top) should contain HSQL_DB and the Example URL: jdbc:hsqldb:hsql://localhost:1701

e) Once done, click OK.

f) On the Alias panel, click the + sign. That will bring you an extra panel.

g) On the Name field, type JBoss

e) On the Driver: pop-up list, choose the appropriate driver (HSQL_DB you just configured). The suggested URL should be OK (jdbc:hsqldb:hsql://localhost:1701) and the User Name is sa

f) Once done, close the panel by clicking OK.

g) Double-click on the JBoss alias (in the alias panel).

h) There is no password (let the field empty).

7- OK, I am connected, what's next?

Answers:

a) Using your prefered text editor, open the setup.ddl file (don't double-click, open the text editor and from inside the text editor open the setup.dll). The setup.ddl is located in the nukes\nukes\src\resources\hsqldb directory. Copy it entire content.

b) Back to the Squirrel SQL Client, click on the SQL tab.

c) Uncheck the Limit Rows: checkbox

d) Paste the content you just copied from setup.ddl to the text field.

e) At the top, you have few icons. The third one from left represents someone running. That will run the SQL statements you just pasted. Click on that icon.

f) Click on the Objects tab. The second icon from left (just next the running icon) means refresh. Click on it.


On the table directory, four (4) new tables have been added: NUKE_FILE, NUKE_GROUPS, NUKE_GROUP_MEMBERSHIP and NUKE_USERS.