Morning all,
I'm having a strange problem that I'm hoping someone will be able to help me
with.
When preforming an insert with a failed integrity constraint the
PreparedStatement.executeUpdate() method seems to hang, but works fine when
the integrity is good. I would expect the method to throw an SQLException
complaning about the failed contraint. The same SQL statement fails as
expected with a an error message when run within psql, so I presume it's
something specific to either my code, or the JDBC driver.
Here is the contraint on the table in question:
CONSTRAINT "$2" FOREIGN KEY (security_code) REFERENCES security
(security_code) ON UPDATE RESTRICT ON DELETE RESTRICT
Has anyone else noticed this occuring and/or can anyone offer any hints on
where I should be looking?
Cheers,
Dan