Parameters
| Example value or
Possible values | Description | Available from |
|---|
| as variable name in the config file | as environment variable with
namespace "planta__server__" as prefix | | | |
|---|
dialect | hibernate__dialect | de.planta.server.hibernate.dialect.Oracle10gDialect
de.planta.server.hibernate.dialect.SQLServerDialect | Configures Oracle or MSSQL sql dialect | S 39.5.34 |
hibernate.connection.driver_class | hibernate__connection__driver_class | oracle.jdbc.driver.OracleDriver
com.microsoft.sqlserver.jdbc.SQLServerDriver | Configures the JDBC driver |
|
hibernate.connection.url | hibernate__connection__url | URL with SID: jdbc:oracle:thin:@$db.server:$db.oracle.port:$db.name
URL with service names: jdbc:oracle:thin:@//db_hostname:port/service_name | DB connection URL - configured via installer |
|
hibernate.connection.username | hibernate__connection__username | USER_123 | Username used for connecting to the DB |
|
hibernate.connection.password | hibernate__connection__password | gE_he1M | Password used for connecting to the DB |
|
hibernate.default_schema
| hibernate__default_schema |
| Applies to oracle users only, in the context of sql server, the term database schema has an entirely different meaning.
Required if the oracle user name deviates from the schema name to be used. | |
hibernate.jdbc.fetch_size
| hibernate__jdbc__fetch_size | 32 - 8192
recommended: 512 | Number of lines that will be transfered for reading |
|
hibernate.jdbc.batch_size
| hibernate__jdbc__batch_size | 8 - 64
recommended: 32 | Number of lines that will be transfered for writing |
|
|
|
|
|
|
| Connection testing | | Values | Description | |
|---|
hibernate.c3p0.testConnectionOnCheckout | hibernate.c3p0.testConnectionOnCheckout | false | Tests a connection before it is used |
|
hibernate.c3p0.testConnectionOnCheckin | hibernate.c3p0.testConnectionOnCheckin | false | Tests a connection after it was used |
|
hibernate.c3p0.idleConnectionTestPeriod | hibernate.c3p0.idleConnectionTestPeriod | 300 | Period after which an idle connection is tested |
|
