Category Archives: hsqldb

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

Posted on July 16, 2009 by admin

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]

Posted on June 2, 2009 by admin

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

Posted on June 2, 2009 by nitingautam

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