Thanks, Tom. But with DBCP, when dealing with oracle or mysql, I have userid and password passed in explicitly in the connection string. I don't know how to do the same with SQL Server.
Any suggestions? Do I have to change my wrapper code for DBCP for SQL Server? Below is the code I wrote to wrap DBCP (pooled driver) used for my projects, it works if the userid and password are in connectionURL. How can I pass the userid and password outside the connectionURL?
ObjectPool connectionPool = new GenericObjectPool(null, maxActive, GenericObjectPool.WHEN_EXHAUSTED_BLOCK, 5000);
ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectURI, null);
PoolableConnectionFactory poolableConnectionFactory = new
PoolableConnectionFactory(connectionFactory, connectionPool, null, null, false, true);
PoolingDriver driver = (PoolingDriver) DriverManager.getDriver(
[ August 29, 2005: Message edited by: eric zhao ]