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