how to better save a trans in DBCP?

I have classes which deal with tables individually. In each class, it has the following lines to get connection pooling and then commit a single table. Context envCtx = (Context) ctx.lookup(java:comp/env); DataSource ds = (DataSource) envCtx.lookup(jdbc/myERP); conn = ds.getConnection(); stmt =

RE: how to better save a trans in DBCP?

I have classes which deal with tables individually. In each class, it has the following lines to get connection pooling and then commit a single table. Context envCtx = (Context) ctx.lookup(java:comp/env); DataSource ds = (DataSource) envCtx.lookup(jdbc/myERP); conn = ds.getConnection();

how to better save a trans with DBCP?

I have classes which deal with tables individually. In each class, it has the following lines to get connection pooling and then commit a single table. Context envCtx =3D (Context) ctx.lookup(java:comp/env); DataSource ds =3D (DataSource) envCtx.lookup(jdbc/myERP); conn =3D ds.getConnection();

Re: how to better save a trans in DBCP?

thanks On 12/6/05, Varley, Roger [EMAIL PROTECTED] wrote: I have classes which deal with tables individually. In each class, it has the following lines to get connection pooling and then commit a single table. Context envCtx = (Context) ctx.lookup(java:comp/env); DataSource ds =