> ## 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

> Reference for hibernate.properties, which configures the Content Service database for Atoti FRTB using content-service.db properties, including SQL dialect, schema generation mode, JDBC driver class, and connection URL.

## File purpose

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

Hibernate properties are prefixed with `content-service.db` and are used in `LocalContentServiceConfig`.

For standard field meanings, see [Hibernate - Appendix A: Configuration Settings](https://docs.jboss.org/hibernate/orm/6.4/userguide/html_single/Hibernate_User_Guide.html#settings).

## File values

| Property                                                | Default value                                                                   | Description                                                                                                                                                                                                                    |
| ------------------------------------------------------- | ------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| content-service.db.hibernate.dialect                    | org.hibernate.dialect.H2Dialect                                                 | SQL dialect used for the Hibernate connection to the content server.                                                                                                                                                           |
| content-service.db.hibernate.show\_sql                  | false                                                                           | Enable/disable the logging of all generated SQL statements to the console.                                                                                                                                                     |
| content-service.db.hibernate.format\_sql                | false                                                                           | Enable/disable formatting the generated SQL statement. Enabling this makes the statement more readable, but takes up more screen space.                                                                                        |
| content-service.db.hibernate.hbm2ddl.auto               | update                                                                          | Hibernate database schema generation process. Possible values are: none, create-only, drop, create, create-drop, validate, update.                                                                                             |
| content-service.db.hibernate.connection.provider\_class | org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl | Implementation of the ConnectionProvider.                                                                                                                                                                                      |
| content-service.db.url                                  | jdbc:h2:%\{dbfile};DB\_CLOSE\_DELAY=-1                                          | The URL of the Hibernate connection to the content server.                                                                                                                                                                     |
| content-service.db.file.name                            | frtb\_ref\_impl\_content\_service                                               | The name of the dbfile used in the Hibernate connection URL.<br />%\{dbfile}\*\* wildcard on the database URL.                                                                                                                 |
| content-service.db.defaultAutoCommit                    | false                                                                           | The default auto-commit state of connections created by this pool.                                                                                                                                                             |
| content-service.db.jakarta.persistence.jdbc.driver      | org.h2.Driver                                                                   | The fully qualified Java class name of the JDBC driver to be used.                                                                                                                                                             |
| content-service.db.jdbcInterceptors                     | org.apache.tomcat.jdbc.pool.interceptor.ConnectionState                         | 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. |