Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, July 6, 2011

java.sql.SQLException: No suitable driver when involing ODI

If you are trying to login into the remote server using local operator client.
ODI-10g:

The error means:
■ No suitable driver
The JDBC URL is incorrect. Check that the URL syntax is valid


In the below screenshot:























I had a space in my URL link: and as soon as I deleted it the connection worked fine.










If you are trying to connect to the local ODI database:

Make sure odiparam.bar is correctly configured in the %ODI_HOME%/bin/odiparams.bat (or odiparams.sh) file.
from

rem
rem Repository Connection Information
rem
set ODI_SECU_DRIVER=org.hsqldb.jdbcDriver
set ODI_SECU_URL=jdbc:hsqldb:hsql://localhost
set ODI_SECU_USER=sa
set ODI_SECU_ENCODED_PASS=
set ODI_SECU_WORK_REP=WORKREP
set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH

to

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

No comments: