MySQL Bugs: #29141: ojdbc14.jar problem with MySQL Migration Toolkit

Bug #29141	ojdbc14.jar problem with MySQL Migration Toolkit
Submitted:	15 Jun 2007 15:14	Modified:	18 Jun 2007 18:05
Reporter:	Weidong Jiang	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	v1.1.12	OS:	Windows (Server 2003)
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I tried to use MySQL Migration Toolkit for migrating from an Oracle database, but I was stopped by the driver problem. I downloaded the ojdbc14.zip from the Oracle site, unzipped it, and jar the driver classes togother to ojdbc14.jar. Migration Toolkit took it and then exited with the message that I need to restart the application. I noticed that ojdbc14.jar then appeared under C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib. After I restarted the Migration Toolkit and arrived at that page, the red phrase "Driver not attached" still showed up. I tried "Locate Driver on Harddisk" again. This time a pop-up window showed up and it said

Cannot create file "C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib/ojdbc14.jar". The process cannot access the file beause it is being used by another process.

I did not see any other processes using that jar file. What is wrong here? Please help me figure this out.

Thanks!

How to repeat:
I tried to use MySQL Migration Toolkit for migrating from an Oracle database, but I was stopped by the driver problem. I downloaded the ojdbc14.zip from the Oracle site, unzipped it, and jar the driver classes togother to ojdbc14.jar. Migration Toolkit took it and then exited with the message that I need to restart the application. I noticed that ojdbc14.jar then appeared under C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib. After I restarted the Migration Toolkit and arrived at that page, the red phrase "Driver not attached" still showed up. I tried "Locate Driver on Harddisk" again. This time a pop-up window showed up and it said

Cannot create file "C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib/ojdbc14.jar". The process cannot access the file beause it is being used by another process.

Thank you for a problem report. What is the size of your ojdbc14.jar file? Have you tried to restart your entire Windows system? Do you have any antivirus software installed on that system?

What I downloaded from the Oracle site was actually ojdbc14.zip.  The zip file has lots of stuff but a jar file.  At the top level, it has META-INF/ and oracle/.  Under the directory oracle/ are 7 subdirectories and jdbc/ is one of those.  There are more stuff under jdbc/ but I made the jar file ojdbc14.jar out of jdbc/driver/.  The file size of the jar file is 161KB.

I haven't restarted the whole Windows system yet.  Will try that.

Since you asked me the file size, I this time put all the stuff I downloaded from the Oracle website into the jar file ojdbc14.jar.  The file size now is 1.13MB.  The problem has now been solved!

Thanks!

Issue is closed because the problem is solved with proper JDBC driver installation.