"ganshre", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements. Thanks.
There could be other better ways to solve this. But this is what I would do if i were in to solve your case. OPTION 1: If security is not an issue. I would share the System1's DB file on a network and point the client's DB connection to the DB using the UNC (network path). OPTION 2: If I want to have a more secured DB access (not to mention more elegant). I will make use of RMI. Create an RMI application server in System1 which "hosts" connection to the DB. And then have the clients connect to this RMI server. The clients would pass query, delete, update and insert SQL commands to the RMI server. The RMI server would then execute this commands on the DB in behalf of the client.