Setting up an OpenAccess SDK Service and data source
A client connects to your data source by connecting to an OpenAccess SDK Service that has been configured to access your data source through the IP code you are developing. The OpenAccess SDK installation sets up a service OpenAccessSDK810_Java and installs a template OpenAccess SDK 8.1 Service for Java. It is recommended that you use the existing service OpenAccessSDK810_Java and create a data source entry under it instead of trying to create a new service.
You must configure the following Service and Data Source settings to load your IP code and to make it available when a connection is received by the OpenAccess SDK Server or the OpenAccess Local Server. Refer to the OpenAccess SDK Administrator's Guide for a detailed explanation of all the service and data source attributes that are used to configure an IP for the OpenAccess SDK SQL engine.
DataSourceIPType - DAMIP.
DataSourceIPClass - name of the IP class that is implementing the oajava.sql.ip interface (for example, install_dr\ip\oajava\example1\damip). The IP class must reside in the install_dr\ip\oajava\<sampleIP> folder.
DataSourceIPSchemaPath - full path of the directory containing the schema for your IP (for example C:\Program Files\DataDirect\oaodbclocal81\ip\schema\yourip). The OpenAccess SDK SQL engine stores the schema for the IP in the files contained in this directory.
DataSourceLogonMethod - if you want your IP to authenticate based on user name and password passed in from the client, then you set this data source attribute to DBMSLogon(UID,PWD); otherwise, leave it set to Anonymous.
ServiceJVMOptions - include options that need to be passed to the JVM. For Local configuration, you must include -Xms4M -Xmx8M.
The OpenAccess SDK launches a Java Virtual Machine when it is started by loading the JVM located at ServiceIPJVMLocation. The options passed into the JVM are controlled by setting the ServiceJVMOptions. The JVM will use the value of ServiceJVMClassPath as its CLASSPATH. After a successful installation, this setting is configured to include Java classes of the OpenAccess SDK and the directory where you have installed the OpenAccess SDK. If your Java classes require additional paths then you must add them in this ServiceJVMClassPath setting. If this setting is not set, the JVM uses the CLASSPATH environment variable set in ServiceEnvironmentVariable. Add any additional JAR files and paths that are required by your IP.
Refer to the OpenAccess SDK Administrator's Guide for information about how to configure a new data source or to set up a new OpenAccess SDK service for your IP based on the provided Java template. Initially, you should use the existing OpenAccessSDK810_Java service and add a data source for configuring your IP. Assuming you call this data source yourip, the OpenAccess SDK Client references the yourip data source entry within the OpenAccessSDK810_Java service.
Note: You must stop and restart the service for configuration changes to take effect and each time the IP class is recompiled.
DataSourceIPType - DAMIP.