Thank Ben for your answer,
I understand. It is probably more on the Hibernate side that the issue of
schema must be resolved.
But in the JBoss Cache side, would it be possible to do this next scenario.
In a way it doesn't matter that the data to cache comes from a database, I just
want to know if it is possible to control the PersistenceStore at the data
level : to add new relationship between object after putting it in the data
store.
In the other side, the use of a dataBase (BdcjeCacheLoader) as the persistence
store points out that it could be possible in a near future to add relationship
between cached object.
Here's an example to illustrate the problem:
1- My application wants some data: ObjectTypeA and a Collection of ObjectTypeB
linked each other to a Parent-Child relationship.
ObjectTypeA and ObjectTypeB come from Data_BaseA. The application check the
JBossCache (via the CacheLoader) to see if the data is there, if not it loaded
the data from Data_BaseA before and put the Structure (One ObjectTypeA and
many ObjectTypeB) in the persistence store.
2- The application needs now to get the ObjectTypeB plus a collection of
ObjectTypeC that is linked to ObjectTypeB in a Parent-Child relationship. But
this data is in another database: Data_BaseB. I check if the ObjectTypeB is in
the cache, lets say I found it (because it load it from Data_BaseA). It then
check if the collection of ObjectTypeC is in the cache. It doesn't find it. So
it load it from Data_BaseB. Then it update the ObjectTypeB in the cache to
linked it to a Collection of added ObjectTypeC.
3- It means that future access of ObjectTypeA-ObjectTypeB-ObjectTypeC will be
done in the persistence store without accessing any database, and without any
probleme of multiple database inner join.
Using Hibernate, I cannot use the same cache for 2 database access. But if by
some way we can add an object in the persitence store, and add new relationship
between them, Hibernate could maybe use the same cache and the same schema to
access 2 databases.
I know it sound strange...
Thanks,
Etienne
Montreal
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=3869958#3869958
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3869958
---
SF email is sponsored by - The IT Product Guide
Read honest candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click
___
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development