Issue Details (XML | Word | Printable)

Key: JDBC-580
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: mitra
Votes: 0
Watchers: 0
Operations

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

Unable to call a procedure which does not return a value using JPArepositories

Created: 01/Apr/19 12:37 PM   Updated: 01/Apr/19 02:15 PM
Component/s: None
Affects Version/s: Jaybird 3.0.5
Fix Version/s: None

Environment: Software


 Description  « Hide
Unable to call a procedure which does not return a value using JPARepositorie - @procedure annotation in java

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 01/Apr/19 02:15 PM
Unfortunately, that is a limitation of spring-data-jpa @Procedure annotation. It only works for executable stored procedures with a single return value. So no return column, multiple return columns or selectable procedures will not work with it. This is something that would need to be fixed in spring-data-jpa. Alternatively, use @Query(.., nativeQuery=true) instead.