by V2VzIENsYX » Sat, 03 Mar 2007 13:13:05
We are bumping up against the parameter limit in an RPC request coming through
the latest version of the MS JDBC driver (from MS SQL Server SP1). Here's the
stack trace
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data
stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too
many parameters were provided in this RPC request. The maximum is 2100.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown
Source)
a
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
a
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
a
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.executeUpdate(Unknown
Source)
a
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com
Is this limit configurable? We are not having this problem on Oracle or DB2.
