Re: Connections/Statements/ResultSets (Was: Re: Pooling

I dont know about the JDBC specs but i remember that i used a Oracle
JDBC driver that only supported one 1 connection --> 1 resultset at time.
I will try to find something about the specs.

Regards.
JP

Dave Cramer wrote:

>The spec probably doesn't say anything but; with the way pg's driver is
>currently written you can have as many resultsets/statements open as you
>want. This is because the driver will read them all in when you do an
>executeXXX. There is a plan however to move to a cursor backed result
>set which will change the above statement. This is because a cursor must
>be executed within a transaction, and you can only have one transaction
>open per resultset. I suppose it's possible to still open a non-cursor
>based resultset while the transaction is open?
>
>Dave
>
>On Fri, 2002-08-30 at 04:34, Michael Paesold wrote:
>
>
>>Curt Sampson wrote:
>>
>>
>>
>>>On Thu, 29 Aug 2002, Michael Paesold wrote:
>>>
>>>
>>>
>>>>So it's not 1 connection -> 1 resultset at a time, but 1 statement -> 1
>>>>resultset at a time.
>>>>
>>>>
>>>Sorry, but there are many JDBC drivers out there that allow only
>>>one resultset on a connection at a time. You may get more than one
>>>per connection with some drivers, but that's not portable.
>>>
>>>cjs
>>>
>>>
>>Does anyone of you know exactly, what the JDBC specification says about
>>more than one result set per connection at a time?
>>
>>If not, can you give me a URL where I can have a look at the specs myself?
>>
>>Michael
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>
>>
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
>


--
----------------------------------------------------------------------------
MobiComp - Mobile Computing & Wireless Solutions
phone: +351 253 305 250     fax: +351 253 305 251
web: http://www.mobicomp.com
----------------------------------------------------------------------------