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

On Sun, Dec 28, 2014 at 8:55 PM, Sandeep Gondhalekar <
sandeep(dot)gondhalekar1(at)gmail(dot)com> wrote:

> Thanks all for prompt replies.
>
> I have copied ojdbc7.jar under "C:\Program Files (x86)\Java\jre7\lib" and
>
> SET CLASSPATH="C:\Program Files (x86)\Java\jre7\lib"
> still no luck.
>
>
> On Sun, Dec 28, 2014 at 1:57 PM, Harshad Adalkonda <
> adalkondaharshad(at)gmail(dot)com> wrote:
>
>> 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
>>>
>>> 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
>>>
>> Hi Sandeep,
>>
>> First you need to copy ojdbc7.jar in proper location, then *edit* the
>> *toolkit.properties* file which is located in *etc* folder of
>> installation of MTK.
>>
>> *Example:*
>>
>> SRC_DB_URL=jdbc:oracle:thin:@localhost:1521:xe
>> SRC_DB_USER=hr
>> SRC_DB_PASSWORD=hr
>>
>> TARGET_DB_URL=jdbc:postgresql://localhost:5432/postgres
>> TARGET_DB_USER=postgres
>> TARGET_DB_PASSWORD=postgres
>>
>> After saving the *toolkit.properties *file run runMTK.bat from cmd as
>> follows:
>>
>> runMTK.bat -sourcedbtype source_database_name -targetdbtype
>> target_database_name schema_name
>>
>> *Example:*
>>
>> runMTK.bat -sourcedbtype oracle -targetdbtype postgres public
>>
>> I hope this will solve your problem.
>>
>> Thanks & Regards,
>>
>> Harshad Adalkonda
>> Database Administrator
>>
>> http://www.shreeyansh.com
>>
>
>
Hi Sandeep,

The driver copying location is wrong

Copy driver to *C:\Program Files (x86)\Java\jre7\lib\ext\ *location

copy both oracle & postgresql drivers under above location.

I hope now this time it will solve your porblem.

*Thanks & Regards,*

Harshad Adalkonda

Database Administrator

http://www.shreeyansh.com