[Proxool-developer] Some ideas about future dev

[Bertrand R. <ber...@mo...>]

Hi everybody,

Here are some new ideas about the future of Proxool:

_____________________________
1/ Externalize ConnectionTest

Currently, Proxool test the viability of a connection by executing the test
SQL statement provided by the configuration.
Would be nice if users could plug their own connection validation logic.

The connection would be validated using a ConnectionTesterIF.
The default implementation would use the SQL provided by the configuration.
User would have the ability to register their own implementation.

________________________________________________
2/ Externalize Prototyping / Connection creation

The same idea would apply to the connection creation.
Currently, the Prototyper is a class and there is no way to substitute it
with another implementation for a particular pool.

Still don't see why one would do this... But it some cases people may want
to obtain the *real* connection from their database themselves...

I remember someone's post that had problems because he needed to change the
current thread's user identity before getting a connection (or something
similar)... Anyway, with a pluggable ConnectionCreatorIF - all kind of
configuration would be possible.

_________________________________
3/ Externalize ConnectionResetter

Same idea for the ConnectionResetter - invoked to reset the connection to a
default/known state when it is returned to the pool.

Note: this one is probably less interesting...



Feel free to comment :)


-bertrand