I think you have the same problems as I had.
I was able to configure several different store (jdbc) without a problem, but when I tried to create the collections in domain.xml then slide hang during startup.
I was able to add one store at a time if I only added one collection (objectnode) at a time. That meant add one object node. Start/stop the server and the add the next.
I have not looked deeper into this problem yet and I have not done any testing with the changes applied to slide during the last couple of month.
/jacob
----- Original Message ----- From: "Warwick Burrows" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 04, 2004 1:54 AM
Subject: Multilple jdbcstores in domain.xml
Hi,
I'm trying to configure Slide to run the testsuite but want to use jdbc
stores for all stores but the content. I've created two additional store
definitions tx2 and tx3 that are mapped to the scopes "/files_2" and
"/files_secondCollection" respectively. I was given this configuration by
someone who had gotten it working but they had it working with xmldescriptor
nodestores and filesystem sequence stores. But I need to run all metadata
stores as jdbc stores. So within each <store> definition for tx, tx2 and tx3
I've defined a nodestore definition that's a jdbc store and set the other
stores (sequencestore, securitystore, etc, except contentstore) to refer to
it. The jdbc store works fine in a single store configuration of just
"/files". I can start slide and use it just fine. But I've tried a number
of different things to get the jdbc store working in a multiple store/scope
configuration with no success.
At first I tried setting the jdbc store defs to be exactly the same for each
new store. So they were all pointing at the same db2 database. But this just
hung in a sql command while trying to create the "/files_2" uri in the URI
table. So I tried creating three different tables and configuring one for
each but this also doesn't work. The last jdbc store definition in the file
is the one that seems to get used by all of them, including the root store.
It again hung in a DB2 statement (different place this time) and both the
first and second tables were empty and only the third table, that was only
supposed to be for the "tx3" store scoped by "/files_secondCollection",
contained all the data that's normally created at start time for the "/"
scope.
So what's the correct usage of jdbc stores in domain.xml? Are you able to
define more than one? Do you even need to define more than one or should a
single jdbc store be shared for all scopes? How are they supposed to be
configured???
Thanks, Warwick
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
