Developer Forum

1. Hit Counter - Limit Recorded Hits

2. Hitting RPC request number of parameters limit

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.

3. Has anyone hit a limit on the 'numbered lists', say 32767?

4. Hitting RPC request number of parameters limit

5. programmiclly adding records hits db size limit

6. Do I hit the limit of ATA_PASS_THROUGH and need to write my dr

7. How to Identify process that is causing CPU to hit a certain limit

8. C# webservice consumer app hitting MaxConnect=2 limit

9. Redesign for hitting limit argument in a UDF

10. SBS2K3/EX2K3 STD: Having hit the 16GB limit, will installing SP2 work?

11. Socket Map: hitting resources limits

12. Hitting weird limit in Tcl 8.4.19

13. hitting the 64k limit with a hierarchial big dimension - Please ad

14. Service Control Manager - hitting some resource limit

15. Do I hit the limit of ATA_PASS_THROUGH and need to write my driver