Connection configuration

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.

note

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	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 following are extracts from the sample configuration supplied in the Configuration appendix. The schemas for these configurations can be found in the Schema appendix.

XML

Important

In this section, the word "connection" is erroneously written as "connnection". This is a known issue and will be corrected in a future update.

<?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&amp;password=password</cfg:url>
    <cfg:driver>org.postgresql.Driver</cfg:driver>
  </cfg:connnection>

Connection configuration example in XML format

JSON

"connection": {
    "url": "jdbc:postgresql://localhost:1234/postgres?user=user&password=password",
    "driver": "org.postgresql.Driver"
}

Connection configuration example in JSON format

YAML

connection:
  url: >-
    jdbc:postgresql://localhost:1234/postgres?user=usesr&password=password
  driver: org.postgresql.Driver

Connection configuration example in YAML format

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.