Use the CREATE FUNCTION and CREATE PROCEDURE statements to register UDRs.
Compiling java into jar driver#
The SQL-to-Java data type mapping is performed according to the HCL OneDB™ JDBC Driver specification. Creating UDT-to-Java mappings The routine manager needs a mapping between SQL data values and Java™ objects to be able to pass parameters to and retrieve return results from a UDR.Packages for Java™ user-defined routines Various packages can be used to create Java™ user-defined routines (UDRs).
Compiling java into jar install#
Creating a Java™ user-defined routine in the server When you create Java™ user-defined routines (UDRs) in the server, you need to write and compile the source code and then install the finished code in the database server.Set these parameters in the database server configuration file (the onconfig file). Configuration parameters This section documents the configuration parameters that you need to set to use UDRs written in Java™ code.Prepare for Java™ support You must install and configure software before you can write user-defined routines (UDRs) in Java™ code.Concepts This section introduces the infrastructure for creating and executing user-defined routines (UDRs) and applications that you write in Java™ to run in the HCL OneDB™ database server.DataBlade® Developers Kit The DataBlade® Developers Kit (DBDK) guides contain information about the tools you can use to develop and package DataBlade® modules, which extend the functionality of HCL OneDB™ databases.DataBlade® API Function Reference The HCL OneDB™ DataBlade® API Function Reference describes the DataBlade® API functions and the subset of functions that the DataBlade® API supports.
Compiling java into jar how to#
HCL OneDB™ extensions and DataBlade® modules These topics describe how to use built-in database extensions and separately installed DataBlade® modules.Compiling the Java™ code A UDR written in Java™ code is implemented by a static method in a Java™ class.UDRs written in Java™ code use the server-side implementation of the HCL OneDB™ JDBC Driver to communicate with the database server.
J/Foundation Developer's Guide The HCL® J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for HCL OneDB™.You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases. Creating extensions You can create user-defined data types, routines, access methods, and other database objects to suit your needs.Alternatively, you can create your own user-defined objects for HCL OneDB™. 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. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. Extending HCL OneDB™ Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects.