Troubleshooting
Problem
An SQLException throwns with the message "Limit on number of statements exceeded."
Symptom
An SQLException throwns with the message "Limit on number of statements exceeded."
Cause
A Toolbox Connection object can manage only a finite number of open Statements at any given time. the maximum number of open Statements is exceeded
Resolving The Problem
This usually happens when a JDBC program neglects to close Statement objects that are no longer needed. The solution is to close Statement objects when they are no longer needed. This is generally a good idea anyway, since it helps to conserve resources on both the client and the IBM i system. The limit is 9999 open Statements per Connection.
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Product Synonym
IBM i;AS400
Was this topic helpful?
Document Information
Modified date:
17 March 2020
UID
ibm11118007