my dog learned polymorphism*
The moose likes JDBC and the fly likes More detail from SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "More detail from SQLException" Watch "More detail from SQLException" New topic
Author

More detail from SQLException

Leslie Chaim
Ranch Hand

Joined: May 22, 2002
Posts: 336
Hi,
I have this application and using dynamic SQL I often run in to the ORA-00904: invalid column name error.
From my program how can I report more details such as the table and column name, or better yet is there any way I can get the message from the Oracle engine?
Thanks for your help.


Normal is in the eye of the beholder
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Leslie
Have you tried the getErrorCode and the getSQLState methods in the SQLException class? Also, make you are using getMessage too.


Dave
Leslie Chaim
Ranch Hand

Joined: May 22, 2002
Posts: 336
Dave,
I tried it all and it does not give me what I am looking for.
After I catch the SQLException I would like to somehow get the complete Oracle message the same as would be returned when using the OCI oerhms() function call.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: More detail from SQLException