Re: [Squirrel-sql-users] DB Plugins not loading

[Matthew D. <mda...@ja...>]

Lachlan,

I thought SQuirreL shipped with a MySQL driver... but maybe my memory is
cloudy, perhaps I added my driver manually.

Take a look in SQLDrivers.xml from the .squirrel-sql directory. This
should include the path to the .jar file that you're using after you have
setup the "Extra Class Path" tab. For example, with Oracle I have this
snippet indicating where it should look for the .jar file:

...
        <jarFileNames Indexed="true">
            <Bean
Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper">
                <string>C:\Program Files\SQuirreL SQL
Client\drivers\ojdbc14.jar</string>
            </Bean>
        </jarFileNames>
        <name>Oracle Thin Driver</name>
...

If that doesn't help, send out your SQLDrivers.xml and maybe a mistake
will be obvious to someone.

Regards,
Matt
 

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Lachlan Pollock
Sent: Monday, 27 August, 2007 19:52
To: squ...@li...
Subject: [Squirrel-sql-users] DB Plugins not loading

Hi,

I am having some problems getting the mysql driver to work. I have
selected the mysql.jar file in the additional class path tab, but when I
'list drivers' the list returns is blank and I get the following error...

"Could not find class com.mysql.jdbc.Driver in neither the Java class path
nor the Extra class path of the MySQL Driver driver definition:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver"

I have tried this on windows and solaris. using multiple versions
including the latest snapshot.

Solaris 10:
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03) Java
HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing)
(solaris.sys attached)

Windows XP:
jre1.6.0
(windows.sys attached)

Thanks for your help - I hope I haven't missed anything obvious.

Cheers

Lachlan


--
*************************************************************
Lachlan Pollock		mailto:lac...@un...
Systems Administrator, ArtsIT, Faculty of Arts University of Melbourne,
Victoria 3010, AUSTRALIA
Tel: +61 3 8344 3609    Fax: +61 3 9347 6064
Mobile: 0421 055 492
*************************************************************