[kepler-users] trouble connecting to mysql with Open Database Connection actor
David LeBauer
dlebauer at illinois.edu
Wed Oct 21 07:39:36 PDT 2009
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://lists.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20091021/ba452307/attachment.html>
More information about the Kepler-users
mailing list