I would look for an imbedded database that does automatic synching with a central database. I seem to remember sybase having something like that, or pointbase maybe. I think you could specify which tables needed to be synch'd and which direction too, might have been ASA.
Brian On 12/14/05, Roland Giesler <[EMAIL PROTECTED]> wrote: > > I looking for some advice regarding using a disconnected java application > running on Postgres. > > Scenario: A Java web application read/writes a PG database in a > transactional environment. To be more specific, status information about > clients is looked up from some table(s), and a number of lines are then > entered into an order. The items that can be ordered are in another table, > which must also be available offline. Lastly the completed order must of > course also be available offline, for submission later when an internet > connection is available again. > > Now this application should be able to work when disconnected from the > server. Of course the application can be written to create offline copies > of the data in a local file, but basically that would cause some problems, > since it would involve a lot of coding firstly, but also mean that different > code would be required for online and offline operation. > > My question is, is there any technology that would allow this type of > funtionality with Postgres, like some type of caching enjine, or something > else, acting as a sort of mini "middleware" of sorts (to borrow that term) > to do this for me. > > Thanks > > Roland Giesler > > > -- Brian Silberbauer Consultant +27 (0)83 566 2705 skype: brian.silberbauer
