[kepler-users] trouble connecting to mysql with Open Database Connection actor

[Daniel Crawl]

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