Cannot import MySQL database in v7, could in v6

Having trouble installing Oxygen? Got a bug to report? Post it all here.
ElectricSheep
Posts: 2
Joined: Sun Jan 29, 2006 12:21 am

Cannot import MySQL database in v7, could in v6

Post by ElectricSheep »

Hi all, I hope you can help me.
I have upgraded to version 7 and now I cannot import mysql databases ( I could with version 6 )
I get an error box which states the following :

org.gjt.mm.mysql.Driver
sorin_ristache
Posts: 4141
Joined: Fri Mar 28, 2003 2:12 pm

Post by sorin_ristache »

Hello,

What is your version of MySQL ? Did you try with the latest version of MySQL driver from the MySQL website copied in the lib subdirectory of the <oXygen/> installation directory as the <oXygen/> User Manual explains ?

Regards,
Sorin
ElectricSheep
Posts: 2
Joined: Sun Jan 29, 2006 12:21 am

Post by ElectricSheep »

Thanks for the reply.

The problem was that the new version of Oxygen picked up the reference to the mysql driver from the previous installation ( 6.2 ) which I had uninstalled. I just edited the driver reference to point to the correct location.

All is working now. :)
sorin_ristache
Posts: 4141
Joined: Fri Mar 28, 2003 2:12 pm

Post by sorin_ristache »

Hello,

The MySQL driver comes with <oXygen/> and the path to [oXygen-install-folder]/lib/mysql.jar is configured in Options -> Preferences -> Database / JDBC Drivers -> MySQL when <oXygen/> is installed. Each version of <oXygen/> uses the mysql.jar included in that version for importing data from a MySQL database. That means the path to [oXygen-install-folder]/lib/mysql.jar set in Preferences -> Database / JDBC Drivers is not imported from the old version, as for the other <oXygen/> preferences. Did you add a new entry in Options -> Preferences -> Database / JDBC Drivers and used it in database import operations ?

Regards,
Sorin
Post Reply