Skip to content
This repository has been archived by the owner on Apr 13, 2023. It is now read-only.

Possible running out of DB cursors #66

Open
k2sd opened this issue Sep 4, 2017 · 1 comment
Open

Possible running out of DB cursors #66

k2sd opened this issue Sep 4, 2017 · 1 comment

Comments

@k2sd
Copy link

k2sd commented Sep 4, 2017

statement = connection.prepareStatement(ConnectionHelper.INSERT_ORDER);

This prepares an SQL statement on each iteration, but those statements are closed at once after the loop is done. I found this sometimes causes running out of DB cursors, and I think closing SQL statement will be necessary on each iteration.

Not quite so sure, but I created a patch:
diff.txt

@scottkurz
Copy link
Member

That seems to be a good point you raised. Will hold off merging the fix until we get closer to another release, but thanks for noting this.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants