Issue

When executing a mapping or a process in Semarchy xDI, the session fails with an error message similar to the following: java.sql.SQLException: SQL Exception.

The detailed stack trace may include lines indicating a failure to load the JDBC driver, such as:

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.teradata.jdbc.TeraDriver'

Cause

The error occurs because the required JDBC driver for connecting to the specified database is not available in the Semarchy xDI runtime environment. In this case, the missing driver is for a Teradata database.

Solution

  1. Download the JDBC driver corresponding to your database version.
  2. Install the driver in the module used by the target technology.
  3. Examples:
    • PostgreSQL:
      semarchy-xdi-designer/runtime/modules/PostgreSQL
    • Oracle:
      semarchy-xdi-designer/runtime/modules/Oracle
    • SQL Server:
      semarchy-xdi-designer/runtime/modules/Microsoft SQL Server
    • Teradata:
      semarchy-xdi-designer/runtime/modules/Teradata
  4. Verify that the JDBC Driver Class configured in the metadata matches the driver installed in the module.
  5. Restart the Runtime or Designer after adding the driver.
  6. Test the metadata connection and rerun the process.