Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-25 Thread Oliver Jowett
Tom Lane wrote: BTW, rather than hacking the parameter list of ProcessUtility, I'd be inclined to just look at ActivePortal-portalParams in PerformCursorOpen. (Come to think of it, we could also copy ActivePortal's sourceText at the PortalDefineQuery step.) I've done this and it seems to work

Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-22 Thread Tom Lane
Oliver Jowett [EMAIL PROTECTED] writes: It seems like we should pass the original parameters from execution of the DECLARE utility portal down through PortalRunUtility - ProcessUtility - PerformCursorOpen, copy them into the newly created portal's memory context, and pass the copies to

Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-22 Thread Oliver Jowett
Oliver Jowett wrote: It seems like we should pass the original parameters from execution of the DECLARE utility portal down through PortalRunUtility - ProcessUtility - PerformCursorOpen, copy them into the newly created portal's memory context, and pass the copies to PortalStart on the new

Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-21 Thread Tom Lane
Oliver Jowett [EMAIL PROTECTED] writes: Logs follow; basically this is issuing a Parse/Bind/Execute for a parameterized DECLARE, which blows up with no value found for parameter 1 despite there definitely being one there. (also, that error appears on Execute, not Parse/Bind). This may be

Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-21 Thread Oliver Jowett
Tom Lane wrote: Any chance of getting this fixed for 7.5? I'm up to my keister in PITR and nested-xact issues and won't have time to look at it soon. Do you want to take a look and see if you can find where the ball is getting dropped? Ok, I'll do that. -O ---(end of

Re: [HACKERS] [JDBC] V3 protocol + DECLARE problems

2004-07-21 Thread Kris Jurka
On Wed, 21 Jul 2004, Oliver Jowett wrote: It's going to be fun using anything more than very basic cursors via the V3 protocol in the JDBC driver. DECLARE does not work with parameters passed via a Parse/Bind combination -- which is how we currently always pass parameters when talking