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 storage location for this database depends on the hibernate.connectionUrl setting.
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.connection.url hibernate property. |
|
Possible values |
Connection URL to the database. Generally begins with "jdbc:". |
|
Default value |
|
The storage location for the H2 database can be changed by adjusting the path of the default value. 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.dialect hibernate property. |
|
Possible values |
A character string that refers to the valid hibernate database dialect. |
|
Default value |
|
hibernate.connectionUsername
|
Description |
The database user name. Used for the hibernate.connection.username hibernate property. |
|
Possible values |
The user name with which access to the database is authorised. |
|
Default value |
sa |
hibernate.connectionPassword
|
Description |
The database password. Used for the hibernate.connection.password hibernate property. |
|
Possible values |
The password with which access to the database is authorised. |
|
Default value |
- |