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