Database Connection
Common Parameters
- db.use
-
Sets the mode to be used to connect to the database
-
jdbc
: Every web application maintains its own connections ("direct connection") -
jndi
(recommended): All web applications use shared connections provided by the Tomcat container via JNDI ("container-managed").
-
- db.type
-
Vendor-specific type of the database system used. This is used internally to generate correct and optimized database queries. Allowed values are
sqlserver
(Microsoft SQL Server),postgresql
(PostgreSQL), andoracle
(Oracle). - db.jndi.name
-
The JNDI name with which the database can be queried by the container. This setting normally has the value
java:comp/env/jdbc/secman
. - db.hibernate.schemaUpdate
-
Switches the automatic table generation on or off. Permitted values are
validate
,update
and an empty string. Set this parameter to an empty string in productive environments.
Parameters for "direct connection"
The following parameters are only used, when db.use=jdbc
is set.
- db.jdbc.url
-
The URL of the JDBC database connection. Its value depends on the database system in use. Example:
-
jdbc:postgresql://localhost:5432/secman
(PostgreSQL) -
jdbc:sqlserver://localhost:1433;DATABASENAME=secman
(Microsoft SQL Server) -
jdbc:oracle:thin:@localhost:1521:XE
(Oracle)
-
- db.jdbc.username
-
Username of the person using the database.
- db.jdbc.password
-
Password of the person using the database.
- db.jdbc.maxActiveConnections
-
Maximum number of active database connections in the deployed connection pool.