This appendix describes how to use the oajava sample included as part of the OpenAccess SDK installation. The instructions are for sample Java IPs for use with a third-party SQL engine that has a JDBC API. Additional samples are available at:
The oajava sample is a Java IP for integrating a third-party SQL engine that has a JDBC API. The sample is configured as the Default data source under the OpenAccessSDK810_Java_SQL service and can be used to access a JDBC-compliant data source such as SQL Server, Oracle, and so on. The source code is located in the install_dir\ip\oasqlip\oajava directory.
The fully functional IP in example1 supports SELECT, INSERT, UPDATE and DELETE statements. It implements a single table CURVALUE for a memory database called MDB. The MDB database is implemented in the mdb.c file. The IP code is contained in the mdb.java and database.java files. The IP code is contained in the damip.java file. The installation configures a data source example that is fully configured to access this sample.
Highlights of oajava are:
• Written in Java
• Fully functional interface to a JDBC-compliant SQL engine
