Hi.
I did restart tomcat after the initial bootstrap and all came back normally.
Let me clarify the last part a little. I duplicated
jackrabbit-mysql-[no]search.xml for each repository for a total of eight
files to the effect of jackrabbit-mysql-website-search.xml,
jackrabbit-mysql-website-nosearch.xml,
jackrabbit-mysql-config-search.xml, etc., ...
In each, I changed the schemaObjectPrefix attribute of the
PersistenceManager element to prevent table collisions between
repositories. In the case of website, it became "web_${wsp.name}_" for
the workspace persistence manager and "web_version_" for the versioning
persistence manager.
The end result is there approximately 32 tables in the database -- 8 for
each repository (website, config, users, userroles).
I suppose if you left the derby database for versioning, there would be
only 16 tables in the database.
--David
Richard Zeng wrote:
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
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
