Description

A JDBC configuration file contains a standard set of parameters that enables a source to connect to a target SQL database.

• user - Defines a name used to connect as a user to the database.
• password - Defines a password used to connect to the database for the given user.
• url - Defines the Universal Resource Locator (URL) to connect to the given database.
• driver - Defines the path and name of the JDBC driver Jar file. The Jar contains a Java program that uses the JDBC API to load the specified driver for a particular DBMS before it actually connects to a database. The JDBC DriverManager class then sends all JDBC API calls to the loaded driver.
• batchCount - Defines the number of rows sent to the database per batch.

Example JDBC Configuration File

Below is an example of a JDBC configuration file defined to connect to a MySQL database called acme:

driver=com.mysql.jdbc.Driver
user=root
password=openSaysMe
url=jdbc:mysql://localhost:3306/acme?rewriteBatchedStatements=true
batchCount=1000