Provided that the stored proc does not have any commits or rollbacks in it, I think you are in the clear. CMT will make the call part of the transaction. Make sure you get your connection from a transacted pool.
//Nicholas --- Russell Chan <[EMAIL PROTECTED]> wrote: > Hi, > > I've looked through the documentation, but haven't > really found an > answer to my question yet, so I'll try here. > > I have a case where some legacy functionality is > wrapped up in an > oracle stored procedure. I have a session bean > which needs to do some > lookups/updated, call this stored procedure, and do > further lookups/updates. > > The session bean is currently implemented using CMT. > Is it possible to > get the stored procedure to run in the same database > connection as the > transaction? (Otherwise, my data lookups could be > skewed because of the > stored proc). If so, how do I get the connection? > > I've managed to get a database connection inline but > it is probably not > part of the current transaction, so I'm worried > about dirty reads. > > Thanks, > Russ > > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built > ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are > available now. > Download today and enter to win an XBOX or Visual > Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ===== Nicholas Whitehead Home: (973) 377 9335 Cell: (201) 615 2716 [EMAIL PROTECTED] Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/ ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
