From: | "Lenard, Rohan (Rohan)" <rlenard(at)avaya(dot)com> |
---|---|
To: | "Oliver Jowett" <oliver(at)opencloud(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Multiple Statement result set problem with PreparedStatements ? |
Date: | 2005-07-14 02:34:23 |
Message-ID: | 2773CAC687FD5F4689F526998C7E4E5F1EF371@au3010avexu1.global.avaya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Okay - my bad - that works and I think I can see what I did wrong. I
have to call "both" methods to get the right results..
That's something that should be in the documentation. The JDBC javadoc
doesn't make it obvious you really need to get it right so call them
both - it says call one or the other ...
| -----Original Message-----
| From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com]
| Sent: Thursday, July 14, 2005 12:20 PM
| To: Lenard, Rohan (Rohan)
| Cc: pgsql-jdbc(at)postgresql(dot)org
| Subject: Re: [JDBC] Multiple Statement result set problem
| with PreparedStatements ?
|
| Lenard, Rohan (Rohan) wrote:
| > I have one but it relies on particular tables existing - if I get a
| > few minutes I too will simplify it to cause it ..
|
| Hm, ok, try the attached testcase. It works fine for me here against
| 8.0.1 and 7.3.8 servers:
|
| > oliver(at)extrashiny ~/pgjdbc-test $ java -classpath
| .:/home/oliver/pgjdbc/jars/postgresql.jar TestMultiInsert
| 'jdbc:postgresql://localhost:5432/test?user=oliver'
| > Result #1 has resultset? false update count 1 Result #2 has
| resultset?
| > false update count 1 Result #3 has resultset? true update count -1
| > oliver(at)extrashiny ~/pgjdbc-test $ java -classpath
| .:/home/oliver/pgjdbc/jars/postgresql.jar TestMultiInsert
| 'jdbc:postgresql://localhost:5738/test?user=oliver'
| > Result #1 has resultset? false update count 1 Result #2 has
| resultset?
| > false update count 1 Result #3 has resultset? true update count -1
|
| Those are the results I was expecting, anyway.. were you
| expecting something different?
|
| -O
|
From | Date | Subject | |
---|---|---|---|
Next Message | xavier.marquis | 2005-07-14 11:04:24 | java.sql.SQLException: Cannot instantiate a SerialArray object with null parameters, when using CachedRowSetImpl |
Previous Message | Oliver Jowett | 2005-07-14 02:19:53 | Re: Multiple Statement result set problem with PreparedStatements |