Close

Database configuration

Set the following properties to update the database properties.

JDBC connection

Set the following properties to configure a JDBC connection:

Property Description
datasource.driver The JDBC driver used to connect to the database. Note that the driver must be on the classpath of the web application.
datasource.url The JDBC URL used to connect to the database.
datasource.username The user of the database system that is used to connect to the database.
datasource.password The password of the above user.

Example:

com.mysql.cj.jdbc.Driver
datasource.url=jdbc:mysql://127.0.0.1:3306/activiti?characterEncoding=UTF-8

datasource.username=alfresco
datasource.password=alfresco

Connection pooling

When using JDBC Connection Parameters, you can configure the following connection pool settings to suit the anticipated load:

Property Description
datasource.min-pool-size The minimum number of connections in the connection pool. For example 5.
datasource.max-pool-size The maximum number of connections in the connection pool. For example 100.
datasource.acquire-increment The number of additional connections the system will try to acquire each time the connection pool is exhausted. For example 5.
datasource.preferred-test-query The query used to verify that the connection is still valid. The value depends on the database: select 1 for H2, MySQL, PostgreSQL and Microsoft SQL Server, SELECT 1 FROM DUAL for Oracle and SELECT current date FROM sysibm.sysdummy1 for DB2.
datasource.test-connection-on-checkin Boolean value. If true, an operation will be performed asynchronously on every connection checkin to verify that the connection is valid. For best performance, a proper datasource.preferred-test-query should be set.
datasource.test-connection-on-checkout Boolean value. If true, an operation will be performed asynchronously on every connection checkout to verify that the connection is valid. Testing Connections on checkout is the simplest and most reliable form of Connection testing. For best performance, a proper datasource.preferred-test-query should be set.
datasource.max-idle-time The number of seconds a connection can be pooled before being discarded. For example 1800.
datasource.max-idle-time-excess-connections Number of seconds that connections in excess of minPoolSize should be permitted to remain idle in the pool before being discarded. The intention is that connections remain in the pool during a load spike. For example 1800.

The connection pooling framework used is C3P0. It has extensive documentation on the settings described above.

JNDI data source

If a JNDI data source is configured in the web container or application server, the JNDI name should be set with the following properties:

Property Description
datasource.jndi.name The JNDI name of the datasource. This varies depending on the application server or web container. For example jdbc/activitiDS.
datasource.jndi.resourceRef Set whether the look up occurs in a J2EE container, that is, if the prefix java:comp/env/ needs to be added if the JNDI name doesn’t already contain it. For example true.

Example (on JBoss EAP 6.3):

datasource.jndi.name=java:jboss/datasources/activitiDS

Hibernate settings

The Process Services specific logic is written using JPA 2.0 with Hibernate as implementation. Note that the Process Engine itself uses MyBatis for full control of each SQL query.

Set the following properties.

Property Description
hibernate.dialect Required. The dialect implementation that Hibernate uses. This is database specific.

The following values are used to test Process Services.

Database Dialect
H2 org.hibernate.dialect.H2Dialect
MySQL org.hibernate.dialect.MySQLDialect
Oracle org.hibernate.dialect.Oracle10gDialect
SQL Server org.hibernate.dialect.SQLServerDialect
DB2 org.hibernate.dialect.DB2Dialect
PostgreSQL org.hibernate.dialect.PostgreSQLDialect

Optionally, the hibernate.show_sql property can be set to true if the SQL being executed needs to be printed to the log.

Edit this page

Suggest an edit on GitHub
This website uses cookies in order to offer you the most relevant information. Please accept cookies for optimal performance. This documentation is subject to the Alfresco documentation terms.