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 [[email protected]] 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 >
