Issue Details (XML | Word | Printable)

Key: JDBC-586
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JDBC Driver

Statement completion of statement types that are DDL should drop the prepared statement

Created: 16/Jun/19 12:45 PM   Updated: 16/Jun/19 02:10 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2.15, Jaybird 4.0.0-beta-1, Jaybird 3.0.6
Fix Version/s: None


 Description  « Hide
Currently, Jaybird always prepares statements. For DDL statements it would be better if statement completion drops the prepared statement from the handle to avoid metadata locks being retained for too long.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 16/Jun/19 02:06 PM - edited
This ticket may be the result of an incorrect assumption, so investigate / reproduce the problem before implementing this. The actual observed problem may have been one of a delete statement retaining said lock.