• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL Exception  RSS feed

 
Sanjeev Kaushik
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My application is running in Websphere 5.0 and using Oracle 9.2.04. I have executed a query, while retriving the 18th column value, it has failed and thrown the following exception.
I have checked it is not a Data issue. Could it be related to Driver problem, because sometime I am getting failed to convert UTF8 to UCS2.
And this exception sometime it comes and sometime not.
==================================================================
[4/9/04 13:14:57:687 CDT] 155e155e StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 17,002 and SQLState <null>, to a StaleConnectionException: java.sql.SQLException: Io exception: Bigger type length than Maximum
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at java.sql.SQLException.<init>(SQLException.java:51)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java)
at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getInt(WSJdbcResultSet.java)
 
Joe Nguyen
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Make sure you have compatible data type, especially its length. You can avoid it by using getObject() method.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!