File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How do we capture what the SQLCODE And/Or SQLSTATE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How do we capture what the SQLCODE And/Or SQLSTATE" Watch "How do we capture what the SQLCODE And/Or SQLSTATE" New topic
Author

How do we capture what the SQLCODE And/Or SQLSTATE

David Coulthard
Greenhorn

Joined: Apr 16, 2008
Posts: 16
The application I'm working on throws the following exception:



This error occurs when a duplicate key exception is encountered.

My aim is to inspect the error message and act accordingly. i.e.



How do I get access to the SQLCODE and SQLSTATE so that I can acheive this?

Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

David Coulthard wrote:My aim is to inspect the error message and act accordingly.


Then you're going about it the wrong way. The SQLException class has methods which specifically address your requirements. Just use them.
David Coulthard
Greenhorn

Joined: Apr 16, 2008
Posts: 16
Thanks. getSQLState is what I was looking for.
 
wood burning stoves
 
subject: How do we capture what the SQLCODE And/Or SQLSTATE