| 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: | Raw Message | Whole Thread | 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
| 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 |