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=bb&op=viewtopic&p=3869958#3869958 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=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=6595&alloc_id=14396&op=click _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
