Shards and Datasource

ju · **Joined:** Thu Sep 02, 2004 4:54 am **Posts:** 24

Hi all,

I was wondering if it was possible to configure Hibernate Shards in a Application Server (let's say JBossAS) as a Datasource ?
I didn't find any clue in the forum or in the documentation.

Thanks

Regards

sanne.grinovero · **Posted:** Fri Sep 03, 2010 3:04 am

Hello,
sorry but Hibernate Shards does not implement the Datasource interface, so you can't expose it like that

ju · **Joined:** Thu Sep 02, 2004 4:54 am **Posts:** 24

Right that is what I thought.

Is this supposed to be in a roadmap or do you think about there is a way the DataSouce interface may be implemented via Shards?

thanks anyway

sanne.grinovero · **Posted:** Fri Sep 03, 2010 3:33 am

no that's not the mission of Shards; I think you might use this: http://jboss.org/teiid

ju · **Joined:** Thu Sep 02, 2004 4:54 am **Posts:** 24

yeah, thanks, this seems to answer to the need I have.

ju · **Joined:** Thu Sep 02, 2004 4:54 am **Posts:** 24

In facts, I was a bit too much enthusiastic about teiid project. The thing is that I do have a some sort of sharded databases with same data structure.
Teiid lacks the shard possibility (or maybe I have missed it). It raises me a ambiguous table name error when using 2 sharded database.

As I understand it, for the moment, I have to use hibernate without JPA to use shards.

I do not understand why that's not the mission of Shards to be exposed as a Datasource since it has a lot of already needed functionalities. Why not a ShardedEntityManager?

sanne.grinovero · **Posted:** Fri Sep 03, 2010 8:40 am

Quote:

Why not a ShardedEntityManager?

I think that if you want to use advanced features, you're going to stick with Hibernate anyway (instead of JPA, especially if it's about JPA1)
But I don't think anybody would oppose that, just that nobody made it. feel free to propose a patch!

I'm not sure about a thing: you where asking about a Datasource, but now you appear to need JPA?

For questions about Teiid & sharding, please ask them on the Teiid forum.

karbo · **Posted:** Fri Sep 03, 2010 8:56 am

Hi, it seems data source routing may be more of a solution for you. Have a look at the following blog post - it may have something of interest for you: http://blog.springsource.com/2007/01/23 ... e-routing/

ju · **Joined:** Thu Sep 02, 2004 4:54 am **Posts:** 24

thanks karko, I have been through this too and it doesn't suit me.

In fact, I was speaking about Datasource and EntitManager because I need to use EJB 3.0 persistence in the JBossAS and I would like to avoid using Spring inside Jboss. And I didn't find a way to create a routing datasource like your example showed with JCA and the JbossAS.

I will ask the teiid forum for information thanks. this projet looks a little bit more up to date than hibernate shards (sorry about that).