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
