> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# hibernate.properties

## File purpose

The **hibernate.properties** file is used to configure the Content
Service database and connections to the Content Server.

## File values

<table><thead><tr><th>Property</th><th>Default value</th><th>Description</th></tr></thead><tbody><tr><td>content-service.db.hibernate.dialect</td><td><code>org.hibernate.dialect.H2Dialect</code></td><td>SQL dialect used for the Hibernate connection to the content server.</td></tr><tr><td>content-service.db.hibernate.show\_sql</td><td><code>false</code></td><td>Enable/disable the logging of all generated SQL statements to the console.</td></tr><tr><td>content-service.db.hibernate.format\_sql</td><td><code>false</code></td><td>Enable/disable formatting the generated SQL statement. Enabling this makes the statement more readable, but takes up more screen space.</td></tr><tr><td>content-service.db.hibernate.format\_sql</td><td><code>false</code></td><td>Enable/disable formatting the generated SQL statement. Enabling this makes the statement more readable, but takes up more screen space.</td></tr><tr><td>content-service.db.hibernate.connection.provider\_class</td><td><code>org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl</code></td><td>Implementation of the ConnectionProvider.</td></tr><tr><td>content-service.db.url</td><td><code>jdbc:h2:mem:./content-server;DB\_CLOSE\_DELAY=-1</code></td><td>The URL of the Hibernate connection to the content server.</td></tr><tr><td>content-service.db.file.name</td><td><code>content-server</code></td><td>Name of the content server’s mv.db file.</td></tr><tr><td>content-service.db.defaultAutoCommit</td><td><code>false</code></td><td>The default auto-commit state of connections created by this pool.</td></tr><tr><td>content-service.db.driverClassName</td><td><code>org.h2.Driver</code></td><td>The fully qualified Java class name of the JDBC driver to be used.</td></tr><tr><td>content-service.db.hibernate.hbm2ddl.auto</td><td><code>update</code></td><td>Hibernate database schema generation process. Possible values are: none, create-only, drop, create, create-drop, validate, update.</td></tr><tr><td>content-service.db.jdbcInterceptors</td><td><code>org.apache.tomcat.jdbc.pool.interceptor.ConnectionState</code></td><td>A semicolon-separated list of classnames, extending the org.apache.tomcat.jdbc.pool.JdbcInterceptor class. These interceptors will be inserted as an interceptor into the chain of operations on a java.sql.Connection object.</td></tr></tbody></table>