Welcome Guest! Log in
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

A stambia session ends with status WITH_ERRORS, and the action that failed has the following error in CORE_RET_MESS


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:400)
    at com.indy.engine.actionCodes.JdbcToXmlActionCodeI.executeSimpleCode(SourceFile:701)
    at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1608)
    at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1767)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'

...

The message generally contains the name of the JDBC driver required for connecting to the database (oracle.jdbc.driver.OracleDriver, com.ibm.db2.jcc.DB2Driver, com.mysql.jdbc.Driver, org.postgresql.Driver, com.microsoft.sqlserver.jdbc.SQLServerDriver, etc.)

Solution

Install the missing JDBC driver in the directory stambiaRuntime/lib/jdbc of the Runtime that executed the session.

If the Runtime is installed as a Windows service, also remove and reinstall the service:

> installEngineAsService.bat -r <service name>

> installEngineAsService.bat -i <service name>

And then restart the Runtime.

 

 

Knowledge Base

Suggest a new Article!