Real Time data grid updates/streaming - Oracle -> Flex using BlazeDS ???

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Real Time data grid updates/streaming - Oracle -> Flex using BlazeDS ???

John Bourke
Folks,

I have an Oracle application which is updating tables.

I want to display these tables in a Flex data grid and update them in
real time as the Oracle tables get updated.

So the question is, how do I get Oracle to pass real time updates to
Java/Tomcat/BlazeDS application to interface to Flex.

Here are some thoughts from lots of Google searching.

1. Java SP with JMS interface to Java/Tomcat/BlazeDS
2. Oracle streams to Java/Tomcat/BlazeDS
3. "Mining" the redo logs for changes (not real time ?)

I also have a issue with synchronization.  I need to be able to load a
table into Flex and then get all subsequent changes.  How do I ensure
that I do not miss a update between the table load and my update
mechanism starting.

Are there any other synchronization issues ?

Thanks

john


Reply | Threaded
Open this post in threaded view
|

RE: Real Time data grid updates/streaming - Oracle -> Flex using BlazeDS ???

Seth Hodgson
Take a look at the Data Management Service in LCDS, as well as the server side DataServiceTransaction class.

http://livedocs.adobe.com/livecycle/8.2/programLC/programmer/lcds/help.html?content=Part_Data_Management_1.html

Best,
Seth

From: [hidden email] [mailto:[hidden email]] On Behalf Of johnpagetbourke
Sent: Wednesday, December 17, 2008 10:16 AM
To: [hidden email]
Subject: [flexcoders] Real Time data grid updates/streaming - Oracle -> Flex using BlazeDS ???

Folks,

I have an Oracle application which is updating tables.

I want to display these tables in a Flex data grid and update them in
real time as the Oracle tables get updated.

So the question is, how do I get Oracle to pass real time updates to
Java/Tomcat/BlazeDS application to interface to Flex.

Here are some thoughts from lots of Google searching.

1. Java SP with JMS interface to Java/Tomcat/BlazeDS
2. Oracle streams to Java/Tomcat/BlazeDS
3. "Mining" the redo logs for changes (not real time ?)

I also have a issue with synchronization. I need to be able to load a
table into Flex and then get all subsequent changes. How do I ensure
that I do not miss a update between the table load and my update
mechanism starting.

Are there any other synchronization issues ?

Thanks

john