The database connection is defined in the hibernate section of settings.properties. If a user-defined database is not specified, signoSign/Universal will start an H2 database. The location of the database depends on the setting hibernate.connectionUrl.
The following settings are possible in settings.properties with the prefix ‘hibernate.’.
hibernate.connectionDriverClassName
|
Description |
The JDBC driver class. Used for the hibernate.connection.driver_class hibernate property. |
|
Possible values |
Fully qualified class name of the JDBC driver. |
|
Default value |
|
The class specified must be recognised in the classpath. In addition, the corresponding JAR can either be stored in the Lib folder of the signoSign/Universal application or also made available on the server used.
hibernate.connectionUrl
|
Description |
The JDBC URL to the database instance. Used for the hibernate property hibernate.connection.url. |
|
Possible values |
Connection URL to the database. Usually begins with ‘jdbc:’. |
|
Default value |
|
To change the storage location of the H2 database, the path of the default value can be adjusted. Example:
hibernate.connectionUrl=jdbc:h2:tcp://localhost/c:/my/custom/folder/mydatabasefilename
hibernate.dialect
|
Description |
Hibernate uses this property to generate the corresponding SQL for the selected database. Used for the hibernate property hibernate.dialect. |
|
Possible values |
A character string that refers to the valid hibernate database dialect. |
|
Default value |
|
hibernate.connectionUsername
|
Description |
The database username. Used for the hibernate property hibernate.connection.username. |
|
Possible values |
The username with which access to the database is authorised. |
|
Default value |
sa |
hibernate.connectionPassword
|
Description |
The database password. Used for the hibernate property hibernate.connection.password. |
|
Possible values |
The password with which access to the database is authorised. |
|
Default value |
- |