Hi Dan, That worked great! I am using Kepler 1.0, but I had not realized that I needed to copy the driver to the Kepler path.
Thanks you very much for your help. -David On Tue, Oct 20, 2009 at 4:09 PM, Daniel Crawl <crawl at sdsc.edu> wrote: > > Hi David, > > This error occurs when Kepler can't find the mysql jar. > Are you using Kepler 1.0 or 1.x? (Your workflow appears > to have been created using 1.0). > > It looks like the mysql jar is not part of the 1.0 > distribution. You can download it here: > > > http://code.kepler-project.org/code/kepler/trunk/modules/util/lib/jar/dbdrivers/mysql-connector-java-5.1.6-bin.jar > > Move it into $KEPLER/lib/jar/dbdrivers/, restart Kepler, > and this problem should be fixed. > > --dan > > > > David LeBauer wrote: > >> Hello, >> >> I am interested in connecting to a mysql database both on my own >> computer (Ubuntu) and on a remote server (Linux BSD). >> >> Following the user manual, I enter the following in the actor's url >> box: jdbc:mysql://localhost:3306/testDB >> >> Instead of connecting to the database, I get the error pasted below >> >> Can anyone help me properly configure this actor, or are there mysql >> or java settings that I need to change? >> >> Thank you, >> >> David >> >> 1. I am using the url: >> 2. But I get the following error message >> >> fire exception DB connection >> in <Unnamed Object> Open Database Connection >> Because: >> java.labg.ClassNotFoundException: com.mysql.jdbc.Driver >> in <Unnamed Object> Open Database Connection >> Because: >> com.mysql.jdbc Driver >> >> ptolemy.kernel.util.IllegalActionException: fire exception DB connection >> in .<Unnamed Object>.Open Database Connection >> Because: >> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> in .<Unnamed Object>.Open Database Connection >> Because: >> com.mysql.jdbc.Driver >> at org.geon.OpenDBConnection.fire(OpenDBConnection.java:245) >> at ptolemy.actor.AtomicActor.iterate(AtomicActor.java:398) >> at >> ptolemy.actor.sched.StaticSchedulingDirector.fire(StaticSchedulingDirector.java:170) >> at ptolemy.actor.CompositeActor.fire(CompositeActor.java:400) >> at ptolemy.actor.Manager.iterate(Manager.java:688) >> at ptolemy.actor.Manager.execute(Manager.java:332) >> at ptolemy.actor.Manager.run(Manager.java:1071) >> at ptolemy.actor.Manager$3.run(Manager.java:1112) >> Caused by: ptolemy.kernel.util.IllegalActionException: >> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> in .<Unnamed Object>.Open Database Connection >> Because: >> com.mysql.jdbc.Driver >> at org.geon.OpenDBConnection._connect(OpenDBConnection.java:304) >> at org.geon.OpenDBConnection.fire(OpenDBConnection.java:240) >> ... 7 more >> Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> at java.net.URLClassLoader$1.run(URLClassLoader.java:200) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(URLClassLoader.java:188) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) >> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:252) >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) >> at java.lang.Class.forName0(Native Method) >> at java.lang.Class.forName(Class.java:169) >> at org.geon.OpenDBConnection._connect(OpenDBConnection.java:287) >> ... 8 more >> Caused by: ptolemy.kernel.util.IllegalActionException: >> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> in .<Unnamed Object>.Open Database Connection >> Because: >> com.mysql.jdbc.Driver >> at org.geon.OpenDBConnection._connect(OpenDBConnection.java:304) >> at org.geon.OpenDBConnection.fire(OpenDBConnection.java:240) >> at ptolemy.actor.AtomicActor.iterate(AtomicActor.java:398) >> at >> ptolemy.actor.sched.StaticSchedulingDirector.fire(StaticSchedulingDirector.java:170) >> at ptolemy.actor.CompositeActor.fire(CompositeActor.java:400) >> at ptolemy.actor.Manager.iterate(Manager.java:688) >> at ptolemy.actor.Manager.execute(Manager.java:332) >> at ptolemy.actor.Manager.run(Manager.java:1071) >> at ptolemy.actor.Manager$3.run(Manager.java:1112) >> Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> at java.net.URLClassLoader$1.run(URLClassLoader.java:200) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(URLClassLoader.java:188) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) >> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:252) >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) >> at java.lang.Class.forName0(Native Method) >> at java.lang.Class.forName(Class.java:169) >> at org.geon.OpenDBConnection._connect(OpenDBConnection.java:287) >> ... 8 more >> Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >> at java.net.URLClassLoader$1.run(URLClassLoader.java:200) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(URLClassLoader.java:188) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) >> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:252) >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) >> at java.lang.Class.forName0(Native Method) >> at java.lang.Class.forName(Class.java:169) >> at org.geon.OpenDBConnection._connect(OpenDBConnection.java:287) >> at org.geon.OpenDBConnection.fire(OpenDBConnection.java:240) >> at ptolemy.actor.AtomicActor.iterate(AtomicActor.java:398) >> at >> ptolemy.actor.sched.StaticSchedulingDirector.fire(StaticSchedulingDirector.java:170) >> at ptolemy.actor.CompositeActor.fire(CompositeActor.java:400) >> at ptolemy.actor.Manager.iterate(Manager.java:688) >> at ptolemy.actor.Manager.execute(Manager.java:332) >> at ptolemy.actor.Manager.run(Manager.java:1071) >> at ptolemy.actor.Manager$3.run(Manager.java:1112) >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Kepler-users mailing list >> Kepler-users at kepler-project.org >> http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users >> > -- David LeBauer, PhD Institute for Genomic Biology University of Illinois Urbana-Champaign 1206 W. Gregory Drive Urbana, IL 61801 U.S.A. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mercury.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20091021/ba452307/attachment-0001.html>
