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…


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.)


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!