Community
Participate
Working Groups
The class PLSQLStoredProcedureCall contains the support for using complex PL/SQL types as arguments. However, due to how the class hierarchy is laided out, StoredFunction call does not inherit any of the support for using complex PL/SQL types as either arguments or as a return type.
Since this 'bug' is actually closer to a 'feature', change the target to 2.1 as we are past feature-complete date for 2.0.1 When work is finished in trunk, re-visit to see if time/effort/risk is justified to port over to 2.0.n
Created attachment 190667 [details] adds plsql stored function support
Created attachment 191429 [details] better refactor
Not sure what to make of the "better refactor" patch?? The code seems much more complex then the previous. If we really need for StoredFunctionCall and PLSQLFunctionCall to be castable, then an FunctionCall interface may be more useful than a PLSQLCall interface, (although I'm not sure what would be in the interface given they don't share any methods). This would allow all of the PLSQL code to be shared instead of duplicated.
Created attachment 191833 [details] stored function annotations/xml, multi cursors/result set, plsql xml
SVN trunk pending commit: bug#275156, 294772, 332221 https://bugs.eclipse.org/bugs/show_bug.cgi?id=275156 Code review: Mike Norman (pending) Changes: - New tests in CustomSQLModel for cursors, result set and unnamed cursors - Updated eclipselink-orm schema to be 2.3 and add name-stored-function-query, multiple-result-sets, call-by-index - Updated NamedStoredProcedureQuery annotation to add multipleResultSets and callByIndex - Added JPA meta-data processing for NamedStoredProcedureQuery annotations and xml. - Update DatabaseAccessor, DatabaseCall, DatabasePlatform to refactor result set process to avoid code duplication and process multiple result sets/cursors - Added legacy project.xml support for PLSQLStoredFunctionCall - Fixed issue with MySQL and procedure calls without arguments. - Fixed unnamed cursors in StoredProcedureCall - Update legacy project.xml schema to be 2.3 - Added JPA tests for stored functions to AdvancedJPA test model
checked in
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
