PreparedStatement batch statement impossible

From: "hans wulf" <lotu1(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PreparedStatement batch statement impossible
Date: 2011-03-02 14:38:01
Message-ID: 20110302143801.135430@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

when using addBatch() and executeBatch() it is impossible to get the generated keys. addBatch() fails with an BatchUpdateException because 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 generated keys.

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2011-03-07 15:47:43 Re: PreparedStatement batch statement impossible
Previous Message Valentine Gogichashvili 2011-03-01 11:23:45 Type OID search does not support search_path and multiple schemas