Hi,

I have a problem for which I can not find a sollution in Google / books.

I have an informix server which holds 2 databases.
Some entities I want to select from one database and others from the second database. There is also relation between the tables.
Within informix SQL it is possible to

select * from table1,otherdatabase:table2 where table1.name=table2.name

How can this be done in hibernate, using annotations (I am working with Seam) with one entitymanager?

One possibilty is to use the following method:
@Entity
@Table(name="otherdatabase:table")
public class Table {


but now I can not use Hibernate validator....