To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41239
------- Additional comments from [EMAIL PROTECTED] Wed Mar 16 15:27:39 -0800 2005 ------- I have the same problem: Remote MySQL database (v 4.0.22-standard) connected via MySQL/JDBC (using latest version v3.1.7) component in Base Problem exhibited in both 1.9.79 and 1.9.84 MySQL server is on a shared linux host OOo is installed on WinXP pro sp2 If I wait for very long the error occurs. I've tried enabling the connection pooling, and the connection seems to 'keep alive' for the duration of the pool, but after that time, I get the error mentioned by osavill when I try to save any changes. When querying for active users in the database (via the MySQL administrator app) I can see a connection from the user I'm using to connect to the database from within Base. The user has a status of "sleep", with how long the user has been in that status. Because of this I think that the connection is still around. Maybe OOo is 'forgetting' the connection? Does it ignore the connection once it has left the 'pool'? If we start connecting several times, we will be leaving a host of open connections that will either just sit there or be terminated by MySQL after whatever duration the database has set for sleeping connections. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
