SQL Server JDBC Driver | Railo 3.3.1

[Hendrik Kramer]

Hi,

since we updated our staging servers to Railo 3.3.1 some queries failed with the error:

The server failed to resume the transaction. Desc:ba00000001.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source):-1 
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source):-1 

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source):-1 

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source):-1 

When we switch to the jTDS drivers for MS SQL Server, the same query runs fine. It's also a rather simple query:

SELECT propertydefinitionid,propertydatatype FROM propertydefinitions WHERE propertydefinitionid IN ( ... )

The In clause contains 5 values.

The JDBC driver version is 1.2.2828.100 on MS SQL Server 2008. Switching to jTDS is not an option for us due to specific requirements. Is there a way to update the JDBC driver JAR file or should we not avoid this? Is this a known issue maybe?

Here's a summary from a pure java perspective on this error. You could also google for "SQL Server 3971"; 3971 is the internal SQL Server Error code.

http://www.bigresource.com/MS_SQL-sqljdbc-error-irhDXjSh.html

[Todd Rafferty]

Open a ticket please.

--
~Todd Rafferty
Volunteer Community Manager
Railo Server - Open Source
----

Get Railo: http://getrailo.org/
Write Documentation: http://wiki.getrailo.org/

Report Bugs: https://issues.jboss.org/browse/RAILO
Request Features: https://railo.uservoice.com/

[Harry Klein]

Hi Hendrik,

 

we switched to the MS MSSQL JDBC driver version 3.0 without problems.

 

btw.

I used this code to check the version:

 

<cfset jdbcDriver = CreateObject("java", "com.microsoft.jdbc.sqlserver.SQLServerDriver")>

<cfoutput>#jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()#</cfoutput>

 

-Harry

[Hendrik Kramer]

Hi, thanks everyone. We filed a bug (RAILO-1571) for this and also updated the MS JDBC Driver to 3.0.1301.101. Still the same error (reproduceable). No transaction involved, jTDs driver and ACF8 working fine. Really strange.