com.microsoft.sqlserver.jdbc.SQLServerException: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Server Fault by Jason B
, 1 year ago
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
via vbforums.com by Unknown author, 2 years ago
Violation of PRIMARY KEY constraint 'PK__Employer__6F09E6800F975522'. Cannot insert duplicate key in object 'dbo.Employer'.
via Google Groups by John Whish, 5 months ago
Error converting data type nvarchar to decimal. I don't get this on ACF9.0.1 against the same database. Looking into this a bit further, it seems that maybe under the hood Railo is using double for "1.11", but MS SQL Server expects a BigDecimal
via grails.org by Unknown author, 2 years ago
Cannot insert the value NULL into column 'manager_id', table 'sqlexceptionbug.dbo.team'; column does not allow nulls. INSERT fails.
via Stack Overflow by Nik
, 7 months ago
Procedure or function 'myInsert' expects parameter '@myId', which was not supplied.
via Stack Overflow by Lukas Eder
, 6 months ago
Incorrect syntax near the keyword 'schema'.
com.microsoft.sqlserver.jdbc.SQLServerException: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1187)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:804)

Users with the same issue

4 times, 3 months ago
14 times, 5 months ago
Once, 10 months ago
Once, 1 year ago
2667 times, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.