Zum Hauptinhalt springen

hibernate.cfg.xml

Die nachfolgenden Inhalte sind nur in englischer Sprache verfügbar.

This file is configured using XML syntax.

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

Notes

  • All other parameters are not described here.

  • The connection testing options should be used with care because of their performance impact.

  • In most cases, no manual changes should be required, as the Installer sets all values based on queried information.

  • For configuration of the connection pooling, see the c3p0 documentation.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.