Re: JDBC support for CALL / PERFORM - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC support for CALL / PERFORM
Date
Msg-id Pine.BSO.4.63.0602131914140.13706@leary.csoft.net
Whole thread Raw
In response to JDBC support for CALL / PERFORM  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-jdbc

On Mon, 13 Feb 2006, Guy Rouillier wrote:

>
> Ok, thanks.  I haven't begun to look at the code yet, but the general
> approach will be
>
> (1) Execute each statement in the batch one at a time.
> (2) If a particular statement encounters this one error (result not
> allowed in batch), and if the statement is a callable statement, then
> absorb the error, discard the result set and continue.
> (3) Otherwise (not this particular error or not a callable statement),
> then allow the error to propagate as currently implemented.
>

All you should have to modify is
org.postgresql.jdbc2.AbstractJdbc2Statement.BatchResultHandler.handleResultRows
to not throw an Exception if you've got a CallableStatement.

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Guy Rouillier"
Date:
Subject: JDBC support for CALL / PERFORM
Next
From: Markus Schaber
Date:
Subject: Re: Pb with Spring & Metadat