• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic