Re: ConnectionPoolDataSource submittal - Mailing list pgsql-jdbc

From Ned Wolpert
Subject Re: ConnectionPoolDataSource submittal
Date
Msg-id XFMail.20011203100529.ned.wolpert@knowledgenet.com
Whole thread Raw
In response to Re: ConnectionPoolDataSource submittal  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ConnectionPoolDataSource submittal  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8C7DYiysnOdCML0URAr2YAJ4+AwFVRIkTeO6u7OuSWwm1iF+BgQCdFV/H
chuZ31eZaSuqqyYiXRY0FgY=
=fvXX
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ConnectionPoolDataSource submittal
Next
From: "Tom Innes"
Date:
Subject: Error Codes and JDBC Driver for Postgres