[
https://issues.apache.org/jira/browse/DERBY-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12546724
]
Knut Anders Hatlen commented on DERBY-3198:
-------------------------------------------
Reusing it instead of creating a new one on each execution sounds reasonable to
me. But don't we still need some clean-up code when we close the statement?
Otherwise, this code will leak sections, won't it?
Connection c = DriverManager.getConnection("jdbc:derby://localhost/db");
while (true) {
Statement s = c.createStatement();
s.setQueryTimeout(100);
s.executeQuery("values 1").close();
s.close();
}
> Using setQueryTimeout will leak sections
> -----------------------------------------
>
> Key: DERBY-3198
> URL: https://issues.apache.org/jira/browse/DERBY-3198
> Project: Derby
> Issue Type: Bug
> Components: JDBC, Network Client
> Affects Versions: 10.3.1.4
> Reporter: Dyre Tjeldvoll
> Assignee: Dyre Tjeldvoll
> Attachments: derby-3198.v1.diff, derby-3198.v2.diff, repro.diff
>
>
> The implementation of setQueryTimeout relies on
> NetStatementReply.writeSetSpecialRegister() which will allocate a dynamic
> section when called. No reference to this Section object is kept, and so
> Section.free() never gets called on it. Executing the same statment
> repeatedly with a query timeout set results in the client driver throwing an
> exception because the number of Sections exceeding 32000.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
