Oracle Java Functions
Version 0.0.0 (build 11/Nov/2005 at 20:34:39 CET)
OraFun allows loading Java functions into Oracle database.
Documentations:
Ant Build files build.xml manages
building, deploying and testing OraFun.
The package distribution is available here.
Java 1.5+ and
Ant 1.5+ are required.
Two entities should be developed to load a Java function to an Oracle database:
- Java class which implements the function logic.
It should contain public static function(s) which
will be coupled to the SQL function. One class can contain
several functions.
- SQL script which couples Java class function to SQL function.
Some examples of such Java classes and SQL scripts
are available in src/net/hep/atlas/Database/Collections/OracleFunctions
directory.
Java 1.5+ and Ant 1.5+ should be used.
On CERN AFS, they can be set by the
following command: . /afs/cern.ch/user/h/hrivnac/public/Ant/setup-CERN.sh.
Following steps should be performed to load a Java function into an Oracle
database (commands are performed in ant directory, sources are
in src directory:
- Implement Java class with a function to be mapped.
- Implement a mapping SQL script.
- Edit custom.properties file: fill information about
database connection and classes and scripts to be loaded.
- Load Colt
library (which contains usefull mathematical
functions): ant colt (this step takes some time, but should
be performed only once).
-
- Load class and script: ant load.
- Unload class and script (if needed): ant clean.
- Perform test of default functions: ant check.
- Get information about available Ant targets: ant -projecthelp.
Bugs:
ToDos:
Related Documantation:
Presentations:
J.Hrivnac, 11/Nov/2005 at 20:34:39 CET
