Hi,
I have some DAO's that using SQLQuery for fetching data from database .
I have some application security requirement to filter the return results - this requirements is cross application, not for a single dao .

My dao's model objects are simple pojo's that not mapped by hibernate (not annotated with @Entity)

1. I tried to Implement LoadEventListener , and it seems that on runtime it execute just for @Entity objects bound to the session , but not for objects that not mapped by hibernate and using SQLQuery

2 .I also thought of using Interceptor but I dont sure there is a way to filter result return from database , I found this post on the same issue - not answered


Is there is a way to dynamically change SqlQuery by adding a "where" / or another condition ? / Pre executing changing / manipulating the sql string result that will be generated by hibernate ?

Is there is a way to filter results by Hibernate Interceptor ?

Thanks in advance

I have handled to run my simulator in similar and recombined the situation.ep.i information and considered the outcome in ElmerPost, but I can't determine how to merge the outcomes information.

http://results.hamariweb.com/matriculation-results.aspx

I succed to solve this ...
1. I extend EmptyInterceptor class .
2. override "onPrepareStatement" method , on this method I get the sql query generated by hibernate , before executing in the database.
3. in the override implementation of "onPrepareStatement" I used this artifact

<groupId>net.sf.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.8.0</version>

for parse and manipulating sql query - in my case I add where condition .

I will apply this thanks

Is it worked for insertions into tables which has dependency on another database