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