Welcome Guest! Log in


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.

 

 

You have no rights to post comments

Knowledge Base

Suggest a new Article!