File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5" Watch "org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5" New topic
Author

org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
New installation of 2.1.7 on tomcat 5.5.20 on Linux
On running the install I get:
JForum 2.1.7 installation Error
Error while trying to configure the database. Please check if parameters like username, password and host are correct and try again.
org.hsqldb.jdbcDriver

Assuming that I clobbered the hsqldb database, how do I reinitialize it and start over?
On the installation form, are the db username and password the values I want the installation program to create?

On attempting to start jforum I get the exeption: net.jforum.exceptions.DatabaseException: Error while trying to start the database: java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
Do I need to do something additional to install hsqldb?
-------------------------------------
Got it working, I think.
hsqldb appears to be missing from the jrorum 2.1.7 zip file.
Downloaded current version from http://www.hsqldb.org/
cp /home/stryon/Downloads/zip/hsqldb/lib/* /home/deploy/webapps/conferences/WEB-INF/lib
Edited WEB-INF/config/database/hsqldb/hsqldb_data_dump.sql
[root@gsn2prodapp hsqldb]# diff hsqldb_data_dump.sql hsqldb_data_dump.sql.save
137,138c137,138
< INSERT INTO jforum_roles (role_id, name, group_id) VALUES (38, 'perm_html_disabled', 1); <br /> < INSERT INTO jforum_roles (role_id, name, group_id) VALUES (39, 'perm_html_disabled', 2); <br /> --- <br /> > INSERT INTO jforum_roles (role_id, name, group_id) VALUES (38, 'perm_html_disabled', 1, 0); <br /> > INSERT INTO jforum_roles (role_id, name, group_id) VALUES (39, 'perm_html_disabled', 2, 0);
------------------------------------------------

Thanks,
Steve
[originally posted on jforum.net by stryon]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
That's because they assume you are following directions to the 'T' for the upgrade. One of the instructions was to copy over the new 2.1.7 directory over your existing 2.1.6 directory (which contains the hsqldb jar file).

I hardily agree the good folks at jforum should focus on making upgrades much less painful since the ease of initial setup is a primary reason folks select JForum in the first place.

- Good luck.
[originally posted on jforum.net by dferrero]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ouch, the jar is in fact missing.

We'll update the release to this this.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
You never updated the release, the jar is still missing. I had to grab it out of the 2.1.6 zip file.
[originally posted on jforum.net by mattcoz]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5