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]
