Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Fail to convert to internal representation

 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
"The Hood"
Posts: 8521
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 88
IBM DB2 Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks! This post saved my time
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic