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)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(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.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com
Is this limit configurable? Is it related to the MS JDBC driver
implementation, or is it more basic than that?
Wes Clark wrote:
> We are bumping up against the paramter limit in an RPC request coming through
> the latest version of the MS JDBC driver (to 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)
Hi Wess. This is a DBMS limitation, not a driver issue, because the driver is
processing an error message sent from the DBMS. The DBMS's RPC protocol has
that (hard-wired I think) limit.
Joe Weinstein at BEA Systems
I am getting the same issue in my project.
Did you find out any solution to this issue.
Thx in advance.