Issue Details (XML | Word | Printable)

Key: JDBC-576
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

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

Connection property to ignore stored procedure type for call-escape.

Created: 16/Feb/19 01:48 PM   Updated: 25/May/19 10:03 AM
Component/s: JDBC driver
Affects Version/s: None
Fix Version/s: Jaybird 3.0.6, Jaybird 4

 Description  « Hide
Currently (on Firebird 2.1 and higher), Jaybird will automatically decide whether to generate SQL execute procedure or select based on the procedure type. In some cases stored procedures incorrectly contain SUSPEND, or are used in a context where the handling of selectable procedures breaks (eg spring-data-jpa @Procedure is not compatible with how Jaybird handles selectable procedures). For those cases, the automatic inference can be a hindrance.

As a workaround for those cases, add a property (name TBD) which disables automatic inference of selectability and always uses EXECUTE PROCEDURE (essentially, the behavior on Firebird 2.0 and earlier). Simplest way would be to make StoredProcedureMetaDataFactory return DummyCallableStatementMetaData if the property is set.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel made changes - 16/Feb/19 01:49 PM
Field Original Value New Value
Fix Version/s Jaybird 3.0.6 [ 10883 ]
Fix Version/s Jaybird 4 [ 10441 ]
Mark Rotteveel added a comment - 06/Apr/19 03:39 PM

Mark Rotteveel made changes - 06/Apr/19 03:39 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Mark Rotteveel made changes - 25/May/19 10:03 AM
Status Resolved [ 5 ] Closed [ 6 ]