OpenAccess SDK allows you to pass custom connection properties directly to the IP layer. The custom connection properties are key=value pairs separated by semicolons, and surrounded by parentheses to distinguish them from the other connection properties. For example:
The maximum length of the connect string is 16384 characters.
You must define the custom connection properties in the DataSourceIPCustomProperties service attribute in the configuration file of the OpenAccess SDK Server. The default value for each connection property is also set in this OpenAccess SDK Server attribute. Only the defined custom properties are sent to the JDBC Client and can be overwritten by the application. Refer to the OpenAccess SDK Administrator’s Guide for information about the DataSourceIPCustomProperties service attribute.
The custom connection properties can be set in:
• The connection url
• The JDBC data source. To handle these properties, you can use getCustomProperties and setCustomProperties.
The JDBC Client URL parser considers the string between the braces in the CustomProperties connection option as a free-format string that is sent directly and unmodified to the IP layer. This means the connection options in the Custom Properties can have the same name as the connection options in the URL.
