pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
7+ messages / 4 participants
[nested] [flat]
* java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-27 16:29 Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
0 siblings, 3 replies; 7+ messages in thread
From: Sandeep Gondhalekar @ 2014-12-27 16:29 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-27 17:31 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
2 siblings, 1 reply; 7+ messages in thread
From: Scott Ribe @ 2014-12-27 17:31 UTC (permalink / raw)
To: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>; +Cc: pgsql-admin
On Dec 27, 2014, at 9:29 AM, Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com> wrote:
>
> Migration logs have been saved to C:\Users\gondhasa.IGATECORP\.enterprisedb\migr
> ation-toolkit\logs
Pretty sure you're going to have to look in the logs as suggested by the message before anyone can help.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-27 17:43 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 7+ messages in thread
From: Scott Ribe @ 2014-12-27 17:43 UTC (permalink / raw)
To: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>; +Cc: pgsql-admin
On Dec 27, 2014, at 10:31 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
> Pretty sure you're going to have to look in the logs as suggested by the message before anyone can help.
Oops, missed the line about Oracle driver class not being found.
I don't know EnterpriseDb, but it seems highly suspect that you're putting an jdbc jar file into the enterprise manager directory structure rather than in a folder in a standard location for jar files, in other words something on your java CLASSPATH--which, unfortunately, I have no idea what that would be for Windows OS.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-27 18:04 Jackson Isaac <jacksonisaac2008@gmail.com>
parent: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Jackson Isaac @ 2014-12-27 18:04 UTC (permalink / raw)
To: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>; +Cc: 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 <http://www.jacksonisaac.wordpress.com;
Github/JacksonIsaac <https://github.com/jacksonisaac;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-28 08:27 Harshad Adalkonda <adalkondaharshad@gmail.com>
parent: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
2 siblings, 1 reply; 7+ messages in thread
From: Harshad Adalkonda @ 2014-12-28 08:27 UTC (permalink / raw)
To: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>; +Cc: 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
>
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-28 15:25 Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
parent: Harshad Adalkonda <adalkondaharshad@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Sandeep Gondhalekar @ 2014-12-28 15:25 UTC (permalink / raw)
To: Harshad Adalkonda <adalkondaharshad@gmail.com>; +Cc: pgsql-admin
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@gmail.com> wrote:
> 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
>>
>> 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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
@ 2014-12-29 05:37 Harshad Adalkonda <adalkondaharshad@gmail.com>
parent: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Harshad Adalkonda @ 2014-12-29 05:37 UTC (permalink / raw)
To: Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>; +Cc: pgsql-admin
On Sun, Dec 28, 2014 at 8:55 PM, Sandeep Gondhalekar <
sandeep.gondhalekar1@gmail.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@gmail.com> wrote:
>
>> 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
>>>
>>> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2014-12-29 05:37 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-27 16:29 java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
2014-12-27 17:31 ` Scott Ribe <scott_ribe@elevated-dev.com>
2014-12-27 17:43 ` Scott Ribe <scott_ribe@elevated-dev.com>
2014-12-27 18:04 ` Jackson Isaac <jacksonisaac2008@gmail.com>
2014-12-28 08:27 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
2014-12-28 15:25 ` Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>
2014-12-29 05:37 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox