Hey,

Hibernate version: 3.1.3 and my backend database is Oracle.

I have two database users: dbuser1 and dbuser2. Some tables are created for dbuser1 and some for dbuser2. I always wants to logon to the db server using those user credentials and use their session to insert records into the table.

Now my question is when a session factory is created you can just use one user credentials (defined in hibernate.cfg.xml file). At one time I can only use dbuser1 or dbuser2. Is there a way in hibernate to create jdbc connections for both users so that I can decide which user connection to use based upon tables.

Thanks.

Sanjeev Singal

Perhaps you could create views in the schema of user1 on the tables of user2 and then use user1 only from within your application.

Or you could use two completely separate session factories. But that could possibly raise some transaction issues and problems if you want to mix objects from different sessions.

Regards,
Volker