Re:

Daniel,

Can  you provide us with a test case?

Dave
On Sun, 2003-11-09 at 19:57, Daniel Washusen wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
>