Category Archives: Database

Oracle Constraint Exceptions

ADD/ENABLE constraint exception like ORA-02437, ORA-02299 etc Today while working on one assignment I came across situation where I have to enable a unique key constraint on the table which some one disabled and forget due to which many duplicate … Continue reading

Posted in debug, Oracle | Tagged , , | Leave a comment

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

Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have installed MySql 5.1 version on my lappy and when I try to connect with the DB it was giving me following error: “Client does not support authentication protocol requested by server; consider upgrading MySQL client” MySQL 5.1 uses … Continue reading

Posted in Database, Troubleshoot | Leave a comment

DB2 SQL0407N : Assignment of a NULL value to a NOT NULL column “TBSPACEID=2, TABLEID=26, COLNO=0” is not allowed.

SQL0407N Assignment of a NULL value to a NOT NULL column name is not allowed. If you encounter this error and If the value for name is of the form “TBSPACEID=n1, TABLEID=n2, COLNO=n3”, you can determine the table name and … Continue reading

Posted in Database, DB2 | 1 Comment