Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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.

Knowledge Base

Suggest a new Article!