HSQLDB - the user is not a privilege or an object: SQLState (42501) supplier code (-5501)

Question

I moved from hsqldb_1.8.10 in hsqldb_2.3.2 version hsqldb but suddenly stops working. I tried a lot to solve the problem, but could not find the root cause of the problem. I have googled and got a lot of links, but nothing could solve my problem.

I copied the log file and script for reference.

DriverManager Magazine

DriverManager.getConnection("jdbc:hsqldb:hsql://ip_address/database") trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver, sun.jdbc.odbc.JdbcOdbcDriver@1c695a6 ] *Driver.connect (jdbc:hsqldb:hsql://ip_address/database) trying driver[className=org.hsqldb.jdbc.JDBCDriver, org.hsqldb.jdbc.JDBCDriver@1386918 ] getConnection returning driver[className=org.hsqldb.jdbc.JDBCDriver, org.hsqldb.jdbc.JDBCDriver@1386918 ] SQLState(42501) vendor code(-5501) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: RESULTS 

Database.script File

SET DATABASE UNIQUE NAME HSQLDB44D4CB4776 SET DATABASE GC 0 SET DATABASE DEFAULT RESULT MEMORY ROWS 0 SET DATABASE EVENT LOG LEVEL 0 SET DATABASE TRANSACTION CONTROL LOCKS SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE SET DATABASE TEXT TABLE DEFAULTS '' SET DATABASE SQL NAMES FALSE SET DATABASE SQL REFERENCES FALSE SET DATABASE SQL SIZE TRUE SET DATABASE SQL TYPES FALSE SET DATABASE SQL TDC DELETE TRUE SET DATABASE SQL TDC UPDATE TRUE SET DATABASE SQL TRANSLATE TTI TYPES TRUE SET DATABASE SQL CONCAT NULLS TRUE SET DATABASE SQL UNIQUE NULLS TRUE SET DATABASE SQL CONVERT TRUNCATE TRUE SET DATABASE SQL AVG SCALE 0 SET DATABASE SQL DOUBLE NAN TRUE SET FILES WRITE DELAY 500 MILLIS SET FILES BACKUP INCREMENT TRUE SET FILES CACHE SIZE 10000 SET FILES CACHE ROWS 50000 SET FILES SCALE 32 SET FILES LOB SCALE 32 SET FILES DEFRAG 0 SET FILES NIO TRUE SET FILES NIO SIZE 256 SET FILES LOG TRUE SET FILES LOG SIZE 50 CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' ALTER USER SA SET LOCAL TRUE CREATE SCHEMA PUBLIC AUTHORIZATION DBA ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC GRANT DBA TO SA SET SCHEMA SYSTEM_LOBS INSERT INTO BLOCKS VALUES(0,2147483647,0)

Answer 1

I also got the same error. Finally, I decided it yourself. The problem is connected with the wrong URL-address of the connection.

 connection = DriverManager.getConnection ("jdbc:hsqldb:file:///D:/hsql/testdb;shutdown=true;ifexists=true", "sa", ""); 

Here testdb - name db, you are trying to connect. I used data source plug-in to connect to eclipse hsql. when setting up, I gave the database location as D: / hsql / testdb. so this caused the problem.

I was trying to remove a table from testdb, before creating a table in testdb.

Also, if you connect to the db using data source plug-in eclipse, make sure that you execute the command SHUTDOWN before running java application, otherwise it will display the following error

 Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@d9999e76 [file =D:\hsql\testdb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-09-30 15:09:55 heartbeat - read: -3700 ms 

Hope this will be helpful.