|
From: gwg <gw...@co...> - 2003-09-30 22:02:52
|
Hi Norman, First of all, I'm sorry to see that you are having problems connecting. A lot of other people (including me) have had the same kind of problems. Hope you get it working soon. The exception is saying that it cannot find the JDBC Driver for MySQL, and the name of the driver says that you are trying to use the mmMySQL driver from gjt.org. The default driver for MySQL is the MMMySQL driver, which had some kind of product-line change last year (see http://mmmysql.sourceforge.net/). I don't know the status of that work, but you may want to use a newer driver, which has a different name (see http://www.mysql.com/downloads/api-jdbc.html). However, if you already have the MMMySQL driver, you should be able to use that one. The thing is, the .jar or .zip file containing that driver needs to be included in SQuirreL class search path. This is done in the "drivers" screen. Click on MySQL in the Drivers screen and check the "additional paths" (may be a different label in the tab - I can't get to squirrel at the moment so I'm doing this from memory). Check that the file containing the driver is listed in that window. If not, add it there and try connecting again. If the file is listed there, try doing a "jar -tf <filename>" and verify that "org/jgt.mm.mysql.Driver" is actually contained in that file. If you decide to use a different driver, then besides setting the class path to point to it, you will also need to change the driver name and the connection URL, both of which are in the Alias screen. I am assuming that you already have an alias set up to use the MySQL driver for your specific DB, right? Hope this helps. Email if you have other questions. Glenn Norman wrote: > Hi, > I am now trying to use Squirrel to connect to a mySql database and > get the following error : > > Java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver > at java.net.URLClassLoader$1.run(URLClassLoader.java:199) > at java.security.AccessController.doPrivileged(Native > Method) > at > java.net.URLClassLoader.findClass(URLClassLoader.java:187) > at > net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113) > at java.lang.ClassLoader.loadClass(ClassLoader.java:289) > at java.lang.ClassLoader.loadClass(ClassLoader.java:235) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:96) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:112) > at > net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:345) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65) > at java.lang.Thread.run(Thread.java:534) > > Any idea what this means please? > > As an ordinary user I can connect form the command line so I > assume it is not permissions or password problems. > > tia, > Norm > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
