Daily Archives: June 2, 2009

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