Can't Connect to the Server ??

[jackky]

Hi,
I'm using MySQL5 along with Hibernate to manage my java persistance. I'm running into a snag where after my server is idle over night hibernate throws a generic JDBC exception saying it can't connect to the server. I have a feeling this has to do with the Interactive Timeout setting found in MySqlAdministrator->Startup Variables -> networking, however I can not change that setting because its disabled.

I don't know much about configuring mysql but I tried adding adding a interactive-timeout=myvalue in my.ini but when I restart the service the originial setting of 28800 is still there.

Does anyone know what I need to do to change this setting? Thanks in Advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --