Help!!!

[James WG Murphy]

I am currently in a Distributed Systems Implementation class. My group has created a project, which is a food ordering system. It is coded in Java and uses Microsoft Access to make tables for the users, orders, and items. In this class, we are required to connect our program to two servers, one primary and another back-up. Our professor expects the back-up server to be readily available on another computer if the primary server fails on the first computer. Can anyone explain to me how I would link my java coded proram with access to two servers? Thanks

[_Damian S_]

Open a connection to the primary server and test it. If it fails, open the connection to the backup server.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

[David Mujica]

I'm not a Java guy, but I believe the basic approach is something like this: 1) In all of your data access methods, you will need to open 2 connections to the databases; primary and secondary. 2) During your inserts/updates/deletes you will need to make it in both databases. 3) After attempting to make your connection to your primary database, if it fails, you should set some global flag indicating to all of your other database methods should reference the secondary database. If you really want to be fancy, you could implement a round-robin access method for your primary and secondary databases to provide a load balance between them. Extra brownie points ! Good luck.