Re: ConnectionPoolDataSource submittal

Ned, can get get the newest versions for inclusion in 7.3?

---------------------------------------------------------------------------

Ned Wolpert wrote:
-- Start of PGP signed section.
> Whoops.  Sorry about that.  I accidently resent my original message. (Didn't
> mean to spam the list.)
>
> I have a new update to my classes that I'll send in after 7.2 is released.
> If you want, I can send in my new changes this week instead, though.  My
> changes include
> 1) Renamding psqlProps.properties to pgDriver.properties
> 2) Wrapping each statement so that the driver can catch their errors so
> 3) Connections are removed in case of error
> 4) Alittle better pooling
> 5) Moved exception names into the errors.properties file
>
> So don't hold on to those classes I sent.  Wait for my new ones.
>
> Thanks.
>
>
> On 03-Dec-2001 Bruce Momjian wrote:
> >
> > I will save this for 7.3:
> >
> >       http://216.55.132.35/cgi-bin/pgpatches2
> >
> >
> > ---------------------------------------------------------------------------
> >
> >> Folks-
> >>
> >>   I finished an implementation of the ConnectionPoolDataSource that is
> >> functional.  I've included in this email the relavant code (tar, gziped):
> >>
> >>   org/postgresql/PostgresqlConnectionPoolDataSource.java
> >>   org/postgresql/psqlProps.properties
> >>   org/postgresql/util/DefaultProperties.java
> >>   org/postgresql/jdbc2/PostgresqlPooledConnection.java
> >>
> >> (What is the normal way to send in new files for the driver? Is attachment
> >> prefered?) They are also on my website at
> >>          http://members.home.net/wolpert5/code/
> >> as well.  The only additions left to make is
> >>
> >> 1) Cleaning thread to close unused connections
> >> 2) Wrap objects returned by the connection so errors are caught on that
> >>    level too.
> >> 3) Move all exceptions to throw PSQLException rather than SQLException.
> >>    (So they'll use the errors.properties file instead of being hard
> >>    coded.)
> >>
> >> I'll do these if people like the code I've submitted.  The code should
> >> function properly, and is fully commented in the relavent areas.  The
> >> DefaultProperties.java class I submited has also been updated; it nolonger
> >>
> >> throws exceptions due to read errors, and does not synchronize access to
> >> itself.  Please comment on my submittial, and if I'm going about my
> >> updates
> >> correctly.  (And if you have improvements for my code. :-)
> >>
> >> Thanks
> >>
> >> =====
> >> Virtually,        |                   "Must you shout too?"
> >> Ned Wolpert       |                                  -Dante
> >> wolpert@yahoo.com |
> >> _________________/              "Who watches the watchmen?"
>
>
> Virtually,
> Ned Wolpert <ned.wolpert@knowledgenet.com>
>
> D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45 -- End of PGP signed section.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026