> 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. >
Either create a new datasource that is session specific and returns the same connection on each request or change your individual classes so that the datasource is passed as a parameter so that it can be shared between multiple invocations. In either case, set up your transaction before calling the chain of updates and call commit afterwards. Regards Roger __________________________________________________________________________ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. __________________________________________________________________________ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]