StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POExternal database changes -> Hibernate -> Client
text
Body
copied!<p>An existing external system makes regular (every few seconds) updates to several database tables. We want to build a dashboard type user interface which allows the user to view additional records and important updates in near real-time. The user interface would also allow some transactions which would result in database changes.</p> <p>Our thoughts are to use a stack with Hibernate and Flex (see <a href="http://dl.dropbox.com/u/1431390/overview.jpg" rel="nofollow">http://dl.dropbox.com/u/1431390/overview.jpg</a>) but we are open to using any free/open source technology. There are a few issues we are unsure about should we use our proposed stack:</p> <p>1) How to automatically update the POJOs with database changes? As far as I understand it, there is no way of hibernate knowing about any changes made outside its own session. Therefore, some sort of polling would have to be done to pick up new and changed records. </p> <p>2) We were planning to push the data to datagrids within a flex UI (using BlazeDS or WebORB). This seems to rely on identifying the changes and pushing these as updates down the channel. However, if we use the Hibernate->POJO approach identifying these changes could be fairly complex as we have refreshed the data. Is there a better solution which will push the changes on the fly? I would have thought this was a common requirement but I can't find much information online.</p> <p>Any advice would be gratefully appreciated on either the architecture or the specific issues.</p> <p>Many thanks,</p> <p>Ken</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload