I was able to migrate an existing LO Base embedded database to a standalone HSQLDB instance with server (per http://hsqldb.org/doc/2.0/guide/guide.pdf, Appendix C) on Windows 10. I can access the standalone database using JDBC just fine, and query all the tables/views using username “SA”. Note server tracing is enabled, so console reports all submitted commands to confirm remote client transactions. However, the returned data seems to be read-only as LO will not permit any updates. I have verified the database properties have readonly=false. I suspect the issue may be that JDBC connections are read-only by default. Anyone know if this is true, and how to change it such that JDBC connections are updateable?
Note before migration, the same database when embedded permitted updates just fine.
Relevant property file content below.
LO version: 5.3.5.2
JRE version: 1.8.0_152
=== server.properties ===
server.database.0=file:c:/temp/BOARS/database
server.dbname.0=database
server.root=c:/temp/BOARS/server
server.silent=false
server.trace=false
server.address=192.168.1.2
server.port=9001
server.daemon=false
server.no_system_exit=true
=== database.properties ===
#HSQL Database Engine 1.8.0.10
#Thu Jan 11 19:18:38 CST 2018
hsqldb.cache_file_scale=1
hsqldb.cache_scale=13
hsqldb.cache_size_scale=8
hsqldb.cache_version=1.7.0
hsqldb.compatible_version=1.8.0
hsqldb.default_table_type=cached
hsqldb.lock_file=true
hsqldb.log_size=10
hsqldb.nio_data_file=false
hsqldb.original_version=1.8.0
hsqldb.script_format=0
modified=yes
readonly=false
runtime.gc_interval=0
sql.enforce_strict_size=true
version=1.8.0