Category Archives: hsqldb

org.h2.jdbc.JdbcSQLException: The object is already closed [90007-113]

While running junit using in memory database H2 I was hitting this error. I was testing my spring DAO classes that are using JDBCTemplate. In a single Junit testing, to test various scenario  I was calling a single DAO method … Continue reading

Posted in Database, h2, hsqldb | Leave a comment

HSQLDB : java.sql.SQLException: Access is denied in statement [SELECT * FROM TBALE]

This error appears when you have not specified required privileges to user in SCRIPT file for running the statements. Use the commands as follows just after user creation grant access as DBA like below: CREATE USER SA PASSWORD "" GRANT … Continue reading

Posted in Database, hsqldb, Java, Troubleshoot | Leave a comment

HSQLDB : java.sql.SQLException: User not found: SA

While running HSQLDB in standalone mode you may face the error   java.sql.SQLException: User not found: SA This is because while creating the DB using script file you are not creating the user CREATE USER SA PASSWORD "" The above … Continue reading

Posted in Database, hsqldb, Java, Troubleshoot | Leave a comment