[DERBY-6068] Increase the arbitrary 32K limit imposed by DRDA on number of Sections used for open statements

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 10.10.1.1
• Component/s: Network Server
• Assignee: Mamta A. Satoor
• Reporter: Mamta A. Satoor
• Created: 11/Feb/13 18:30
• Updated: 09/Sep/16 09:53
• Resolved: 29/Oct/14 14:11

Description

We recommend users to close the statements ResultSet.getStatement().close() to make sure the statements get closed. But it would help us to increase the limit of 32K on open statements in case a machine is slow and gargbage collection is not happening fast enough. One instance where we ran into this 32K limit violation is DERBY-6054.

Issue Links

• relates to: DERBY-6054 java.sql.SQLException: Exceeded maximum number of sections 32k in application with many setTransactionIsolation statements