I have a mature database where OOO4.1.1 will start with drivers from 2.3.0 up to 2.3.3 inclusive.
Changing the driver to 2.3.4
Code: Select all
C:\Users\Accounts\Desktop\Bookkeeping\UPGRADES>java -Xmx1800m -classpath driver\
hsqldb.jar org.hsqldb.server.Server
[Server@4517d9a3]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@4517d9a3]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@4517d9a3]: Startup sequence initiated from main() method
[Server@4517d9a3]: Loaded properties from [C:\Users\Accounts\Desktop\Bookkeeping
\UPGRADES\server.properties]
[Server@4517d9a3]: Initiating startup sequence...
[Server@4517d9a3]: Server socket opened successfully in 9 ms.
[Server@4517d9a3]: Database [index=0, id=0, db=file:database/ACCOUNT_BOOKS, alia
s=upgrades] opened successfully in 1704 ms.
[Server@4517d9a3]: Startup sequence completed in 1714 ms.
[Server@4517d9a3]: 2016-07-27 22:08:31.322 HSQLDB server 2.3.4 is online on port
9003
[Server@4517d9a3]: To close normally, connect and execute SHUTDOWN SQL
Code: Select all
org.hsqldb.HsqlException: Client driver version greater than '2.1.0.0' is requir
ed. HSQLDB server version is '2.3.4'
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.server.ServerConnection.init(Unknown Source)
at org.hsqldb.server.ServerConnection.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I could post this on hsqldb.org but other clients (sqltool, databasemanagerSwing, and sqlworkbench/J) connect fine. So I think it's an OOO problem.
I've tried playing with the OOO settings but don't have much of a clue as to what else might be useful here.
It's a client server setup. The server. bat and server.properties file are as follows
Code: Select all
cd C:\Users\Accounts\Desktop\Bookkeeping\TEST\
java -Xmx1800m -classpath driver\hsqldb.jar org.hsqldb.server.Server
server.database.0=file:database/ACCOUNT_BOOKS
server.dbname.0=UPGRADES
server.port 9003