[Jboss-dev-forums] [Design of Persistence on JBoss] - Entity - how dynamically change mapped table database schema

[kmrol <do-...@jb...>]

I have an Oracle database with multiplies oracle schemas. Every oracle schema represent a project. All projects contain tables with same structure but have different data. 
Now we're using ejb2.1 bmp entity beans to represent a data.
every finder method have a "project" parameter to modify sql:
"select ... from " +project+".table ..."

Could anyone tell me how to achive the same result using CMP EJB3?
That is how to dynamically change database schema while calling find() and other methods...

Thanx!

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954666#3954666

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954666