<pre>Hello,<br><br>I am interested in connecting to a mysql database both on my own computer (Ubuntu) and on a remote server (Linux BSD).<br> <br>Following the user manual, I enter the following in the actor's url 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 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: 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: 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></pre><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>