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)
I'm going to let the system run overnight in an idle state and see if the connections come back tomorrow morning.
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 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.
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 Richard Zeng wrote:
Hi Claudio, Thank you for your reply. I am pretty sure add "autoReconnect=true" will solve losing connection problem. But for the problem which Tomcat can not restart, I got no luck. BTW, I am using Magnolia 2.1.5 with Tomcat 5.5.16, MySQL 4.1.21. Is it because I am using Magnolia 2.1.5, not Magnolia 3? I have tried mysql-connector-java-3.1.12-bin.jar, mysql-connector-java-3.1.13-bin.jar, mysql-connector-java-5.0.3-bin.jar, no one works if restart Tomcat. It seems to try to get information from repository but can't. The log looks like: INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init virtualMap INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init i18n INFO info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Config : loading i18n configuration - i18n ERROR info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Config : Failed to load i18n configuration - i18n ERROR info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- server javax.jcr.PathNotFoundException: server at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2369) at info.magnolia.cms.core.Content.<init>(Content.java:110)at info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java:259) at info.magnolia.cms.i18n.MessagesManager.load(MessagesManager.java:130) at info.magnolia.cms.i18n.MessagesManager.init(MessagesManager.java:116) at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:137) at info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:89) at info.magnolia.cms.servlets.Initializer.contextInitialized(Initializer.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) INFO info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Registering event listener for i18n INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init secureURI INFO info.magnolia.cms.beans.config.Server 29.08.2006 14:02:12 -- Config : loading Server ERROR info.magnolia.cms.beans.config.Server 29.08.2006 14:02:12 -- Config : Failed to load Server config: server javax.jcr.PathNotFoundException: server at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2369) at info.magnolia.cms.core.Content.<init>(Content.java:110)at info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java:259)at info.magnolia.cms.beans.config.Server.load(Server.java:78) at info.magnolia.cms.beans.config.Server.init(Server.java:64)at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:142) at info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:89) at info.magnolia.cms.servlets.Initializer.contextInitialized(Initializer.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- An error occurred during initialization, incomplete configuration found? Cheers, Richard ([EMAIL PROTECTED]) ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
