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

The file is located in the folder **simm-starter\src\main\resources**.

## 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               | Property is commented out                                                       | 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                            | mr\_ref\_impl\_content\_service                                                 | The name of the dbfile used in the Hibernate connection URL.                                                                                                                                                                   |   |
| content-service.db.defaultAutoCommit                    | false                                                                           | The default auto-commit state of connections created by this pool.                                                                                                                                                             |   |
| content-service.db.driverClassName                      | 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. |   |