Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: No suitable driver

Juan Algaba ColeraApr 18 2010 — edited Apr 20 2010
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
This post has been answered by 576432 on Apr 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2010
Added on Apr 18 2010
6 comments
3,309 views