No Exception thrown when there is a constraint violation, and delete fails - Mailing list pgsql-jdbc

From Nicholas Veeser
Subject No Exception thrown when there is a constraint violation, and delete fails
Date
Msg-id 66EA32F2A81C004AB67268BA33833EA00A8CF5@corpexch05.plumtree.com
Whole thread Raw
Responses Re: No Exception thrown when there is a constraint violation, and delete fails  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-jdbc
I am trying to do a delete, and there seems to be a constraint violation.
Fine, but why does it not send an exception to let me know this.
I mean, nothing happens. Not even a warning.

Is there something I need to turn on to find constraint violations as exceptions?


Code:
Connection c = DriverManager.getConnection(
c.setAutoCommit(true);

PreparedStatement pst = c.prepareStatement("delete from queue where id=?");
pst.setInt(1, 850);
pst.executeUpdate();

c.close();


Exception:
None, not a thing.


Error Log:

ERROR:  update or delete on "queue" violates foreign key constraint "fkd73c6034ba977309" on "branch_queue"
DETAIL:  Key (id)=(850) is still referenced from table "branch_queue".


pgsql-jdbc by date:

Previous
From: Bhushan Bhangale
Date:
Subject: Re: calling function
Next
From: Tim Pizey
Date:
Subject: Melati version 0.7.2