Hibernate Community • View topic - select across multiple db

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

select across multiple db

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jonas_deer

Post subject: select across multiple db

Posted: Fri Apr 07, 2006 4:52 am

Newbie

Joined: Fri Apr 07, 2006 4:45 am
Posts: 2

hello,

I'm wondering what is the best solution to query and order objects in a db by the criteria of an ID located in an other db.

what's the best method to do that in term of performance ?
any pointer on the topic ?

thanks
jonas

Top

prashantjain

Post subject:

Posted: Fri Apr 07, 2006 4:57 am

Regular

Joined: Wed Mar 08, 2006 2:07 am
Posts: 50
Location: Bangalore

dude ... you are drifting towards Federated Databases ;)

Anyways if you will write your HQL query, you can specify the ID (which you will have to retrieve before hand) just like any other Restriction on a query and retrieve the selected rows

I hope that helped.

Top

jonas_deer

Post subject:

Posted: Fri Apr 07, 2006 5:18 am

Newbie

Joined: Fri Apr 07, 2006 4:45 am
Posts: 2

I was speaking in term of transaction/cache configuration strategy.

Is there any practical solution to make a select across multiple db with a garantee of perf ?

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum