Thursday, July 31, 2008

Oracle error List and solutions

This post includes the Oracle errors i got during my development (java code, Stored Procedure, executing SQL from TOAD/SQLPlus). I tried to give little history for each error to understand the problem I had.


Error:
ORA-01460: unimplemented or unreasonable conversion requested

History:
Environment- Red Hat LInux 4.5/JBoss 4.0.5 GA/Oracle 10g (OS/Application server/database)
I was using ojdbc14.jar for Oracle9i driver and when i try to save a file as BLOB in oracle database from my java code (using JNDI), this exception was thrown.

Solution:

Use ojdbc14.jar of version
10.2.0.4.

Error:
ORA-17009: Closed Statement : Next

History:
In DB Accessor class, first method calls second method which returns a ResultSet and the second method is actually creates DB connection, statement and executes the query. The second method closes the connection and statement in finally block. So, when first method try to traverse the ResultSet


Solution:

Use ojdbc14.jar of version
10.2.0.4.


No comments: