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:@uxrjo038: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.
Hi Euclides,
if you are making a custom connection pool with DBCP, you would get a better response by mailing their users & developers on the commons mailing list.
Sounds interesting, but I can't help, sorry. What drives you to write a custom connection pool anyway? Have you got problems with the commons implementation?
Adam
-- struts 1.1 + tomcat 5.0.12 + java 1.4.2 Linux 2.4.20 RH9
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
