Symptom

When executing a mapping or a process, the session fails with an error like this one: java.sql.SQLException: SQL Exception.

java.sql.SQLException: SQL Exception
    at com.indy.engine.main.connections.b.b(SourceFile:247)
    at com.indy.engine.main.connections.b.a(SourceFile:314)
    at com.indy.engine.main.connections.JDBCConnectionContainerI.<init≶(SourceFile:33)
    at com.indy.engine.action.common.ActionCodeTypeI.setConnection(SourceFile:417)
    at com.indy.engine.actionCodes.JdbcActionCodeI.executeDDL_DML(SourceFile:812)
    at com.indy.engine.actionCodes.JdbcActionCodeI.executeSimpleCode(SourceFile:1375)
    at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1646)
    at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1805)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.teradata.jdbc.TeraDriver'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.indy.engine.main.connections.b.b(SourceFile:228)
    ... 8 more
Caused by: java.lang.ClassNotFoundException: com.teradata.jdbc.TeraDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 11 more

Solutions

As you can read in this stack trace, the Runtime cannot find the JDBC driver required for connecting to the database. In our example it is a Teradata database.

The solution is to :

- download the required JDBC drivers from the internet,

- install them in the directory stambiaRuntime/lib/jdbc,

- finally restart the Runtime.