DBCPConnectionPool

The DBCPConnectionPool controller service provides a single place to configure connections to remote databases in Clockspring.   This service allows you to consolidate connection and login information for your database that can be leveraged by database processors to significantly reduce the setup of each individual processor.

While the DBCPConnectionPool service has many different properties available, this document will cover the most commonly used settings:

Database Connection URL

This field is where you enter your jdbc connection string.    While each database has its own options available for connection strings, the majority of common databases will use this format:

jdbc:[databaseType]://[serverName][:portNumber]]

MSSQL:

jdbc:sqlserver://sqlserver.dev.domain.com:1234;encrypt=true;databaseName=my_database;integratedSecurity=true; 

jdbc:mysql://mysqlserver.dev.domain.com:33060/my_database

jdbc:postgresql://pgserver.dev.domain.com:5432/my_database

Database Driver Class Name

This field holds the class name for the driver that will be loaded in the following step.    Each driver has their own unique class name that the driver provider should provide.

Database Driver Location(s) 

Specify the location on the local filesystem where the driver can be loaded from.   Include the absolute path to the driver file (including the file name).

Database User

Specify the username that this service will use to log in to the database

Password

Specify the password associated to the defined user

Other Properties

There are a number of other properties available in the DBCPConnectionPool that are outside of the high-level overview provided here.    Check the property description for each property to get more information or refer to the Usage Guide for the specific controller service.

Controller Service Usage

Refer to Controller Services Overview for more information on how Controller Services work within Clockspring.