Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases.
J/Foundation Developer's GuideThe HCL® J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for HCL OneDB™.
Prepare for Java™ supportYou must install and configure software before you can write user-defined routines (UDRs) in Java™ code.
Configure Java™ support
Set configuration parameters

Set configuration parameters

The onconfig configuration file ($INFORMIXDIR/etc/$ONCONFIG) includes the following configuration parameters that affect Java™ code:

JVPPROPFILE
JVMTHREAD
JVPCLASSPATH

The following example shows sample settings:

JVPPROPFILE   $INFORMIXDIR/extend/krakatoa/jvp.properties
VPCLASS      jvp,num=1
JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar

For information about specific configuration parameter settings on your platform, see $INFORMIXDIR/etc/onconfig.std.

Note: JVPLOGFILE parameter has been replaced with logback.xml file which is saved in $INFORMIXDIR/extend/krakatoa. For more information see, Debugging and tracing