Title
"java.sql.SQLException: No suitable driver" when executing a scenario from the command prompt

Date
2009-02-05

Summary
When starting a scenario from the command prompt, you may receive the following error: 
    C:\oracle\product\10.1.3\odi_1\oracledi\bin>startscen TRANSFEREMPLOYEES 001 GLOBAL
-SECU_URL=jdbc:oracle:think:@plm3:1521:orcl -SECU_DRIVER=oracle.jdbc.driver.OracleDriver
OracleDI: Starting scenario TRANSFEREMPLOYEES 001 in context GLOBAL ...
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:243)
        at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)
        at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java)
        at com.sunopsis.sql.i.run(i.java)
Details
1. Ensure that the Repository Connection Information is configured correctly in the %ODI_HOME%/bin/odiparams.bat (or odiparams.sh) file. The example below uses JDBC: 

set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@myserver:1521:orcl

Applicable Versions
Oracle Data Integrator 10g (10.1.3)
Ahmed Aboulnaga
.com .com