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

This was in a project 3 years ago. Dont give it to much importance.

Regards.
JP

pginfo wrote:

>Hi,
>
>João Paulo Caldas Ribeiro wrote:
>
>
>
>>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 do not know what is your Oracle JDBC version, we useoracle on many prjects and
>do not have any problems with more resultset per connection.
>
>I think in the spec. exist nothink about it.
>
>Regards,
>Ivan.
>
>
>
>>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(at)postgresql(dot)org)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 2: you can get off all lists at once with the unregister command
>>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>----------------------------------------------------------------------------
>>MobiComp - Mobile Computing & Wireless Solutions
>>phone: +351 253 305 250 fax: +351 253 305 251
>>web: http://www.mobicomp.com
>>----------------------------------------------------------------------------
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>>
>>
>
>
>
>
>
>
>

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