Hi Miguel, I tried configuring three separate stores (with scopes "/", "/files_2" and "/files_secondCollection" using jdbc as you have and could not get it working either. I also didn't get much help on how the stores _should_ be configured if you want to get it working so I still don't know what the right way should be. I tried using separate dbs for each store and also tried to use the same db for all three and neither approach worked.
In the case of using separate dbs for each store I got a problem similar to yours in that the db for the last store contained all the information instead of being appropriately split up over the three dbs. In the latter case, sharing the same db, I was getting "hang" problems in the connection to the db while running SQL statements most likely due to the fact that although the root and secondary stores shared the same jdbc config parameters they're not actually sharing the same connection to the db and so the secondary stores may have been trying to connect over a second db connection while another connection was already in progress for that thread. I'm only guessing here though. The only time I can get multiple stores working is if the second and third store are not jdbc stores. Ie. it works with XML file descriptor stores. If you have any luck please let me know. Warwick > -----Original Message----- > From: Miguel Figueiredo [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 15, 2004 2:29 PM > To: 'Slide Users Mailing List' > Subject: JDBC stores > > > > Hello folks, > > I got another weird problem... > I was experimenting with JDBC stores, more explicitly with > the mySql one. In attach I'm sending my domain.xml file. It > is also getting the authentication info from a ldap server, > to witch I configured two JNDIPrincipalStore, each of witch > with a corresponding mySql store for locking and security > purposes: the mySql databases are called slideustore for > users and sliderstore for roles. For content store I've also > created a mySql store, being the mySql database named slidecstore. > > When I start up slide, all goes well, and it also operates > correctly but, and that's the weird problem, all data is > saved in only one store, the sliderstore... slideustore and > slidecstore are empty, when data should be saved in > slidecstore, not sliderstore. Are there any comments? > > Thanks in advance, > Miguel Figueiredo > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
