Re: Strange integrity problem with PreparedStatement (sorry I forgot the subject on the last post)

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Daniel Washusen
> Sent: Monday, 10 November 2003 11:57 AM
> To: Postgresql JDBC
> Subject: [JDBC]
>
>
> 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
>