From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | albertlaszlorobert(at)gmail(dot)com |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: PSQLException: Too many update results were returned. |
Date: | 2007-08-04 00:58:55 |
Message-ID: | 46B3CF4F.4020705@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Albert László-Róbert wrote:
> yes, the statements are semicolon-separated. than you have some idea how
> to make it to work?
Try adding only one statement per addBatch() i.e. instead of
stmt.addBatch("insert a; insert b; insert c");
do:
stmt.addBatch("insert a");
stmt.addBatch("insert b");
stmt.addBatch("insert c");
> note: if i use a simple executeUpdate for multiple inserts that are
> semicolon-separated, than they work.
Yes, executeUpdate is a different code path that does understand
semicolon-separated paths.
The batch code expects exactly one command status per addBatch(). It's
not clear from the JDBC API what you're meant to do with an addBatch()
call that returns more than one thing, since executeBatch() is meant to
return one array element (representing the update status) per addBatch()
call AFAIK.
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2007-08-04 01:02:05 | Re: PSQLException: Too many update results were returned. |
Previous Message | Albert László-Róbert | 2007-08-04 00:58:24 | Re: PSQLException: Too many update results were returned. |