[ https://issues.apache.org/jira/browse/DERBY-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12556978#action_12556978 ]
Dag H. Wanvik commented on DERBY-3304: -------------------------------------- Interesting. It seems to have been fixed as a side effect of 606106 which is for DERBY-3037 (my sandbox wasn't up to date). A comment there contains this piece of info which may be relevant: > In order to achieve that, I have added following code in > NoRowsResultSetImpl.close > to take care of the activation > + if (activation.isSingleExecution()) > + activation.close(); > Explicit commit inside a java procedure makes a dynamic result sets passed > out unavailable > ------------------------------------------------------------------------------------------ > > Key: DERBY-3304 > URL: https://issues.apache.org/jira/browse/DERBY-3304 > Project: Derby > Issue Type: Bug > Components: JDBC > Affects Versions: 10.4.0.0 > Reporter: Daniel John Debrunner > Attachments: Main.java > > > Repro (Main.java) that shows changed behavior after svn 602991 > (the patch committed for this issue). It seems a regression: (originally from > Dag H. Wanvik attached to DERBY-1585) > An explicit commit inside a stored procedure makes a dynamic result sets > passed out unavailable, even if the commit is executed *prior* to the result > set; as in the repro. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.