I am using mysql version 4 and java clients written as a windows desktop application using ConnectorJ. The server hardware is a Windows XP machine with service pack 2 running as a virtual server on a windows platform. There are a maximum of 10 concurrent users from the client XP platforms and versions of my program have run pretty well for a couple of years in a similar configuration.
On my current project the charts and reports that I produce keep crashing due to losing connection to the mysql server.
I use auto reconnect and have upped the number of tcp/ip connections on both the virtual server and the client pc. This seems to have helped but problems still arise.
What kind of issues can create this kind of problem? and what are the possible solutions?
Any advice would be greatly appreciated
Regards
Bernard
On my current project the charts and reports that I produce keep crashing due to losing connection to the mysql server.
I use auto reconnect and have upped the number of tcp/ip connections on both the virtual server and the client pc. This seems to have helped but problems still arise.
What kind of issues can create this kind of problem? and what are the possible solutions?
Any advice would be greatly appreciated
Regards
Bernard
