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