We want to use Hibrenate as our persistence layer but we have a big question since we're all new to Hibernate.
We will have a web application where users will be identified so their access to data (oracle database) will vary according to permissions. In other words, we would like to use Hibernate using individual access so the vpd can identify who is using the DB and which rows can be accessed.

Can we use Hibernate? if so, what's the best practice for this? Help is much appreciated!

Thanks a lot!

Oracle VPDs should be transparent to Hibernate. Hibernate3 has a similar feature: data filters. This enables the same functionality cross-plattform in the Java middle tier.

Thanks for your response.

Just to clarify, when Hibernate opens a session, this interacts with the Oracle database on a per-user basis?
For example, if we use the session in this way, is Oracle aware of the user? how can this be set up then?

Session session =sessionFactory.openSession(); Transaction tx =session.beginTransaction();
AuctionItem item = (AuctionItem)session.get(ActionItem.class,itemId);
bid.setItem(item); item.getBids().add(bid);
tx.commit(); session.close();

There are some ways to do this. You can implement your own ConnectionProvider, TransactionFactory, etc. I've heard of others using Oracle VPDs with Hibernate, but never tried it myself.

HI

We are also looking into using Hibernate alongside ORACLE VPD and would like to know of anyone who has done this.

Can anyone point us in the right direction please.


cheers Paul

Typically a web app has one connection to the database and all the users of a web app are seen by the database as one user. Not want you want.

However, there is no rule that web apps have only one connection. You could set up individual connections, one for each user, with that user's login/password...and in your code, whenever you connect, you connect using that user's connection -- then the database knows each individual.

There may be better ways of doing this...but this should work.

Lee

We are currently using a connection pool and are trying to obtain a connection from the pool and associate it with a specific user using

conn = hibernateSession.connection();

(oracleConnection)conn.setClientIdentifier(clientId).

Still early days yet, but we are trying to find reference material on how to do this using SPring Hibernate and Oracle 9i VPD.

Paul

Just found this old topic in the archives. Have we found any documentation or Howto's yet?


thanks,
Sanjay

Hello Paul,

Just wonder if you have let Oracle VPD work with Hibernate.
I have the same problem you had-try to use Oracle VPD with hibernate.

Cheers

Charles

Where is you documentation for data filters????? I cannot find it anywhere?

Thanks,
Angela