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 = ?

Debug level Hibernate log excerpt:

Problems with Session and transaction handling?