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™.
Create Java™ user-defined routinesA user-defined routine (UDR) is a routine that an SQL statement or another UDR can invoke. UDRs written in Java™ code use the server-side implementation of the HCL OneDB™ JDBC Driver to communicate with the database server.
Debugging and tracingAs with a UDR written in C, a UDR written in Java™ code might generate the SQL messages for UDR and DataBlade® API errors when it executes. UDRs written in Java™ code adopt the HCL OneDB™ JDBC Driver error-reporting mechanism as well.
Debugging a Java™ user-defined routine

Debugging a Java user-defined routine

To debug J/Foundation or any Java UDR, you can enable debugging on the server by setting the following parameter in your Informix $ONCONFIG file, then restart your server.

JVPARGS -agentlib:jdwp=transport=dt_socket,server=y,address=<PORT NUMBER HERE>,suspend=y

Once the JVP comes up, you can connect using jdb or any graphical debugging tool to the port you specify in the address in the JVPARGS above. J/Foundation does not ship with debugging source code for the internal components of the system. However, you can attach source for your custom UDR's to assist with debugging your extensions.