True. Those JBoss errors do sound related don't they. But no I haven't created a bugzilla bug for this problem.
Warwick > -----Original Message----- > From: Miguel Figueiredo [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 16, 2004 4:07 AM > To: 'Slide Users Mailing List' > Subject: RE: JDBC stores > > > > Thanks Warwick, > > That enlightened me. Your first approach is exactly what > happened with me. Maybe we're dealing with a bug here: have > you created it at bugzilla? > > The second approach errors might be related with JBoss > warnings some folks like Ritu warned us about: > WARN [WrappedConnection] Closing a > statement you > left open, please do your own housekeeping > > Miguel > ____________________ > > 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] > > > --------------------------------------------------------------------- > 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]
