Hi David, Thank you for your reply.
On 8/30/06, David Smith <[email protected]> wrote:
I just tested this config and it's working: Tomcat 5.0.28 (just what I had around on the dev/test box) Magnolia 2.1.5 (downloaded today from the website) MySQL 4.0.20 (again, what I had already on the dev/test box) MySQL Connector-J 5.0.3 (current version from mysql website)
Quite similar to mine, except I am using Tomcat 5.5.16 and MySQL 4.1.21. I don't think that made any difference.
I'm going to let the system run overnight in an idle state and see if the connections come back tomorrow morning.
Did you restart tomcat after first startup? I am sure after add "autoReconnect=true" to MySQL url, the connnection will not break any more. My problem is if I shutdown Tomcat, I can not startup any more.
I suppose I should confess to a few changes I made before the test. They may or may not have impacted the results: 1. Upgraded jackrabbit to 1.0.1 and added slf4j because version 1.0.1 of jackrabbit requires it
I did this as well.
2. Split the jackrabbit-mysql-[no]search.xml files into a set for each repository (jackrabbit-mysql-[repository]-[no]search.xml) 3. Modified repositories.xml so each repository pointed to it's respective jackrabbit....xml file.
No, I didn't do this. Do you mean for different repository, for example, website, userrole, user or config, must have different database?
I did the last two because I had concerns that the repositories would end up being bootstrapped on top of each other in the same set of tables, rendering the whole thing useless. --David
Cheers, Richard ([EMAIL PROTECTED]) ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
