Re: Connections/Statements/ResultSets (Was: Re: Pooling - Mailing list pgsql-jdbc
From | João Paulo Caldas Ribeiro |
---|---|
Subject | Re: Connections/Statements/ResultSets (Was: Re: Pooling |
Date | |
Msg-id | 3D6F56C4.9080809@mobicomp.com Whole thread Raw |
In response to | Re: Pooling Prepared Statements (Curt Sampson <cjs@cynic.net>) |
List | pgsql-jdbc |
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@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 >> >> > > > > > > > -- ---------------------------------------------------------------------------- MobiComp - Mobile Computing & Wireless Solutions phone: +351 253 305 250 fax: +351 253 305 251 web: http://www.mobicomp.com ----------------------------------------------------------------------------
pgsql-jdbc by date: