@Procedure returns NULL when I use parametermode.REFCursor [DATAJPA-1719] #2014
Comments
|
pratikbhattacharya2017 commented Could anyone look into this. I have used weblogic as an application server, I have a road block for this |
|
Jens Schauder commented We will look into this, but there are many other thing we have to look into and therefore can't promise any response time. In general calling stored procedures via JPA with or without Spring Data is a painful experience while at the same time not benefiting from JPA. |
|
pratikbhattacharya2017 commented Thank you for the response. Can we expect any fix in upcoming release.
|
When registered procedure output parameters, if the method annotated with @procedure has a collection return type or an entity return type, then use ResultSet. Otherwise, handle either the array (Object[]) or the primitive types. * Throw a proper exception when using an @Procedure-annotated method and no transaction is active. * Introduce refCursor as a boolean flag to @procedure denoting when to use REF_CURSORs for OUT parameters.. * Extract a ProcedureParameter command object to ease usage of a parameter's name, type and mode. (NOTE: javax.persistence already has "StoredProcedureParameter".) NOTE: Integration testing of stored procedures is very limited by lack of HSQL's support for REF CURSORS. See ##2256 to track future work for potential testing against MySQL, Oracle, Postgres, or SQL Server. See: #1959, #409. Related: #2014.
|
#1959 was recently resolved. Feel free to test out the snapshots to see if it results your issue as well. |
gregturn
added
the
status: waiting-for-feedback
|
If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed. |
spring-projects-issues
added
the
status: feedback-reminder
|
Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue. |
spring-projects-issues
removed
status: waiting-for-feedback
pratikbhattacharya2017 opened DATAJPA-1719 and commented
You can see the example here
https://www.logicbig.com/tutorials/spring-framework/spring-data/stored-procedure-ref-cursor.html
Reference URL: https://www.logicbig.com/tutorials/spring-framework/spring-data/stored-procedure-ref-cursor.html
The text was updated successfully, but these errors were encountered: