java.sql.SQLException: No suitable driver
I am new to ODI, and I am trying to run the following ODI Demo:
[Creating and Connecting to ODI Master and Work Repositories|http://www.oracle.com/technology/obe/fusion_middleware/odi/ODImaster_work_repos/ODImaster_work_repos.htm]
but I cannot get started with the demo, because when I try to connect the Master Repository Creation Wizard to the Oracle 10g XE database, I get the following error message:
java.sql.SQLException: No suitable driver
There are two sections in the ODI installation guide 10.1.3 that I find tricky, and perhaps I have not understood them properly:
_"Java configuration" section:_
I have not installed a new jdk or jre, since jre 1.4.2 has already been installed with ODI, and ODI_JAVA_HOME is already pointing to it:
ODI_JAVA_HOME=C:\OraHome_1\jre\1.4.2
__"Installing JDBC / JMS drivers" section:__
I have included the jdbc drivers included in Oracle XE 10g in the CLASSPATH:
ORACLE_HOME/jdbc/lib/ojdbc14.jar
ORACLE_HOME/jlib/orai18n.jar
in my case, that translates to:
CLASSPATH=C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;C:\oraclexe\app\oracle\product\10.2.0\server\jlib\orai18n.jar
I am new to java, as well, so I might have made some mistake configuring the java environment. Can anyone help me out?
Juan Algaba Colera