rus eng

Oracle-magpie makes using oracle stored procedures in java simple. It is a class library for calling oracle pl/sql stored procedures and oracle object type methods in easy transparent way. It 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 the library allows to implement java class methods as pl/sql stored procedures with object state preserving through invocations. For more details, see documentation and tutorial samples.

The library is freeware and distributed under the LGPL license. The license allows any use (including commercial) as linked .jar library. Copyleft restrictions constraint only derived products.


Release 0.1.1 is available for download..

Features... The library allows to improve a quality of java code and design decisions, which logic use oracle stored procedures, by:
  • 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 .
Availability... Oracle-magpie release 0.1.1 is available (May 3, 2010).

All your questions, comments, bug reports, feature requests etc you can post at the user forum or via e-mail

[Last Updated: May 3, 2010]

Copyright (C) 2009-2010 by Sergey Panasenko.
Oracle(TM) is a trademark of Oracle, Inc.
Java(TM) is a trademark of Sun Microsystems, Inc.