Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailinglists/HowToAskForHelp
Hibernate version: 3.2.0.ga
Mapping documents: @Entity @Table(name = "SECURITY_USERS") @Cache(usage = cacheConcurrencyStrategy.NONSTRICT_READ_WRITE) public class User {
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
Name and version of the database you are using: oracle 10.2.0.1
The generated SQL (show_sql=true): select r.name from SECURITY_resources c,SECURITY_roles r,SECURITY_role_resc rc where c.id = rc.resc_id and r.id = rc.role_id and c.res_string = ?