This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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!