Configuration

Configuration manual for PageSeeder

Database properties

The database properties specify how PageSeeder connects to the database.

The values will vary depending on the location of the database engine and the JDBC Driver used.

Servlet: DBMonitor can be used to check the health of the PageSeeder server and database connection.

Database properties

PropertyDescription

DBDriver

The name of the class implementing the JDBC Driver interface

DBURL

The JDBC URL to access the database.

HostName

The name of the machine hosting the MySQL database server.

LoginPassword

The password to access the MySQL database - can only be used to reset the EncryptedPassword.

EncryptedPassword

The encrypted password to access the MySQL database.

LoginName

The login to access the MySQL database.

DatabaseName

The name of the MySQL database.

DatabaseType

The type of database used.

MaxConnections

The maximum number of connections in the database pool* - default 100.

* If MaxConnections > 140 (and  <  990) it is recommended to add the following to /etc/my.cnf on Linux just under [mysqld] and restart MySQL.

max_connections=1000
open_files_limit=8192

PageSeeder uses the same properties regardless of the driver implementation.

Use the JDBC URL to define driver specific parameters.

Implementation specific values

MySQL Connector/J

Property

Value

DBDriver

com.mysql.jdbc.Driver

DBURL

jdbc:mysql://[host]/[database]

DatabaseType

MySQL

 Derby Driver

Property

Value

DBDriver

org.apache.derby.jdbc.EmbeddedDriver

DBURL

jdbc:derby:[database];create=true

DatabaseType

Derby

Created on , last edited on