Great news about the clustering with jdbc stores. Since I'm having db2 hanging problems configuring multiple stores in the Domain.xml I was beginning to think that the db2 jdbc store hadn't been used in a serious fashion and that I was going to be trail blazing. But it has been so that's good. My problem is probably configuration related somehow.
Do you have any suggestions as to why the jdbc store isn't working in a multi-store configuration. Ie. as noted in an email last night titled "DB2 server not responding after short time..." I carried this problem over into a discussion Oliver and I were having previously about a similar problem I had seen with db2 hanging in my first use of the new db2 schema in the 2.1 beta. That problem went away for no clear reason but now that I'm trying to configure multiple stores it is back. I see the db2 server hang in the early stages of trying to start the "/files_2" subjectnode. "/files" finishes its configuration stage but on the next read to the db its hanging the db2 server and I can't run any local commands to the server until I stop my slide process. Interestingly, although its created all of the objects and uris for the /files, /users and /actions objects in the db they haven't been created in the filesystem at that time. So my configuration is Domain.xml is 3 stores mounted on / (/files?), /files_2 and /files_secondCollection. I got this configuration from another list member who had said that this is needed to run the testsuite. It must use the additional stores in some test cases. I use a jdbc nodestore for all child stores except the content store. I've tried to configure the same nodestore (a jdbc store) for all three but am seeing this hang problem. I then tried configuring individual dbs for each nodestore and am still seeing the same problem. So I'm trying to determine what the right way to configure a jdbc nodestore is to share it across multiple store definitions. BTW, what "isolation" level should I be using? I was using "READ_COMMITTED" at first and also tried "SEIRALIZED" with no affect on the hang. Thanks, Warwick -----Original Message----- From: James Mason [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:33 AM To: Slide Users Mailing List Subject: Re: Multilple jdbcstores in domain.xml Warwick, I'm not sure what you mean by a multi-threaded environment. As for clustering, all of my development and testing so far has been done with a jdbc store. I haven't had a chance yet to do extensive testing, but it does work. -James Warwick Burrows wrote: > Hi James, > > Other than for a multi-store configuration: Do you have the jdbc store > working in a multi-threaded environment? Do you have it working in a > clustered environment? I'm targeting both these and wanted to get an > idea what I'm in for... :-) > > Warwick > > > > -----Original Message----- > From: Jacob Lund [mailto:[EMAIL PROTECTED] > Sent: Monday, September 06, 2004 4:21 AM > To: Slide Users Mailing List > Subject: Re: Multilple jdbcstores in domain.xml > > > 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] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
