- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Thanks for the reply Ed.
This is for an internal project which only uses a MDB file,
which may be updated by Flex or directly through Access itself, and
I'd like any changes made in Access to reflect in Flex fairly
rapidly.
I can to switch to MSSQL Standard or Enterprise if it is 100%
necessary, but I'd like to find a solution involving polling if
possible, as this is a pretty small scale project which will mainly
be used internally, but may also be taken out to customer sites as
a demo and will preferably be easy to set up and run on Tomcat and
nothing else.
So assuming for now I want to do things the hard way and use
polling instead of using change notification:
When I call updateItem, I believe the class I need to pass to
the method will probably be a Map (it's an Object when in Flex,
because I cannot specify a class to use due to an unknown number of
columns in my query). I want to use SQLAssembler to get a fill of
Map objects, then after another preset interval get another fill of
Map objects, compare the two, then use updateItem to tell LCDS
which Map objects have changed.
I imagine one way to get at an SQLAssembler equivalent to the
one used in the client side Flex app would be to write code which
would parse the data-management-config.xml file, then use the
SQLAssembler constructor to make an assembler with identical
settings as the relevant destination, then use the fill method on
that to build the object list.
It seems like I'd be reproducing the effort which already
takes place when the destination is created, so I am looking at
some way to grab the already instantiated SQLAssembler, if such a
method exists.
If that fails or can't be done, I'm considering trying to
extend the SQLAssembler class to perform the property change checks
when updateFill is called, then use this new class in my
destination declaration in the data-management-config.xml file.
I'd really like to get change polling working, just so I know
how it can be done and which point performance issues of this
approach makes it necessary to use a server which supports change
notification.
If you have any more ideas let me know; I'm going to carry on
hammering away anyway and I'll let you know if I manage to solve
this myself.
This is for an internal project which only uses a MDB file,
which may be updated by Flex or directly through Access itself, and
I'd like any changes made in Access to reflect in Flex fairly
rapidly.
I can to switch to MSSQL Standard or Enterprise if it is 100%
necessary, but I'd like to find a solution involving polling if
possible, as this is a pretty small scale project which will mainly
be used internally, but may also be taken out to customer sites as
a demo and will preferably be easy to set up and run on Tomcat and
nothing else.
So assuming for now I want to do things the hard way and use
polling instead of using change notification:
When I call updateItem, I believe the class I need to pass to
the method will probably be a Map (it's an Object when in Flex,
because I cannot specify a class to use due to an unknown number of
columns in my query). I want to use SQLAssembler to get a fill of
Map objects, then after another preset interval get another fill of
Map objects, compare the two, then use updateItem to tell LCDS
which Map objects have changed.
I imagine one way to get at an SQLAssembler equivalent to the
one used in the client side Flex app would be to write code which
would parse the data-management-config.xml file, then use the
SQLAssembler constructor to make an assembler with identical
settings as the relevant destination, then use the fill method on
that to build the object list.
It seems like I'd be reproducing the effort which already
takes place when the destination is created, so I am looking at
some way to grab the already instantiated SQLAssembler, if such a
method exists.
If that fails or can't be done, I'm considering trying to
extend the SQLAssembler class to perform the property change checks
when updateFill is called, then use this new class in my
destination declaration in the data-management-config.xml file.
I'd really like to get change polling working, just so I know
how it can be done and which point performance issues of this
approach makes it necessary to use a server which supports change
notification.
If you have any more ideas let me know; I'm going to carry on
hammering away anyway and I'll let you know if I manage to solve
this myself.
Views
Replies
0 Likes
Total Likes