We decided to give HSQLDB a try.
The initial setup went smoothly. But when clicking on the "Test Forum" link in the "Category Test", the following error message appeared.
An error has occurred.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
org.hsqldb.HsqlException: data exception: invalid row count in fetch first clause
Any thoughts on how to investigate further?
I did a search in templates/default for "fetch" and only found a reference to mail in admin_welcome.htm.
The button itself makes use of a FreeMarker tag "href:{$ForumLink}"
I haven't tried to track down the related Java code.
There are no errors or messages in the command shell. The last message was "Started @11583ms"
This error occurred both on the server and when I reinstalled on my laptop for a local test.
The configuration file I used for my local:
Step 2 - Verify Configuration
1) General Configuration
Default board language: en_US
Database Type: hsqldb
2) Database Configuration
Database Server Hostname: localhost
Database name: jforum
Database Username: root
Database Encoding: utf-8
Use Connection Pool: yes
3) Board Configuration
Forum Link: http://localhost:8080/jforum-2.6.1/
Website Link: http://localhost:8080
Administrator Username: Admin