| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Barry Lind <blind(at)xythos(dot)com> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [JDBC] Strange server error with current 8.0beta driver |
| Date: | 2004-11-20 11:11:57 |
| Message-ID: | 419F267D.8040500@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-jdbc |
Barry Lind wrote:
> Environment #1: WinXP 8.0beta4 server, 8.0jdbc client
> 2004-11-19 12:19:06 ERROR: unrecognized node type: 25344832
> Environment #2: Sun Solaris 7.4.3 server, 8.0jdbc client
> ERROR: no value found for parameter 1
From memory the 7.4.3 behaviour you see can happen if you DECLARE
CURSOR with a parameterized query (executes OK) then try to FETCH from
it (fails with the above error, as the original parameter values from
DECLARE execution are not stored with the portal). The parameterization
can happen either via V3 protocol Parse/Bind or via function execution,
IIRC.
I put together a patch to fix this that made it into 8.0 (with some
changes IIRC), perhaps the bug lies in there somewhere.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Carvalhaes | 2004-11-20 14:04:02 | Fwd: SELECT MAX with char => BUG? |
| Previous Message | Reini Urban | 2004-11-20 09:00:22 | Re: [HACKERS] Beta5 Scheduale |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Smith | 2004-11-21 17:30:00 | remote connection with JDBC |
| Previous Message | Kris Jurka | 2004-11-20 04:47:41 | Re: Patch for jdbc escaped functions |