Adding a new JDBC/ODBC Database Driver/Connector to Smarten

Requirement: Need to add a new JDBC/ODBC driver in Smarten that does not exist in the list of data source connectors.

Scenario: For our example we need to add a new driver for MySQL (v8) database in Smarten. Assumption is that you have the .jar file of the driver available with you.

Steps to update database driver/connector

The following are the steps for adding the driver/connector in Smarten.

1.  Stop Wildfly (Smarten) Service if running.

2. Add the jar file to the library

With respect to our example, add mysql-connector-java-8.0.22.jar to the folder location: smarten.war/WEB-INF/lib.

3. Now that the driver jar is added, we need to add the following statement in Default.conf file for allowing Smarten to show the driver in the data source listing in the create Data Source screen. File location for the said configuration is smarten.war/conf/Default.conf. PFA the screenshot for example on how to write this with respect to our example.

DATABASE_DIALECT_NAME=org.hibernate.dialect.SQLServerDialect||org.hibernate.dialect.Oracle10gDialect||-||org.hibernate.dialect.MySQL8Dialect||org.hibernate.dialect.PostgreSQLDialect||org.hibernate.dialect.SybaseASE15Dialect||-||-||-||-||-||-||-||-||-             

4.   Restart the Wildfly service

Note: The same steps are to be executed in case we need to upgrade an existing JDBC/ODBC driver to its newer version. The only change in that case would be to REPLACING instead of ADDING the jar file in step 2 above.