We have an application running correctly with 3.2.1.ga, spring 2.5.6 in weblogic 9.2 and ms sqlserver 2005. But when running it in weblogic 10.3, we got the following error constantly. However, database access before the transaction starts retrieves data correctly.

Any ideas what is missing?

Thanks in advance for any hint or help.

=======================================================================================

[org.hibernate.transaction.JDBCTransaction:org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:67)] - {JDBC begin failed}
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:400000000b.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source)
at weblogic.jdbc.wrapper.PoolConnection.setAutoCommit(PoolConnection.java:137)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)

Hi,

the error message tells, the database, you choose, does not support transactions.

The database handles transactions correctly when running in other applications. We can run the following in aqua data studio to confirm it:

begin tran
update tbl set addDate=getDate()
commit

I think it's something else that causes the error.

Anyway, thanks.

Of course this database handles transactions.

Problem is that you're using the JDBC transaction manager, WebLogic won't let you control the transactions from a datasource it is managing: you should setup the appropriate TransactionManager to coordinate with WebLogic: http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#configuration-optional-transactionstrategy

It shouldn't have worked on previous WebLogic either, apparently they fixed this in 10.3