Setting Up an OpenAccess SDK Service and Data Source
A client connects to your data source by connecting to an OpenAccess 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_SQL and installs a template for Java that you can use to create your own service. Initially, you should use the existing service OpenAccessSDK810_Java_SQL 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. See 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 a third-party SQL engine.
• DataSourceIPClass - name of the IP class that is implementing the oajava.sql.sqlip interface (for example oasqlip/oajava/jdbc).
• 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.
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 will use 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_SQL 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_SQL service.
Note: You must stop and restart the service for configuration changes to take effect.
