Oracle-Magpie is a class library for calling oracle pl/sql stored procedures and Oracle object type methods in easy transparent way.
Oracle-Magpie enables Java programs to define mappings of java interface methods to oracle package or object type procedures and automatically use the interface in remote method invocation style.
Arguments marshaling is performed automatically based on declarative Java to oracle type mappings. It is possible to define simple scalar type mappings and Java class to oracle object type mappings.
Collections are supported too. Also Oracle-Magpie allows to implement Java class methods as pl/sql stored procedures with object state preserving through invocations.
Here are some key features of "Oracle-Magpie":
Separation of concerns:
· All Java to oracle pl/sql interaction is declared in separate configuration xml-files (or by annotations), so user code doesn`t include any jdbc construction.
Robustness:
· Before using at runtime, all interface and type mappings are checked for the compatibility of method signatures and argument types.
Object-oriented support:
· It is possible to pass in transparent way an instance of any java class (mapped to oracle object type) as argument of oracle stored procedure. Also, methods of oracle object type mapped to java class can be invoked transparently in java code with the automatic object instance passing between java and oracle.
Flexibility:
· The library allows to map any java scalar or class type to any oracle scalar or object type. Collections are supported automatically. All declared mappings are used in stored procedure invocations.
Performance:
· When passing java object instance as oracle stored procedure argument it is possible to define any depth of the instance data graph completeness .
