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
"The Hood"
Sheriff
Joined: Sep 29, 2000
Posts: 8521
posted
0
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 ]
"JavaRanch, where the deer and the Certified play" - David O'Meara
L.John
Greenhorn
Joined: Aug 29, 2001
Posts: 24
posted
0
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