Hi,

I am new in Hibernate. I am using mysql verrsion 5. I wrote one query to fetech records from two tables. Tables are in different databases.

Is it possible in Hibernate

Thanks

Did you take a look at Hibernate Shards?

Summary:
You can't always put all your relational data in a single relational database. Sometimes you simply have too much data. Sometimes you have a distributed deployment architecture. Sometimes the lawyers say "no" (or more likely, "NOOO!"). Whatever your reasons, talking to multiple relational databases inevitably complicates the development of your application. Hibernate Shards is a framework that is designed to encapsulate and minimize this complexity by adding support for horizontal partitioning to Hibernate Core.

Shards is usefull if you 're looking for horizontal partitioning (for example a Person record is in a different database dependend on where he lives).
That doesn't sound like your use case.

As far as I know, an entitymanager is for only 1 datasource (so 1 database), so you can't do that directly.
You can use different entitymanagers, but you 'll have to name your entitymanger's persistence unit with @PersitentContext(persistentUnitName = ...) but you still won't be able to run a single query over 2 entitymanagers.

Hi Friends,

Thanks for your valuable advice.

I need another clarification.

can I use MySQL INET_NTOA() function in Hibernate

Thanks

Hi Friends,

any one give me the details about registerFunction()

Thanks