wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQL Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Exception" Watch "SQL Exception" New topic

SQL Exception

Sanjeev Kaushik
Ranch Hand

Joined: Aug 01, 2002
Posts: 105
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)

Sanjeev Kaushik
Joe Nguyen
Ranch Hand

Joined: Apr 20, 2001
Posts: 161
Make sure you have compatible data type, especially its length. You can avoid it by using getObject() method.
I agree. Here's the link: http://aspose.com/file-tools
subject: SQL Exception