Still needing help with DBCP - slow response time 2003-10-09 - By Jose Euclides da Silva Junior - DATAPREVRJ
Back
Hi,
i am still having problems with DBCP 1.0 - TomCat 4.18.
Some hints:
1 - I didnt setted the server.xml up.
2 - I am using the Oracle Thin Driver
3 - I ve created my own connection pooling class, called BeanPoolConn,
which returns a datasource object. See below the main statement:
DriverAdapterCPDS cpds = new DriverAdapterCPDS();
cpds.setDriver("oracle.jdbc.driver.OracleDriver");
cpds.setUrl("jdbc:oracle:thin:@(protected):1526:drj1");
cpds.setUser("PORTAL_PRATICA");
cpds.setPassword("PORTAL_PRATICA00");
Jdbc2PoolDataSource tds = new Jdbc2PoolDataSource();
tds.setConnectionPoolDataSource(cpds);
tds.setDefaultMaxActive(10);
tds.setDefaultMaxWait(50);
tds.getConnection();
ds = tds;
return ds;
4 - My main class instances this BeanPoolConn class:
if ( ds == null )
{
BeanPoolConn bp = new BeanPoolConn();
ds = bp.conexao();
}
con = ds.getConnection();
... do something...
pstmt = con.prepareStatement(query);
resultcount = pstmt.executeUpdate();
Question: Is it enough? Are there others steps to be done?
Thanks again, Euclides.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
