File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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>(
at java.lang.Throwable.<init>(
at java.sql.SQLException.<init>(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(
at oracle.jdbc.driver.OracleStatement.getIntValue(
at oracle.jdbc.driver.OracleResultSetImpl.getInt(
at oracle.jdbc.driver.OracleResultSet.getInt(

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:
subject: SQL Exception
It's not a secret anymore!