From: | Jackson Isaac <jacksonisaac2008(at)gmail(dot)com> |
---|---|
To: | Sandeep Gondhalekar <sandeep(dot)gondhalekar1(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver |
Date: | 2014-12-27 18:04:02 |
Message-ID: | CAJO0VXrY_hFxAR_Zz2Cz58yCf+GWJoJGW68_c49EbRfR-9iThw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sat, Dec 27, 2014 at 9:59 PM, Sandeep Gondhalekar <
sandeep(dot)gondhalekar1(at)gmail(dot)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 <http://www.jacksonisaac.wordpress.com>
Github/JacksonIsaac <https://github.com/jacksonisaac>
From | Date | Subject | |
---|---|---|---|
Next Message | Harshad Adalkonda | 2014-12-28 08:27:19 | Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver |
Previous Message | Scott Ribe | 2014-12-27 17:43:41 | Re: [ADMIN] [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver |