SEO

#1 (**permalink**) 04-09-2008, 09:19 AM

i am working with PostgreSQL 8.0.0

and the programming lang used is java

i have a stored procedure which inserts a row in a table

to this stored procedure i pass the values which have to be inserted in that row.

now, i execute this query(which is a call to stored procedure)

this execute query is in a try block

and i catch SQL exception for it.

The question is that is from this SQLException can i detect if it is a foreign key violation,

i saw there is a method on SQLException,
e.getErrorCode, is ther specific error code for Foreign Key violation,

thanks,
regards
Surabhi

#2 (**permalink**) 04-09-2008, 09:20 AM

On Mon, 17 Apr 2006, surabhi.ahuja wrote:

> The question is that is from this SQLException can i detect if it is a
> foreign key violation,
>

You should check the value of SQLException.getSQLState() against this
table:
http://www.postgresql.org/docs/8.1/s...-appendix.html

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

catch SQLException, error code for Foeign key violation,