• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

HSQLDB and running the scripts in manual installation

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Using a command line utility, go to the directory [i]WEB-INF/config/database/hsqldb, then type this command:



in the field "Type", select "Engine Standalone" and, for the URL field, type



now just paste the script in the textarea and execute the query.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

I'm attempting to install using the manual installation instructions. The db type I want to use is hsqldb.

I am stuck on the 'Creating the database tables' step of the install.
I do not know how to run the sql file. I know if I was using MySQL I would simply run a command and give the file as an input arg, but how do i go about runing the script for hsqldb???

Thanks very much,
Mike
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rafael,

i know i need the hsqldb-1.8rc9.jar file in place of the hsqldb-1.7.3.0.jar

but how do i run the script?
I do NOT want to use the automatic web page method, but rather I'm trying to install JForum using the manual instruction set. It tells me to run the script but how do i run the script?? where do i run the script??

In your post you said to select 'engine standalone' as type. Is this some variable that has to be changed in a porperties file somewhere? What about the url?


thanks very much for your help!
mike

[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Exactly as I explained before

When you type the command



a window will open, showing to you the HSQLDB manager. In this window, select "Engine Standalone" for "type" and, in the URL field, paste "jdbc:hsqldb:file:jforum", and then click ok.

Now you'll have the hsqldb manager loaded, and there you'll see a text field to execute sql statements. Then simply open the sql files for hsqldb (WEB-INF/config/dataabse/hsqldb) in any text editor and paste the sql in hsqldb's manager.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see.

Is there any way I can run the script without having to open the HSQLDB manager and load the script into the text field?

If I was to use the web page to install jforum, there is no need to open the HSQLDB manager. How can I make this automatic?

I'll tell you what I'm trying to do. I'm trying to write a java program that will install jforum automatically just like your webpage installer does, but not have to fill out the values in the web page.
I know what values I would select on the web page so I want to make the installation automatic, without having to use the web interface.

thanks Rafael for your help.
gmb
[originally posted on jforum.net by gmb]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, then all you have to do, if you know Java programming, is to create a JDBC connection and execute all queries.
The connection string could be the same which comes with jforum:



then, once you have the connection, it's all a matter of calling statement.executeUpdate(query).

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can also call scripts with the sqltool :

http://hsqldb.sourceforge.net/doc/guide/ch07.html#nonint-section
[originally posted on jforum.net by marc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
LOL!! I know there must be an easier way . Thanks Marc.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!