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

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@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
> ----------------------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org