Hibernate version:
3.0
Mapping documents:
Na
Code between sessionFactory.openSession() and session.close():
Na
Full stack trace of any exception that occurs:
Na
Name and version of the database you are using:
Oracle 10 g
The generated SQL (show_sql=true):
Na
Debug level Hibernate log excerpt:
Na

Can hibernate function across multiple schemas using a single SessionFactory? If so how? I think I have to create two SessionFactory objects in order to this ... not sure though.

Thanks for any suggestions/help

As long as the schemas are in the same database, Hibernate has no issue.

you can specify the schema in each mapping file. See section 6.1.2 in the 3.0.5 Documentation.

<hibernate-mapping schema="schameName"....>
..
..
</hibernate-mapping>

This can also be specified at the <class> level and all collection levels.
Do a search on schema= in the docs.

I think you have to create two session factories.

This would also be more ideal because each session factory requires its own configuration file and initialization of a session factory is very expensive so you would want to do it once at applicaiton startup instead of switching one around (if switching one around is even possible, which I don't think it is).

boy was I wrong.

never thought to look if the mapping files could do it

One can specify the schema in the hibernate-mapping element for a class but how do you specify the schema specific password and username? I can only see one place where database username and password can be set and that's in the hibernate.cfg.xml file.

So it seems that hibernate allows you to access different schemas in the same database provided those schemas have the same security access?? Is this correct?

I think so. we need to have diiferent configuration files to do so.