On Mar 11, 2010, at 16:26, Rico Jansen wrote:
> > On Thu, 2010-03-11 at 15:58 +0100, Grégory Joseph wrote: > >> Actually, using DataSources is support in Jackrabbit since at least JR 1.6 - >> the information that was on this page referred to a 3rd party PM which was >> quite outdated; i just removed it. >> This should tell you how to configure it: >> http://wiki.apache.org/jackrabbit/UsingJNDIDataSource > > Thats nice, I'll see if I can get this arranged with our > hostingprovider. Typical that this doesn't show up on > searches, but only the old stuff does. Yeah - I'll usually find a not-so-related on the Jackrabbit Wiki, then do a search from there ;) > >> As for the log messages, they're admittedly worrying, but if you look at the >> source of ConnectionRecoveryManager, you'll see that it's "normal". What >> happens there is that a query or statement gets executed, fails because the >> connection was lost (which is normal, your connection times out after a >> while), the connection is refetched by ConnRecMan, and the query gets >> reexecuted. This can happen up to 3 times until JackRabbit chokes for real. >> Meantime, for every try, the errors are logged, and since MySQL's exception >> messages tend to be big, this gets scary. > > It is good to know it is just complaining and not a > serious error. I have just seen the error of the > failing connection not errors caused by the connection failure. >> Now my question: do you get these when using a DataSource or a direct >> connection ? If a DS, how and where did you configure the DS? If a direct >> connection, then there's no worry to be had if those are the only exceptions >> you get - after the 3 trials, they get thrown up for real (and not just >> logged), and at that point, you'd probably see much more exceptions in your >> logs. > > Direct connection, getting just the connection erros, usually > after a period of inactivity. Ok, makes perfect sense, then. (I'm not sure why JR logs this as an error, it's really just a warning) * do you use the autoReconnect parameter in your jdbc url ? (you shouldn't, and given the above, I suppose you don't, so it's all good) Also see my comment at http://wiki.magnolia-cms.com/display/WIKI/Changing+Jackrabbit+PersistenceManager?focusedCommentId=39256116&#comment-39256116 - you might have to check which DBCP version you're using. > Thanks, with this info I can setup a test with a > datasource and see if I can get it implemented at our host. > Might be a bit tight, the website launch is Monday. Good luck ! Let us know how it goes ! -g > > -- > Rico Jansen ([email protected]) > "You call it untidy, I call it LRU ordered" -- Daniel Barlow > > > > ---------------------------------------------------------------- > For list details see > http://www.magnolia-cms.com/home/community/mailing-lists.html > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
