How to Configure the Java Application

Goal

Configure the application by adding

• the database driver to the maven dependencies, in the pom.xml
• the database URL to the src/main/resources/config.properties

Database Driver (pom.xml)

Navigate to pom.xml. Add the correct Maven JDBC Driver dependency.

pom.xml (Sql Server dependency)

SQL Server Example

    ...
    <dependency>
      <groupId>com.microsoft.sqlserver</groupId>
      <artifactId>mssql-jdbc</artifactId>
      <version>9.4.0.jre8</version> <!-- Note jre8, not jre11 or jre16 -->
    </dependency>
    ...

MySql Example

    ...
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.26</version>
    </dependency>
    ...

Tips:

Find the correct Maven Dependency by

• Search for database provider in the Maven Repository
• Visiting this blog

Note: The dependency must be Java 8 compatible.

Database URL and Credentials

Navigate to src/main/resources/config.properties. Provide the URL and credentials for the database connection here.

config.properties

SQL Server Example

# Database connection parameters
connection.host         = localhost
connection.port         = 1433
connection.db           = master
connection.schema       = pii_tables
connection.user         = username
connection.password     = password
connection.driverClass  = com.microsoft.sqlserver.jdbc.SQLServerDriver
connection.url          = jdbc:sqlserver://localhost:1433;database=master
file.encryptionkey      =
sql.wrapper             = "

MySql Example

# Database connection parameters
connection.host         = localhost
connection.port         = 3306
connection.db           = pii_tables
connection.schema       =
connection.user         = username
connection.password     = password
connection.driverClass  = com.mysql.cj.jdbc.Driver
connection.url          = jdbc:mysql://localhost:3306/pii_tables
file.encryptionkey      =
sql.wrapper             = `

• Make sure to change sql.wrapper to backticks (`) when using a MySql database. Other databases may use double quotes "
• If mapping files are encrypted, provide your own file.encryptionkey