Hi All,
I would like to re-open this thread because I'm facing an extremely valid reason to use ConnectionPool directly specially for IBM DB2 Version10.1 on.
The database from Version 10.1 is able to filter either records or columns based on Connection User (actually Trusted Connections)
This feature is based on User Id of the connection which, being able o use the native Pool, allows to change the user of the connection and actually to pool it without reconnecting on any requests.
Everytime I ask for connection pool via JNDI I should receive not the WrappedDataSource but the ConnectionPool to be able to ask for "TrustedConnections"
This is my problem.
Any type of possible solution will be extremely well accepted because we are facing this problem with a very key customer.
Thanks since now to anyone the would help
Franco