Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Are SQL Error Codes JDBC or Databse Specific

843854Jan 30 2004 — edited Jan 30 2004

Hi

I would like to know when a sql exception has occured one can retrieve the the specific error code.

Q1
Is error code return specific to jdbc or is it database specific?

Q2
Where can I find a reference for these error codes. I have been searching through google but I cant find them.

Example If I insert a value into a database but the database rejects it because the value needs to be unique and an error is returned. So I want to know that a particular error code means violation of unique value.

I am using ms sql server 2000 a type 4 driver that is complaint to jdbc 2

Many thanxs
Antek

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2004

Added on Jan 30 2004

#java-database-connectivity-jdbc

2 comments

188 views