[CTJUG Forum] Re: Offline database usage

[Paul Gilowey]

I would go with Renier's suggestion. If you used Hibernate then I guess that you would use the same DAO layer for online/offline PG/HSQL connectivity. You would just have to let hibernate know which SQL dialect to use, PG or HSQL (or whatever else you may use), and naturally which datasource to use.   Paul >>> [EMAIL PROTECTED] 12/14/05 9:59 AM >>> 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 SANTAM Bpk / Ltd Reg. No. 1918/001680/06 Directors: DK Smith (Chairman), SC Gilbert (Chief Executive), S Bray (Company Secretary), JJ Geldenhuys, JG le Roux, Dr NM Magau, AR Martin, Mr EA Moolla, JE Newbury, P de V Rademeyer, GE Rudman, Dr J van Zyl, BP Vundla, (Executive) MJ Reyneke Please note: This email and its content are subject to the disclaimer as displayed at the following link http://www.santam.co.za/disclaimer.htm. Should you not have Web access, send a mail to [EMAIL PROTECTED] and a copy will be emailed to you.