Thursday, May 13, 2010

No TDS_RET_STATUS was found for the stored procedure output parameters.

com.microsoft.sqlserver.jdbc.SQLServerException: No TDS_RET_STATUS was found for the stored procedure output parameters.
com.microsoft.sqlserver.jdbc.SQLServerException: No TDS_RET_STATUS was found for the stored procedure output parameters.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.seekToOutParams(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepStmtHandle(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at com.jdedwards.database.impl.physical.JDBPreparedStatement.executeMSSQLQuery(Unknown Source)
at com.jdedwards.database.impl.sql.SQLPhysicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableSelect.lowLevelAttempt(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableReadOperation.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)

Solution:

This is a bug with Microsoft's SQL Server JDBC driver - sqljdbc.jar.Applying the 1.2 version JDBC driver corrected the issue.

No comments: