Unanswered: Problem using PooledConnection - SQL Server 2000 Driver for JDBC Service Pack 2
I want to create a pool connection for my application using this code:
private SQLServerDataSource bds = null;
private PooledConnection pc = null;
The error is:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Pooled connection reclaimation not supported.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbcx.base.BasePooledConnection.getC onnection(Unknown Source)
Is generated by the second connection. Way I can't get more that one connection!? This is my goal: to creat a pool connections. But "PooledConnection" don't work as a connection pool.