My application is running on Websphere 5.0 and using Oracle 9.2.04.
Some time it gives following exception in one particular query while retrieving a particular field. But this exception is coming random(sometime after 2 days). If I run this query in SQLPlus, it runs fine.
Seeing the exception it appears this is a
JDBC driver problem.
Could someone please give the way how to fix this?
=============================
java.lang.ArrayIndexOutOfBoundsException
at oracle.sql.LnxLibThin.lnxnuc(LnxLibThin.java:5737)
at oracle.sql.NUMBER.toInt(NUMBER.java:412)
at oracle.jdbc.dbaccess.DBConversion.NumberBytesToInt(DBConversion.java:2959)
at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:4505)
java.la at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:536)
at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1528)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getInt(WSJdbcResultSet.java:1347)