Joined: 12 Nov 2007
|Posted: Mon Nov 12, 2007 4:56 pm Post subject: Base connects to MySQL, but loses connection immediately
|Hi all, I recently set up Base to access my MySQL database using the JDBC driver. Everything is installed correctly, I assume, because the database loads properly and I can view my tables.
However, whenever I try to edit a table, I am able to open it for editing, but if I leave it idle for more than 10-30 seconds, I can still edit, but I receive this error upon trying to save:
"Communications link failure.
Last packet sent to the server was X ms ago."
X is an integer anywhere between 0 and 31.
I then must reconnect to the database, but couldn't find a good way to do this. The best way I have found currently is to go into Edit >> Database >> Properties and click Test Connection, which always pops up "The Connection was established successfully."
If I hurry and try to get one small edit in before it disconnects, I can do so, but any more than that and I can't save anything.
Is there something that I'm missing? Thanks in advance!