Jae, glad to help. I doubt there is a change event support in the jdbc connector, but I may be wrong.
One way you'd be able to notify your fds webapp that a change occurred is to expose an internal facing service (webservice,restful, jms?) to your other app. For example, our searchcoders.com/flex app runs a couple of shell scripts to perform maintenance and email retrieval at periodic intervals. I wanted to keep track of when new messages were downloaded from the group and indexed in a simple flex-based admin console. so, when the batch script finishes dling and indexing stuff it makes a curl request to an internal-facing server running fds, which sends an update event over a transaction, just as i described in my reply. then my admin client, which is already connected to the internal server fds instance, receives a push update. Of course, i could have simply had the shell script send me an email, but, we're testing out how to work and integrate fds and wanted to see this sort of notification strategy in action. /r http://www.searchcoders.com/flex/?dataservicetransaction+php+net jwp2k_uva wrote: > Robert, > > Thanks a million for pointing out DataServiceTransaction ;) This is > awesome. > > I wonder now whether there is a db change event support in MySql/JDBC > connector that allows a java object to call DataServiceTranaction > functions as you described below whenever the database of interest is > changed regardless of who (.NET, PHP, etc.) changed it. > > You've been a great help. Thanks, again. > > - Jae > > > --- In [email protected], "robert_cadena" <[EMAIL PROTECTED]> wrote: >> Hi, >> >> if i understand you correctly you want to tell a flex client that a >> change in a db row occurred, yet the change was not initiated by that >> client and/or you're not in the middle of an assembler operation? For >> example, if some other non-flex related entity changed a db row you >> want to notify the flex client. >> >> If this is the case have a look at the "DataServiceTransaction" class >> in the FDS javadocs. You create a new transaction using that class' >> "begin" static method. Here's some pseudocode: >> >> tx = DataServiceTransaction.begin(); >> tx.updateItem("destination_name", newVersion, prevVersion, changesList); >> tx.commit(); >> >> This bit of code will send an update event to the clients subscribed >> to destination. >> >> Keep in mind you have to be within the same webapp as the FDS. >> >> Hope that helps. >> >> /r >> http://www.searchcoders.com/flex/?dataservicetransaction >> >> >> >> --- In [email protected], "jwp2k_uva" <jwp2k_uva@> wrote: >>> Dear Flexcoders, >>> >>> In a FDS/Hibernate/MySql setup, what happens if a data row is directly >>> updated in the MySql database? Is there a simple way to update the >>> flex application with the updated data row? >>> >>> Thanks a million. >>> > > > > > -- > Flexcoders Mailing List > FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com > Yahoo! Groups Links > > > >
