Re: PreparedStatement batch statement impossible - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: PreparedStatement batch statement impossible
Date
Msg-id AANLkTing75530SCuoegWawVmtNaFt8pt=4z90TyEj_1U@mail.gmail.com
Whole thread Raw
In response to PreparedStatement batch statement impossible  ("hans wulf" <lotu1@gmx.net>)
List pgsql-jdbc
Hans,

The API says that executeBatch is to return an array of update counts.
How would one return generated keys ?

Dave

On Wed, Mar 2, 2011 at 9:38 AM, hans wulf <lotu1@gmx.net> wrote:
> Hi,
>
> when using addBatch() and executeBatch() it is impossible to get the generated keys. addBatch() fails with an
BatchUpdateExceptionbecause it isn't expecting results. I am using postgres 9.0 and the newest 9.0_801 JDBC-Thingy. 
>
> The statement is generated with cn.prepareStatement(sqlStufff,Statement.RETURN_GENERATED_KEYS);
>
> Code works fine with Mysql, so I guess it's a driver problem.
>
> Until this bug is fixed, what is the workaround too use batchupdates on more than one table? Tables beeing linked by
generatedkeys. 
>
> Any ideas?
>
> Thanks so much.
>
>
> --
> Schon gehört? GMX hat einen genialen Phishing-Filter in die
> Toolbar eingebaut! http://www.gmx.net/de/go/toolbar
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

pgsql-jdbc by date:

Previous
From: "hans wulf"
Date:
Subject: PreparedStatement batch statement impossible
Next
From: Dave Cramer
Date:
Subject: Re: PreparedStatement batch statement impossible