I have a User schema for single sign on and various other schema for different systems. I want to (without my code changing to deal with it) have the users in X and say an order in Y with the POJO holding a User. I could build this to have the ID for the user and go get it, but I don't want to have to do that. Can a single SessionFactory be setup to access 2 schemas? If not is there another way?

Thanks

Yes, a single SessionFactory can have object/associations that cross schemas. Of course, you may have to deal with permissions, but as long as the database allows access, Hibernate has no problem with multiple schemas.

VERY COOL. How do I tell Hibernate what schema each object is in? My only understanding is that you can setup the connection in the cfg file, and I have always had the schema in the connection string.

You know, if things keep going like this these computer thingys are going to catch on some day.

Thanks

It's an attribute of the <class>, <joined-subclass>, ... tags. There is also a hibernate.default_schema property you can set in your hibernate.properties file.

Can I annotate that? Annotations are where it is at!!!!