wood burning stoves
The moose likes JDBC and Relational Databases 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


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
Sheriff

Joined: Oct 14, 2005
Posts: 19719
    
  10

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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: How do we capture what the SQLCODE And/Or SQLSTATE
 
It's not a secret anymore!