skip to main content
Configuring an OpenAccess SDK IP for a Third-Party SQL Engine : Configuring Services and Data Sources : Configuring Attributes for an IP Written in Java
 

Configuring Attributes for an IP Written in Java

OpenAccess SDK installation creates a service based on the Service for Java template to support accessing a SQL data source using an IP written in Java. The following table describes the service attributes that are required in setting up the service, and provides the display group in the OpenAccess SDK Management Console. For more information on these service attributes, see OpenAccess SDK Service Attributes.
Table 17. Service Attributes Used for an IP Written in Java
Setting Group
Attribute Name
Description
IP Parameters
Specifies the SQL engine configuration file. This file must be located in the path specified by the ServiceIPPath attribute. The default is oasql.ini.
IP Parameters
Specifies the name of the OpenAccess SDK module for interfacing the OpenAccess SDK service with a Java IP. The default is oadamipjava.{lib}. This value is required.
IP Parameters
Specifies the SQL engine module. The default is oadssqlip.{lib}. This value is required.
IP Parameters
Specifies the CLASSPATH value to pass into the JVM initialization. The installer sets the minimally required value to which you should append any directories and JAR files required for your IP.
IP Parameters
The path to the location of the JVM library. For example:/usr/jdk1.5/jre/bin/server
IP Parameters
Specifies the options to pass to the JVM that is loaded to run the Java IP. The supported options and their syntax are the same as with the java command. Example: -Xrunjdwp:transport=dt_socket,address=9003,server=y,suspend=n -Xdebug
The following table describes the data source attributes that are required in setting up the data source for the service, and provides the display group in the OpenAccess SDK Management Console.
Table 18. Data Source Attributes Used for an IP Written in Java
Setting Group
Attribute Name
Description
IP Parameters
Specifies the name of the class implementing the IP for the SQL data source. Each data source under a Service for Java can have its own IP class. The class name should be relative to the install_dir/ip folder. For example:oasqlip/oajava/jdbc
IP Parameters
Determines how the third-party SQL engine handles access to this data source.All user-written IPs must set this attribute to DAMIP.
User Security
Specifies the data store logon method to be used to log on to the data source. Set to Anonymous if you do not want the IP code to authenticate the user.
Workarounds
Set to 8192 to enable Microsoft Access to correctly use the driver.