Thanks Chris - I think you nailed my login error with the mySQL 5 connection being terminated. I have one question on this problem and your work around.
ofBiz caches n # of connections and if there are lite periods of time (i.e. 1am - 9am) the insert/delete scheduled task is only going to refresh one of the connections. The remaining connections will get stale and disconnected by mySQL. Over time, the # of active connections will dewindle to just a couple. The system will appear to be working but will be limping along on just a few connections, sort of like a 8 cylinder engine running on 2 cylinders but without the pinging and backfiring. It seems to me that the insert/delete work around is just a bandaid and in a production environment that is not being pounded on 24x7 is going to run into the dwindling connection pool issue. To fix this problem, I think that the connection pool manager might need a thread that just cycles throught the connections and just reconnects them whenever they fail. I haven't confirmed this but would imaging that ofBiz would need to be restarted if I were to recycle mySQL since all the connections in the pool would go stale. Am I off on my assumption here? As for the svn server, is there an easy way to switch from one svn server to the other? I've made numerous changes to the code, some that will be submitted to the project and I don't want to loose those changes. Thanks again. John
