Hitting RPC request number of parameters limit

Hitting RPC request number of parameters limit

Post by V2VzIENsYX » Sat, 03 Mar 2007 10:00:05


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)
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?
 
 
 

Hitting RPC request number of parameters limit

Post by Joe Weinst » Sat, 03 Mar 2007 12:14:55


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

 
 
 

Hitting RPC request number of parameters limit

Post by V2VzIENsYX » Sat, 03 Mar 2007 13:10:08

I guess I'll post the question to the main SQL Server forum, then.
 
 
 

Hitting RPC request number of parameters limit

Post by Mayank Mod » Fri, 14 May 2010 16:09:40

Hi,

I am getting the same issue in my project.

Did you find out any solution to this issue.

Thx in advance.

url: http://www.yqcomputer.com/