Fail to convert to internal representation

[L.John]

Hi To All,
While working on couple of stack trace I came across the follwing Message :
weblogic.rmi.RemoteException: DB failed - with nested exception:
[java.sql.SQLException: Fail to convert to internal representation] at
netnames.server.CommonRegistrationsContextImpl.getEmailForwardingItem(Common
RegistrationsContextImpl.java:1926)
Fail to convert to internal representation
It would be kind to let me know , under what circumstances these exceptions can occur , what does this mean ? and what can be done to resolve this .
Thanks,
John

[Cindy Glass]

According to Oracle this is one of the error messages that the Oracle Oracle8i SQLJ JDBC drivers can return. This is error ORA-17059.
Unfortunately

"Cause" and "Action" information for each message will be provided in a later release.

Sigh. Look for incompatable types, like doing a getInt() on a String field.
[ November 26, 2002: Message edited by: Cindy Glass ]

[L.John]

Hi Cindy,
Thanks for replying back to my query. You are absolutely right.
The message
"[java.sql.SQLException: Fail to convert to internal representation]" was caused due to incompatibility issue.
i.e I was trying to retrieve a CHAR(1) type from Oracle by using rs.getInt(1);
To resolve this I used rs.getString(1) and then converted it into 'int' using Integer class.
Thanks Once again Cindy.
Wishing you a Merry Christmas and Happy New Year.
Regards,
L.John

[Faisal Fuad]

Thanks! This post saved my time