JavaZone

Oracle VPD or Virtual Private Database is a Oracle Database feature that provides data access control features for the database. You cannot directly access the VPD data using the persistence managers like Hibernate or JPA. There's an option of using Oracle Toplink, but it is not a free for commercial use. The following "work-around" allows you to use Oracle VPD with Hibernate API.

You need to create an implementation of the ConnectionProvider which will override the default connection provider. package org.javazone.hibernate; import org.hibernate.connection.DriverManagerConnectionProvider; public class MyConnectionProvider extends DriverManagerConnectionProvider { @Override /** * Execute the VPD specific Stored Procedure. */ public Connection getConnection() throws SQLException { Connection conn = super.getConnection(); //Put your VPD specific logic here. return conn; } } Next step is to make sure that MyConnectionProvider is used by hibernate. You can edit the hibernate.cfg.xml as shown below: org.javazone.hibernate.MyConnectionProvider

This property will make the Hibernate invoke the MyConnectionProvider whenever a new connection is requested by the application.