Hi David, Thank you for your reply.
Does that mean on Magnolia 3.0, if we are going to use MySQL, we will have the same problems (failure of restart and lost connection)? Because I think we use the same SimpleDbPersistenceManager. Did you see any difference for different database in term of performance? Cheers, Richard ([EMAIL PROTECTED]) On 8/16/06, David Smith <[email protected]> wrote:
I've been investigating this myself. While I haven't quite tracked down the failure of Magnolia to restart once the database repository has been initialized, I did see why the connection to MySQL is failing. SimpleDbPersistenceManager initializes and opens a number of prepared statements to the database, never shutting them down until the repository itself is shutdown. MySQL terms such connections after about 8 hours and you're left with a site that doesn't work anymore. I haven't looked very closely at the other persistence manager classes. Maybe one of the others is centered around closing connections immediately after a commit or rollback. --David
---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
