This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Verbose and Constructive SQL Exception error messages using Oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Verbose and Constructive SQL Exception error messages using Oracle? " Watch "Verbose and Constructive SQL Exception error messages using Oracle? " New topic
Author

Verbose and Constructive SQL Exception error messages using Oracle?

Byron Mabbett
Greenhorn

Joined: Sep 16, 2010
Posts: 2
Hi,
Very new to Java (2 weeks) and have most of my background in Perl and other interpreted languages.

Working with Perl and Oracle you get very verbose and particular error message when something goes wrong

For example....

This is well good when you have quite a bit of sql in your Java code.

In java from the sql exception i just get the message and the number

Is there an equivalent in Java to the verbose and constructive error messaging that you get in Perl via a special module/api called DBD::Oracle.
I had a quick search through this forum and a good look on the web but could not find anything.

Cheers and thanks for any help.
 
 
subject: Verbose and Constructive SQL Exception error messages using Oracle?
 
Similar Threads
updateRow() throws " ORA-00907: missing right parenthesis"
Why does this give invalid column name, is there an alternate syntax for NOT IN?
how to return the index by variable from pl/sql to java
DBD::mysql installation error on trustix linux
Really, really new to Java. Trying to compile small program, help!