Cursor « Database « JPA Q&A

1. Database Cursor and Hibernate

2. Open DB cursors when tx rolled back

We are trying to perform an update, which fails due to a FK violation and is rolled back. All looks great from the Java side, but in the DB it leaves open a cursor. When the update is successful, there is no cursor left open. We've gone through the steps of making sure all statement caching is disabled, but cannot figure ...