catch SQLException, error code for Foeign key violation,

["surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx>]

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