what’s the best practice to config Hibernate-Spring for multiple database relationship?

[Kamila Rutkowski]

We have a main mysql database which all of the applications within our organization need the data within this database. How can I config my java web application to use this database with it's specific database when I use Spring and Hibernate within my application? How can I config JPA annotations for example between CONTRACT table within my database and COUNTRY table within our main database? what's the best practice to do this?

[Cameron Wallace McKenzie]

So, you're querying two separate databases? This is a non-standard problem, I'd say. It's a little outside of the box.

Take a look at Hibernate Shards at hibernate.org. It's a new project, but it deals with mapping to multiple databases.

[Christian Dillinger]

Under Oracle (I think other vendors might have some related features) you could create a database link between those instances and your app does not need to know both systems.