Re: Connection question

On 01/09/10 16:22, Bayless Kirtley wrote:
> I have a two-user point-of-sale application on Windows XP PRO. The DB
> runs
> on the cash register. The second user is a manager's computer. They are
> connected through a wired router which is also connected to an internet
> cable modem. The manager's computer just checks statistics on the DB and
> maintains a connection all the time. The cash register application
> does not
> do any network operations and is not even aware of the network.
> About twice per month, it is necessary to reset the modem and router.
> This,
> of course, loses the manager's connection to the DB. The problem is,
> it also
> seems to break the connection at the cash register. The next time it
> tries to
> record a transaction, it gets the error "Unable to write to the
> backend" or
> something very close to that. The DB itself seems fine as we can
> restart the
> cash register and all is well.
> Anyone have any idea why this happens? We are running PostgreSQL 8.3.1-1
> and the applications are Java 1.6.14.
> Bayless

It would be a good option to replace your entire system. However, if you
don't wish to do that, just simply connect the "manager's pc" and cash
register with a network switch, which is separate from the router. So
when your router restarts, the switch won't do down, so the 2 machines
remain connected.

That is only a work around though, and ultimately you'd want a better
solution

Cheers