Database Configuration

This screen contains options for configuring the database connection for your system.

The button for SQL Command Windows displays a utility program to allow you to execute arbitrary SQL statements against the database.

The definitive reference for configuring the database is configuration.properties and SQL Database Installation Instructions

Database Type

This dropdown allows you to set the database type you are using. It is very important this value be set to the correct value for your installation. Failure to set this option correctly will result in added records that cannot be edited.

JDBC Driver Class

This is the class name for your JDBC Driver. The class name will generally be something like: com.company.jdbc.xxx.xxx. Refer to your database documentation for the correct values for your database.

JDBC Connection String

This is the connection URL to your JDBC Database.

Database User ID & Database Password

The User ID and Password the JDBC Driver should use to login to the database.

Database Backup Path

If your database supports SQL backup commands, then you can enter the path to create SQL Database backups here. Keep in mind that the path is the path on the database server, not machine you're running a browser from, or the machine running Connect Daily.