Connection configuration
In this section of the XML file, the word "connection" is erroneously written as "connnection". This is a known issue and will be corrected in a future update. Currently, however, the misspelled form must be used.
The following constitutes the connection configuration for the attribute connector, detailing the client implementation to use, the location of the SQL database, and the type of authentication and account to use.
The type of connection to the SQL database has to be chosen.
For ASM 7.x only JDBC is supported. For ASM 6.2.8 and 6.2.9, it can be either a JNDI data source or JDBC. Depending of the choice of connection type, different elements are required.
| Connection Type | XML element or attribute | Description | Supported format |
|---|---|---|---|
| JDBC | url | This element is required for JDBC connections. The connection URL contains the URL to access the SQL database. | A valid JDBC URL. For example: jdbc:oracle:thin:@//localhost:1521/my-instance |
| JDBC | driver | This element is required for JDBC connections. The driver specifies the class name of the JDBC driver to be used by to connect to the SQL database. | A fully qualified class name of the SQL driver class. For example: oracle.jdbc.OracleDriver |
| JNDI | jdbcConnectionString | This element is required for a JNDI type connection. The data source contains the information about the JNDI data source that provides the connection to the SQL database. | A valid JNDI name for a data source. |
The illustration shows an example of how the XML elements can be implemented for a JDBC connection. It is an extract from the sample XML-format configuration file supplied in the appendix XML Configuration.
<?xml version="1.0" encoding="UTF-8"?>
<cfg:configuration xmlns:cfg="http://www.axiomatics.com/table.config" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.axiomatics.com/table.config table.config.xsd ">
<cfg:connnection>
<cfg:url>jdbc:postgresql://localhost/usda?user=usda&password=password</cfg:url>
<cfg:driver>org.postgresql.Driver</cfg:driver>
</cfg:connnection>
Connection configuration example
The XML schema for this configuration can be found in the appendix XML Schema.
Connection pooling
When configuring database access using JDBC, setting parameters for the connection pool may be considered. Refer to the documentation for the relevant host application for information on configuring connection pooling.