[jboss-user] [EJB 3.0] - Mapping an entity to partitioned tables

Hello, I'm designing a J2EE application to interface a legacy app that uses partitioned tables on its database backend. For instance 'tblBall_1', 'tblBall_2', etc...... In design terms the entity 'Ball' is a single entity which I want to represent as such in my class model. Is there anyway to achieve this with EJB 3? Or are there any workarounds that others have used? The only thing I can think of is to create a view to aggregate the tables together but I suspect this may run like a dog in production. I found this post that seemed related to my question: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=76591 but redesigning the database is not an option for me. Any comments or suggestions would be greatly appreciated! Tim View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3993042#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...