[kepler-users] trouble connecting to mysql with Open Database Connection actor
David LeBauer
dlebauer at illinois.edu
Tue Oct 20 13:41:20 PDT 2009
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)
--
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://lists.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20091020/21fa97ae/attachment.html>
-------------- next part --------------
1. this is the url that I am using jdbc:mysql://localhost:3306/testDB
2. 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)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opendatabase.xml
Type: text/xml
Size: 27948 bytes
Desc: not available
URL: <http://lists.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20091020/21fa97ae/attachment.xml>
More information about the Kepler-users
mailing list