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™.
Configuration parametersThis section documents the configuration parameters that you need to set to use UDRs written in Java™ code. Set these parameters in the database server configuration file (the onconfig file).
JVPARGS configuration parameter

JVPARGS configuration parameter

onconfig.std value: None
takes effect: When shared memory is initialized

The JVPARGS configuration parameter provides an easy way for you to set Java™ VM options.Use a semicolon to separate options. For example, if you want to change Xms and Xmx to 32m, you can set those options with the JVPARGS parameter, as the following example shows:

JVPARGS -Xms32m;-Xmx32m

If you want to see gc information to determine whether you need to increase ms or mx, you can set JVPARGS, as the following example shows:

JVPARGS -verbose:gc

For more information about Java VM options, see your Java documentation.