skip to main content
Configuring the OpenAccess SDK 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 where applicable, provides the display group in the OpenAccess SDK Management Console.
Table 5. Service Attributes Used for an IP Written in Java
Setting Group
Attribute Name
Description
Advanced
Sets the connection model. The default is Thread/Connection.
Environment
Specifies a list of variables that will be set before the OpenAccess SDK service is started. The syntax for valid values is varname=value. This attribute should contain the library path for the JVM.
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 an IP written in Java. The default is oadamipjava.{lib}. This value is required.
IP Parameters
Specifies the OpenAccess SDK 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
Specifies 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 your IP. The supported options and their syntax are the same as with the java command. For 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 where applicable, provides the setting group in the OpenAccess SDK Management Console.
Table 6. Data Source Attributes Used for an IP Written in Java
Display Group
Attribute Name
Description
N/A
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
Specifies the path where the schema files are located. For example:C:\Program Files\Progress\DataDirect\oaserver81\ip\ schema\example1
IP Parameters
Determines how the OpenAccess SDK 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.