Robert, Thanks for the design input. I guess there is no helping it if I want MySql database to have heterogeneous accessors. My preliminary search indicates that Oracle my be the only db that supports change event.
By the way, nice work with SearchCoders.com/felx app. It looks awesome. - Jae --- In [email protected], Robert Cadena <[EMAIL PROTECTED]> wrote: > > 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" <robert@> 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 > > > > > > > > >
