Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver

Поиск
Список
Период
Сортировка
От Jackson Isaac
Тема Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver
Дата
Msg-id CAJO0VXrY_hFxAR_Zz2Cz58yCf+GWJoJGW68_c49EbRfR-9iThw@mail.gmail.com
обсуждение исходный текст
Ответ на java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver  (Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>)
Список pgsql-admin
Дерево обсуждения

 

On Sat, Dec 27, 2014 at 9:59 PM, Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com> wrote:

I am using Oracle 12c to test migration from Oracle to PostgreSQL. I am using windows OS. I have copied ojdbc7.jar file under lib folder of "EnterpriseDB-MigrationToolkit"

I am getting following error:


E:\sandeep\postgres\EnterpriseDB-MigrationToolkit>runMTK.bat -verbose on -source
dbtype "oracle" @//localhost:1521/pdbsales.igatecorp.com
Source database connectivity info...
conn =jdbc:oracle:thin:@//localhost:1521/pdbsales.igatecorp.com
user =scott_name
password=******
Target database connectivity info...
conn =jdbc:postgresql://localhost:5432/postgres
user =postgres
password=******
Connecting with source Oracle database server...
Error: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Hi Sandeep,

As from the error log it seems that you haven't added oracle-jdbc driver to the classpath. You can do so by running command something like --
export CLASSPATH= "$CLASSPATH:path/to/jar/file"

Hope this helps.
 

One or more schema objects could not be imported during the migration process. P
lease review the migration output for more details.

Migration logs have been saved to C:\Users\gondhasa.IGATECORP\.enterprisedb\migr
ation-toolkit\logs

******************** Migration Summary ********************

Total objects: 0
Successful count: 0
Failure count: 0


Jackson Isaac
S5 B.Tech CSE
Amrita Vishwa Vidyapeetham
Jackson Isaac's Blog
Github/JacksonIsaac

В списке pgsql-admin по дате отправления: