Thanks for your reply : ).
Jeanne Boyarsky wrote: The solution would be to not use "set chained" since XA is taking care of transactions for you.
Before calling the actual database call, I have explicitly called the query:
but now the code is breaking at this line with the same exception. Sorry I didn't get you on that line.
Are you trying to say I should explicitly call setAutoCommit(true) on connection. If yes, where exactly should I call. Should I extend TransactionProxyFactoryBean or JtaTransactionManager class and override doBegin() method and there change the auto commit behaviour.
I'm posting my Spring bean configuration and datasource bean.
Is there any class which is creating problem with Sybase may be Driver class (com.sybase.jdbc2.jdbc.SybDriver) jconn2.jar or jotm or enhydra XADataSource. I'm only getting this error on Sybase and not on Oracle database.
Spring Service Bean Configuration:
Data Source Configuration: