Problems while using with JBoss

[Migrated From Jforum.net]

Hi,

I'm trying to use JForum in conjunction with JBoss 3.2.5. I've war'ed the Jforum-2.1.4 directory to a jforum.war and have placed it in the deploy directory of the default configuration. When I start the server, it's able to deploy the war file and I could also get to the index page of JForum.

Now when I try to install the database configuration for HSQLDB (that comes with JBoss), I am facing probelms. The following is the configuration I'm trying to install.

Database Type: HSQLDB
Connection Type: DataSource
DataSource Name: java:/DefaulDS

I get the error page that says:

Table not found: IF in statement [DROP TABLE IF EXISTS jforum_banlist;]
DROP TABLE IF EXISTS jforum_banlist;

I went and put some SOPs in the InstallAction.java file to see if the code is actually trying to use HSQLDB. Below is the log of my SOPs along with the ones that are already there.

12:16:41,386 INFO  [STDOUT] 12:16:41,386  INFO [InstallAction       ] Database configuration ok
12:16:41,386 INFO  [InstallAction] Database configuration ok
12:16:41,386 INFO  [STDOUT] 12:16:41,386  INFO [InstallAction       ] Going to create tables...
12:16:41,386 INFO  [InstallAction] Going to create tables...
12:16:41,386 INFO  [STDOUT] 12:16:41,386  INFO [InstallAction       ] *** AND THE DBTYPE IS hsqldb
12:16:41,386 INFO  [InstallAction] *** AND THE DBTYPE IS hsqldb
12:16:41,402 INFO  [STDOUT] 12:16:41,402  INFO [InstallAction       ] Dat File Name is: C:\kalyan\installations\servers\jboss
-3.2.5\server\default\tmp\deploy\tmp54373jforum.war/install/hsqldb_structure.dat
12:16:41,402 INFO  [InstallAction] Dat File Name is: C:\kalyan\installations\servers\jboss-3.2.5\server\default\tmp\deploy\tm
p54373jforum.war/install/hsqldb_structure.dat
12:16:41,417 INFO  [STDOUT] 12:16:41,417 ERROR [InstallAction       ] Error executing query: DROP TABLE IF EXISTS jforum_banl
ist;: java.sql.SQLException: Table not found: IF in statement [DROP TABLE IF EXISTS jforum_banlist;]
12:16:41,417 ERROR [InstallAction] Error executing query: DROP TABLE IF EXISTS jforum_banlist;: java.sql.SQLException: Table
not found: IF in statement [DROP TABLE IF EXISTS jforum_banlist;]

If you look at the above log, you will see "Going to create tables..." twice. I'm not sure why this particular method createTables in the InstallAction.java is getting called twice. This is the case with the default installation of jforum code as well. I don't know if this is the one that's causing any issues.

After this I changed the hsqldb_db_struct.dat file comment out all the "DROP..." statements, but it's of no use.

Can someone help me in setting up this correctlly.

Thanks,
Kalyan.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Which hsqldb version your jboss have? Seems a very old, since it does not support "DROP TABLE IF EXISTS'.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Sorry for the late reply. It's Hypersonic 1.7.1.

Please let me know incase you need more information.

Thanks,
Kalyan.
[originally posted on jforum.net by Anonymous]