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(); stmt =3D conn.prepareStatement("UPDATE ???"); If a transaction consists of several tables, how can I group them so that I can get a single connection from the pool, and then commit it. thanks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]