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 = 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]