Is it possible to use shards with EntityManager / JPA

farrukh_najmi · **Joined:** Thu Sep 14, 2006 12:08 pm **Posts:** 19

I need to scale my database using horizontal table partitioning. Does it make sense to use Shards within the context of a single database as means to do horizontal table partitioning? Also does shards work with JPA / entitymanager yet. The following suggests not:

Quote:

Many of you will quickly realize that the configuration mechanism we've provided won't work if you're configuring your SessionFactory via JPA. It's true. We expect this deficiency to be addressed shortly. (source)

How are other folks dealing with horizontal table partitioning when using hibernate entity manager?

hardy.ferentschik · **Posted:** Wed Apr 20, 2011 5:33 am

Hi,

not sure about Shards. There was hardly any development on Shards for quite some time now. Maybe you should look more into a multi tenancy solution - http://relation.to/Bloggers/MultitenancyInHibernate ?

--Hardy

sanne.grinovero · **Posted:** Wed Apr 20, 2011 6:50 am

about multitenancy and Hibernate 4, there's a webinar starting very soon:
http://www.jboss.org/webinars