ART Database

ART Database

The ART database is the database used by ART to hold details like users, report definitions etc. Use the Configure | ART Database menu to define details of the ART database.

Field	Description
Database Type	The database software that the ART database runs on
JNDI	Whether the ART database is a JNDI datasource
Database Protocol	An indication of the kind of syntax the database uses
JDBC Driver	The JDBC driver name
URL	The database JDBC URL, or if you are using a JNDI datasource, the JNDI name of your datasource e.g. jdbc/MyDatasource. You can also use the full JNDI url e.g. java:comp/env/jdbc/MyDatasource
Username	The user to use to connect to the ART database. The user needs SELECT, INSERT, UPDATE and DELETE rights on the ART tables.
Password	The database user's password
Test SQL	A short SQL query used to determine if a connection is alive e.g. "Select 1"
Connection Pool Timeout (Mins)	How long in minutes an idle connection should be maintained in the connection pool before being closed. This setting applies to the ART database as well as all report datasources.
Max Pool Connections	The maximum number of connections a connection pool can open to the same datasource. Further requests are queued. This setting applies to the ART database as well as all report datasources.