I'm using a message driven bean with container manager transactions and Sybase 11. So far as I can see LocalManagedConnection will switch of auto commit on the Connection which mains chained mode is required for all Sybase stored procedures.
The default for Sybase is unchained and I'm not clear if it is a requirement of container managed that we turn off auto commit or if it is just the way that JBoss is currently coded and not really necessary. I'd rather use unchained mode in Sybase as there are certain issues with chained mode.
So in summary, do we have to use chained for Sybase stored procedures when using container managed transactions.