[kepler-users] database actor

[Madhusudan Gujral]

Hi Corinna,

  Thank you for you feedback. You are right, 'Database Query' actor will not do update. Sorry for this inconvenience, there is a 'Database Writer' actor, which will do updates. Though, I have not tried it myself. If Ptolemy actors are working fine in your workflow then you are set.

--Madhu
________________________________________
From: Corinna Gries [cgries at wisc.edu]
Sent: Thursday, June 10, 2010 10:40 AM
To: Madhusudan Gujral
Cc: Kepler User
Subject: Re: [kepler-users] database actor

HI Madhu,

thanks for the example. But if I am not mistaken the 'database query'
actor only allows select queries. When I try to run an update query it
tells me that it can't change data in the database. But the ptolomy
actors Christopher pointed out are working well for what I want to do.

thanks
Corinna

Madhusudan Gujral wrote:
> Hi Coriana,
>
>  Srure, there are 'Open Database Connection" and "Database Query" actors. I am appending a sample workflow from demos folder. Please have a look at it. Let me know if you need any help.
>
> Thanks
> --Madhu
> ________________________________________
> From: kepler-users-bounces at kepler-project.org [kepler-users-bounces at kepler-project.org] On Behalf Of Corinna Gries [cgries at wisc.edu]
> Sent: Thursday, June 10, 2010 7:25 AM
> To: Kepler User
> Subject: [kepler-users] database actor
>
> Hi,
>
> is there, or does anyone have, a database actor that would let me run
> any type of query, i.e. update, maybe even create and drop, not only
> select and insert?
>
> thanks
> Corinna
> _______________________________________________
> Kepler-users mailing list
> Kepler-users at kepler-project.org
> http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users
>