[kepler-users] Connect to Oracle Database

[Daniel Crawl]

Hi Muhannad,

It appears that the Oracle JDBC jar was removed from Kepler.

If you copy the jar into core/lib/jar/dbdrivers/, and restart Kepler,
the actor should work correctly.

   --dan



On 11/24/11 6:34 AM, Ali, Muhannad wrote:
> Hi,
>
> I am trying to get data from Oracle Database using the "Database Query" Actor. I am using the "Open Database Connection" Actor to establish a database connection. I am always getting this error message:
>
> "
> ptolemy.kernel.util.IllegalActionException: fire exception DB connection
>    in .DatabaseAccess.Open Database Connection
> Because:
> ptolemy.kernel.util.IllegalActionException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>    in .DatabaseAccess.Open Database Connection
> Because:
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
> 	at org.geon.OpenDBConnection.fire(OpenDBConnection.java:276)
> 	at ptolemy.actor.AtomicActor.iterate(AtomicActor.java:461)
> 	at ptolemy.actor.sched.StaticSchedulingDirector.fire(StaticSchedulingDirector.java:188)
> 	at ptolemy.actor.CompositeActor.fire(CompositeActor.java:459)
> 	at ptolemy.actor.Manager.iterate(Manager.java:749)
> 	at ptolemy.actor.Manager.execute(Manager.java:351)
> 	at ptolemy.actor.Manager.run(Manager.java:1164)
> 	at ptolemy.actor.Manager$3.run(Manager.java:1217)
> ...
> "
>
> Doesn't Kepler come with Oracle Driver? If not, how could I tell Kepler where the driver is?
>
> Thanks in advance!
>
> Regards,
>
> Muhannad
>
> P.S.
> I am working on a Mac OS X.
> _______________________________________________
> Kepler-users mailing list
> Kepler-users at kepler-project.org
> http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users
>