0 Replies Latest reply on Dec 12, 2006 7:01 AM by Tim WIlkins

    Mapping an entity to partitioned tables

    Tim WIlkins Newbie

      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