You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2003/08/12 01:37:49 UTC
DO NOT REPLY [Bug 18921] -
Per User methods not working in Jdbc2PoolDataSource
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18921>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18921
Per User methods not working in Jdbc2PoolDataSource
dirk.verbeeck@pandora.be changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
------- Additional Comments From dirk.verbeeck@pandora.be 2003-08-11 23:37 -------
Don't have any problems, added junit test to TestJdbc2PoolDataSource.
public void testPerUserMethods() throws Exception {
Jdbc2PoolDataSource tds = (Jdbc2PoolDataSource) ds;
// you need to set maxActive otherwise there is no accounting
tds.setPerUserMaxActive("u1", new Integer(5));
tds.setPerUserMaxActive("u2", new Integer(5));
assertEquals(0, tds.getNumActive());
assertEquals(0, tds.getNumActive("u1", "p1"));
assertEquals(0, tds.getNumActive("u2", "p2"));
assertEquals(0, tds.getNumIdle());
assertEquals(0, tds.getNumIdle("u1", "p1"));
assertEquals(0, tds.getNumIdle("u2", "p2"));
Connection conn = tds.getConnection();
assertNotNull(conn);
assertEquals(1, tds.getNumActive());
assertEquals(0, tds.getNumActive("u1", "p1"));
assertEquals(0, tds.getNumActive("u2", "p2"));
assertEquals(0, tds.getNumIdle());
assertEquals(0, tds.getNumIdle("u1", "p1"));
assertEquals(0, tds.getNumIdle("u2", "p2"));
conn.close();
assertEquals(0, tds.getNumActive());
assertEquals(0, tds.getNumActive("u1", "p1"));
assertEquals(0, tds.getNumActive("u2", "p2"));
assertEquals(1, tds.getNumIdle());
assertEquals(0, tds.getNumIdle("u1", "p1"));
assertEquals(0, tds.getNumIdle("u2", "p2"));
conn = tds.getConnection("u1", "p1");
assertNotNull(conn);
assertEquals(0, tds.getNumActive());
assertEquals(1, tds.getNumActive("u1", "p1"));
assertEquals(0, tds.getNumActive("u2", "p2"));
assertEquals(1, tds.getNumIdle());
assertEquals(0, tds.getNumIdle("u1", "p1"));
assertEquals(0, tds.getNumIdle("u2", "p2"));
conn.close();
assertEquals(0, tds.getNumActive());
assertEquals(0, tds.getNumActive("u1", "p1"));
assertEquals(0, tds.getNumActive("u2", "p2"));
assertEquals(1, tds.getNumIdle());
assertEquals(1, tds.getNumIdle("u1", "p1"));
assertEquals(0, tds.getNumIdle("u2", "p2"));
}