Re: DELETE ... RETURNING - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: DELETE ... RETURNING
Date
Msg-id 4A5BAA29.9000004@opencloud.com
Whole thread Raw
In response to Re: DELETE ... RETURNING  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: DELETE ... RETURNING  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Thomas Kellerer wrote:

> At least executeUpdate() should not throw an exception.

Wrong, see the javadoc:

>     Throws:
>         SQLException - if a database access error occurs or the SQL statement returns a ResultSet object

Your SQL statement is returning a ResultSet object, so executeUpdate
correctly throws an exception.

Use executeQuery() or execute().

-O

pgsql-jdbc by date:

Previous
From: David Rees
Date:
Subject: Re: Java long
Next
From: Thomas Kellerer
Date:
Subject: Re: DELETE ... RETURNING