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]
i know i need the hsqldb-1.8rc9.jar file in place of the hsqldb-126.96.36.199.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?
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]
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]