Portal

Symptom : 

When running a mapping or process, the error  `ClassNotFoundException: <driverClass>` is raised.

The error looks like something as below : 

java.sql.SQLException: SQL Exception
               at com.indy.engine.main.connections.b.b(SourceFile:253)
               at com.indy.engine.main.connections.b.a(SourceFile:320)
               at com.indy.engine.main.connections.JDBCConnectionContainerI.<init>(SourceFile:43)
               at com.indy.engine.action.common.ActionCodeTypeI.setConnection(SourceFile:379)
               at com.indy.engine.actionCodes.JdbcActionCodeI.executeDDL_DML(SourceFile:769)
               at com.indy.engine.actionCodes.JdbcActionCodeI.executeSimpleCode(SourceFile:1271)
               at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1509)
               at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1653)
               at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver
               at com.indy.runtime.jdbc.JdbcDataSource.connectWithStandardJdbc(JdbcDataSource.java:126)
               at com.indy.runtime.jdbc.JdbcDataSource.getConnection(JdbcDataSource.java:464)
               at com.indy.runtime.jdbc.JdbcDataSource.getConnection(JdbcDataSource.java:109)
               at com.indy.engine.main.connections.c.<init>(SourceFile:22)
               at com.indy.engine.main.connections.b.b(SourceFile:243)
               ... 8 more
Caused by: java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver
               at java.net.URLClassLoader.findClass(Unknown Source)
               at java.lang.ClassLoader.loadClass(Unknown Source)
               at java.lang.ClassLoader.loadClass(Unknown Source)
               at java.lang.Class.forName0(Native Method)
               at java.lang.Class.forName(Unknown Source)
               at com.indy.runtime.jdbc.JdbcDataSource.connectWithStandardJdbc(JdbcDataSource.java:124)
               ... 12 more

Solution : 

The issue is due to the fact that the Runtime does not find the JDBC driver.

Please make verify that the files .jar for the driver is correctly installed in the Runtime.

• If Runtime version is S17 : in the folder ../lib/jdbc
• If Runtime version is S20 : in the module folder of the used Metadata