Hi,
Could anyone please paste a code snippet how you used ConnectionPoolDatasource ?
As i'm facing an issue accessing cpds type it does not seem to get logical connections from the DB pool but makes physical DB connections that runs out of max connections .
I have the datasource classname and resource type set to Oracle connectionPoolDatasource and Javax.sql.ConnectionPoolDataSource
but then it always returns DataSource type when I lookup the connectionpool it does not return ConnectionPoolDataSource so that i can getPooledConnection instead of DataSources getConnection ().I've set the connection pool from admin console and web.xml has javax.sql.ConnectionPoolDataSource even then I get type cast exception at line2 as it returns DataSource type only.
1.Context ctx = new InitialContext();
2.ConnectionPoolDataSource cpds = (ConnectionPoolDataSource)ctx.lookup("java:comp/env/jdbc/AIP_TEST");
3.PoolConnection pc = cpds.getPooledConnection();
4.Connection conn = pc.getConnection();
thanks,
MeenaDarly
[Message sent by forum member 'md7777' (md7777)]
http://forums.java.net/jive/thread.jspa?messageID=262446