Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

3.0

Mapping documents:

File employee.hbm.xml



File role.hbm.xml


Code between sessionFactory.openSession() and session.close():


Full runtime output (of involved classes) and stack trace of any exception that occurs:
[main] INFO org.hibernate.cfg.Environment - Hibernate 3.0rc1
[main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
[main] INFO org.hibernate.cfg.Environment - using CGLIB reflection optimizer
[main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
[main] INFO org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml
[main] INFO org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.username=
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.password=
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.dialect=org.hibernate.dialect.OracleDialect
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.url=jdbc:oracle:thin:@192.168.1.21:1521:app
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.statement_cache.size=0
[main] DEBUG org.hibernate.cfg.Configuration - hibernate.show_sql=true
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.acquire_increment=1
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.idle_test_period=100
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.max_size=10
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.max_statements=0
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.min_size=1
[main] DEBUG org.hibernate.cfg.Configuration - c3p0.timeout=100
[main] DEBUG org.hibernate.cfg.Configuration - com.xxx.hibernate.SessionFactory<-org.dom4j.tree.DefaultAttribute@94884d [Attribute: name resource value "com/xxx/hibernate/Employee.hbm.xml"]
[main] INFO org.hibernate.cfg.Configuration - Mapping resource: com/xxx/hibernate/Employee.hbm.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
[main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.xxxxxxx.Employee -> EMPLOYEE
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> ID
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: loginName -> LOGINNAME
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fullName -> FULLNAME
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: email -> EMAIL
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: password -> PASSWORD
[main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.xxxxxxxxxxxxxx.Employee.roles -> EMPLOYEE_ROLE
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: roles
[main] DEBUG org.hibernate.cfg.Configuration - com.xxx.hibernate.SessionFactory<-org.dom4j.tree.DefaultAttribute@13c468a [Attribute: name resource value "com/xxx/hibernate/Project.hbm.xml"]
[main] INFO org.hibernate.cfg.Configuration - Mapping resource: com/xxx/hibernate/Project.hbm.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
[main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.xxxxxx.Role -> ROLE
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> ID
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: name -> NAME
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: description -> DESCRIPTION
[main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.xxxxxxxxxxxxxx.Role.employees -> EMPLOYEE_ROLE
[main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: employees
[main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: com.xxx.hibernate.SessionFactory
[main] DEBUG org.hibernate.cfg.Configuration - properties: {c3p0.idle_test_period=100, hibernate.connection.password=yyyyy, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_04\jre\bin, java.vm.version=1.4.2_04-b05, hibernate.connection.username=DB, c3p0.min_size=1, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\DB, c3p0.max_size=10, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.c3p0.max_statements=0, java.endorsed.dirs=C:\j2sdk1.4.2_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\user\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, hibernate.c3p0.idle_test_period=100, sun.java2d.fontpath=, hibernate.c3p0.timeout=100, java.library.path=C:\j2sdk1.4.2_04\bin;.;C:\WINNT\system32;C:\WINNT;C:\j2sdk1.4.2_04\bin\;C:\apache-ant-1.6.2\\bin;C:\oracle\ora90\bin;C:\PERL\BIN\;C:\PROGRAM FILES\EMBARCADERO\JULY2002SHARED;C:\PROGRAM FILES\EMBARCADERO\DBA603;C:\ORACLE\ORA81\BIN;C:\ORACLE\ORA81\APACHE\PERL\5.00503\BIN\MSWIN32-X86;C:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN;C:\WINNT\SYSTEM32;C:\WINNT;C:\WINNT\SYSTEM32\WBEM;C:\PROGRAM FILES\COMMON FILES\MDL SHARED\ISIS;C:\PROGRAM FILES\COMMON FILES\ADAPTEC SHARED\SYSTEM;C:\Program Files\Symantec\pcAnywhere\;C:\Program Files\Embarcadero\Nov2002Shared\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\yjp-2.5-build310\bin, java.specification.name=Java Platform API Specification, java.class.version=48.0, c3p0.acquire_increment=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\user, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, user.name=user, java.class.path=C:\Projects\App\webroot\WEB-INF\classes;C:\Projects\App\webroot\WEB-INF\lib\classes12.zip;C:\Projects\App\webroot\WEB-INF\lib\hibernate3.jar;C:\Projects\App\webroot\WEB-INF\lib\log4j-1.2.9.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\Projects\App\webroot\WEB-INF\lib\xerces-2.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\xml-apis.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-antlr-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-junit-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-launcher-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-swing-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\antlr-2.7.4.jar;C:\Projects\App\webroot\WEB-INF\lib\c3p0-0.8.5.jar;C:\Projects\App\webroot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\Projects\App\webroot\WEB-INF\lib\cleanimports.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\Projects\App\webroot\WEB-INF\lib\concurrent-1.3.2.jar;C:\Projects\App\webroot\WEB-INF\lib\connector.jar;C:\Projects\App\webroot\WEB-INF\lib\dom4j-1.5.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ehcache-1.1.jar;C:\Projects\App\webroot\WEB-INF\lib\jaas.jar;C:\Projects\App\webroot\WEB-INF\lib\jacc-1_0-fr.jar;C:\Projects\App\webroot\WEB-INF\lib\jaxen-1.1-beta-4.jar;C:\Projects\App\webroot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\Projects\App\webroot\WEB-INF\lib\jgroups-2.2.7.jar;C:\Projects\App\webroot\WEB-INF\lib\jta.jar;C:\Projects\App\webroot\WEB-INF\lib\junit-3.8.1.jar;C:\Projects\App\webroot\WEB-INF\lib\oscache-2.1.jar;C:\Projects\App\webroot\WEB-INF\lib\proxool-0.8.3.jar;C:\Projects\App\webroot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\Projects\App\webroot\WEB-INF\lib\versioncheck.jar;C:\Projects\App\webroot\WEB-INF\lib\antlr.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-beanutils.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-collections.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-digester.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-fileupload.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-logging.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-validator.jar;C:\Projects\App\webroot\WEB-INF\lib\jakarta-oro.jar;C:\Projects\App\webroot\WEB-INF\lib\struts.jar;C:\Projects\App\webroot\WEB-INF\lib\jsf-api.jar;C:\Projects\App\webroot\WEB-INF\lib\jsf-impl.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_04\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:oracle:thin:@192.168.1.21:1521:scope1dv, hibernate.dialect=org.hibernate.dialect.OracleDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=10, awt.toolkit=sun.awt.windows.WToolkit, c3p0.timeout=100, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, c3p0.max_statements=0, java.version=1.4.2_04, java.ext.dirs=C:\j2sdk1.4.2_04\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_04\jre\lib\rt.jar;C:\j2sdk1.4.2_04\jre\lib\i18n.jar;C:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_04\jre\lib\jsse.jar;C:\j2sdk1.4.2_04\jre\lib\jce.jar;C:\j2sdk1.4.2_04\jre\lib\charsets.jar;C:\j2sdk1.4.2_04\jre\classes;C:\Program Files\MyEclipse\eclipse\plugins\com.xxx.hibernate.SessionFactory, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.statement_cache.size=0, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
[main] DEBUG org.hibernate.cfg.Configuration - Preparing to build session factory with filters : {}
[main] INFO org.hibernate.cfg.Configuration - processing extends queue
[main] INFO org.hibernate.cfg.Configuration - processing collection mappings

<snip>

[main] INFO org.hibernate.cfg.Configuration - processing association property references
[main] INFO org.hibernate.cfg.Configuration - processing foreign key constraints
[main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.xxxxxxxxxx.Employee
[main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.xxxxxxxxxx.Role
[main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.xxxxxxxxxx.Employee
[main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.OracleDialect
[main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
[main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
[main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
[main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
[main] INFO org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@192.168.1.21:1521:scope1dv
[main] INFO org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {user=DB, password=****}
[main] INFO org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1a082e2 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@136a43c [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 100, initialPoolSize -> 1, maxIdleTime -> 100, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@13d28e3 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:oracle:thin:@192.168.1.21:1521:scope1dv, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 1a082e2 ]
[main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
[main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
[main] DEBUG org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
[main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
[main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
[main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
[main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: enabled
[main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
[main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
[main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
[main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
[main] DEBUG org.hibernate.impl.SessionFactoryImpl - Session factory constructed with filter configurations : {}
[main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {c3p0.idle_test_period=100, hibernate.connection.password=yyyyy, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_04\jre\bin, java.vm.version=1.4.2_04-b05, hibernate.connection.username=DB, c3p0.min_size=1, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\DB, c3p0.max_size=10, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.c3p0.max_statements=0, java.endorsed.dirs=C:\j2sdk1.4.2_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\user\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, hibernate.c3p0.idle_test_period=100, sun.java2d.fontpath=, hibernate.c3p0.timeout=100, java.library.path=C:\j2sdk1.4.2_04\bin;.;C:\WINNT\system32;C:\WINNT;C:\j2sdk1.4.2_04\bin\;C:\apache-ant-1.6.2\\bin;C:\oracle\ora90\bin;C:\PERL\BIN\;C:\PROGRAM FILES\EMBARCADERO\JULY2002SHARED;C:\PROGRAM FILES\EMBARCADERO\DBA603;C:\ORACLE\ORA81\BIN;C:\ORACLE\ORA81\APACHE\PERL\5.00503\BIN\MSWIN32-X86;C:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN;C:\WINNT\SYSTEM32;C:\WINNT;C:\WINNT\SYSTEM32\WBEM;C:\PROGRAM FILES\COMMON FILES\MDL SHARED\ISIS;C:\PROGRAM FILES\COMMON FILES\ADAPTEC SHARED\SYSTEM;C:\Program Files\Symantec\pcAnywhere\;C:\Program Files\Embarcadero\Nov2002Shared\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\yjp-2.5-build310\bin, java.specification.name=Java Platform API Specification, java.class.version=48.0, c3p0.acquire_increment=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\user, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, user.name=user, java.class.path=C:\Projects\App\webroot\WEB-INF\classes;C:\Projects\App\webroot\WEB-INF\lib\classes12.zip;C:\Projects\App\webroot\WEB-INF\lib\hibernate3.jar;C:\Projects\App\webroot\WEB-INF\lib\log4j-1.2.9.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\Projects\App\webroot\WEB-INF\lib\xerces-2.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\xml-apis.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-antlr-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-junit-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-launcher-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ant-swing-1.6.2.jar;C:\Projects\App\webroot\WEB-INF\lib\antlr-2.7.4.jar;C:\Projects\App\webroot\WEB-INF\lib\c3p0-0.8.5.jar;C:\Projects\App\webroot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\Projects\App\webroot\WEB-INF\lib\cleanimports.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\Projects\App\webroot\WEB-INF\lib\concurrent-1.3.2.jar;C:\Projects\App\webroot\WEB-INF\lib\connector.jar;C:\Projects\App\webroot\WEB-INF\lib\dom4j-1.5.2.jar;C:\Projects\App\webroot\WEB-INF\lib\ehcache-1.1.jar;C:\Projects\App\webroot\WEB-INF\lib\jaas.jar;C:\Projects\App\webroot\WEB-INF\lib\jacc-1_0-fr.jar;C:\Projects\App\webroot\WEB-INF\lib\jaxen-1.1-beta-4.jar;C:\Projects\App\webroot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\Projects\App\webroot\WEB-INF\lib\jgroups-2.2.7.jar;C:\Projects\App\webroot\WEB-INF\lib\jta.jar;C:\Projects\App\webroot\WEB-INF\lib\junit-3.8.1.jar;C:\Projects\App\webroot\WEB-INF\lib\oscache-2.1.jar;C:\Projects\App\webroot\WEB-INF\lib\proxool-0.8.3.jar;C:\Projects\App\webroot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\Projects\App\webroot\WEB-INF\lib\versioncheck.jar;C:\Projects\App\webroot\WEB-INF\lib\antlr.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-beanutils.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-collections.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-digester.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-fileupload.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-logging.jar;C:\Projects\App\webroot\WEB-INF\lib\commons-validator.jar;C:\Projects\App\webroot\WEB-INF\lib\jakarta-oro.jar;C:\Projects\App\webroot\WEB-INF\lib\struts.jar;C:\Projects\App\webroot\WEB-INF\lib\jsf-api.jar;C:\Projects\App\webroot\WEB-INF\lib\jsf-impl.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_04\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:oracle:thin:@192.168.1.21:1521:scope1dv, hibernate.dialect=org.hibernate.dialect.OracleDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=10, awt.toolkit=sun.awt.windows.WToolkit, c3p0.timeout=100, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, c3p0.max_statements=0, java.version=1.4.2_04, java.ext.dirs=C:\j2sdk1.4.2_04\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_04\jre\lib\rt.jar;C:\j2sdk1.4.2_04\jre\lib\i18n.jar;C:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_04\jre\lib\jsse.jar;C:\j2sdk1.4.2_04\jre\lib\jce.jar;C:\j2sdk1.4.2_04\jre\lib\charsets.jar;C:\j2sdk1.4.2_04\jre\classes;C:\Program Files\MyEclipse\eclipse\plugins\com.xxx.hibernate.SessionFactory, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.statement_cache.size=0, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
[main] DEBUG net.sf.ehcache.CacheManager - Creating new CacheManager with default config
[main] DEBUG net.sf.ehcache.CacheManager - Configuring ehcache from classpath.
[main] WARN net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/Projects/App/webroot/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
[main] DEBUG net.sf.ehcache.config.Configuration$DiskStore - Disk Store Path: C:\DOCUME~1\user\LOCALS~1\Temp\


[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Static SQL for entity: com.xxxxxxxxxx.Employee
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Version select: select ID from EMPLOYEE where ID =?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Snapshot select: select employee_.ID, employee_.LOGINNAME as LOGINNAME12_, employee_.FULLNAME as FULLNAME12_, employee_.EMAIL as EMAIL12_, employee_.PASSWORD as PASSWORD12_ from EMPLOYEE employee_ where employee_.ID=?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Insert 0: insert into EMPLOYEE (LOGINNAME, FULLNAME, EMAIL, PASSWORD, ID) values (?, ?, ?, ?, ?)
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Update 0: update EMPLOYEE set LOGINNAME=?, FULLNAME=?, EMAIL=?, PASSWORD=? where ID=?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Delete 0: delete from EMPLOYEE where ID=?

[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Static SQL for entity: com.xxxxxxxxxxx.Role
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Version select: select ID from ROLE where ID =?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Snapshot select: select role_.ID, role_.NAME as NAME15_, role_.DESCRIPTION as DESCRIPT3_15_ from ROLE role_ where role_.ID=?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Insert 0: insert into ROLE (NAME, DESCRIPTION, ID) values (?, ?, ?)
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Update 0: update ROLE set NAME=?, DESCRIPTION=? where ID=?
[main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Delete 0: delete from ROLE where ID=?


[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.xxxxxxxxxxxx.employees
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: insert into EMPLOYEE_ROLE (ROLE_ID, EMPLOYEE_ID) values (?, ?)
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row update: update EMPLOYEE_ROLE set EMPLOYEE_ID=? where ROLE_ID=? and EMPLOYEE_ID=?
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: delete from EMPLOYEE_ROLE where ROLE_ID=? and EMPLOYEE_ID=?
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: delete from EMPLOYEE_ROLE where ROLE_ID=?

[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.xxxxxxxxxxxx.roles
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: insert into EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID) values (?, ?)
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row update: update EMPLOYEE_ROLE set ROLE_ID=? where EMPLOYEE_ID=? and ROLE_ID=?
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: delete from EMPLOYEE_ROLE where EMPLOYEE_ID=? and ROLE_ID=?
[main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: delete from EMPLOYEE_ROLE where EMPLOYEE_ID=?


[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Employee: select employee0_.ID as ID0_, employee0_.LOGINNAME as LOGINNAME12_0_, employee0_.FULLNAME as FULLNAME12_0_, employee0_.EMAIL as EMAIL12_0_, employee0_.PASSWORD as PASSWORD12_0_ from EMPLOYEE employee0_ where employee0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Employee: select employee0_.ID as ID0_, employee0_.LOGINNAME as LOGINNAME12_0_, employee0_.FULLNAME as FULLNAME12_0_, employee0_.EMAIL as EMAIL12_0_, employee0_.PASSWORD as PASSWORD12_0_ from EMPLOYEE employee0_ where employee0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Employee: select employee0_.ID as ID0_, employee0_.LOGINNAME as LOGINNAME12_0_, employee0_.FULLNAME as FULLNAME12_0_, employee0_.EMAIL as EMAIL12_0_, employee0_.PASSWORD as PASSWORD12_0_ from EMPLOYEE employee0_ where employee0_.ID=? for update
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Employee: select employee0_.ID as ID0_, employee0_.LOGINNAME as LOGINNAME12_0_, employee0_.FULLNAME as FULLNAME12_0_, employee0_.EMAIL as EMAIL12_0_, employee0_.PASSWORD as PASSWORD12_0_ from EMPLOYEE employee0_ where employee0_.ID=? for update nowait
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Role: select role0_.ID as ID0_, role0_.NAME as NAME15_0_, role0_.DESCRIPTION as DESCRIPT3_15_0_ from ROLE role0_ where role0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Role: select role0_.ID as ID0_, role0_.NAME as NAME15_0_, role0_.DESCRIPTION as DESCRIPT3_15_0_ from ROLE role0_ where role0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Role: select role0_.ID as ID0_, role0_.NAME as NAME15_0_, role0_.DESCRIPTION as DESCRIPT3_15_0_ from ROLE role0_ where role0_.ID=? for update
[main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.xxxxxxxxxxxxxxxxx.Role: select role0_.ID as ID0_, role0_.NAME as NAME15_0_, role0_.DESCRIPTION as DESCRIPT3_15_0_ from ROLE role0_ where role0_.ID=? for update nowait


[main] DEBUG org.hibernate.loader.collection.CollectionLoader - Static select for collection com.xxxxxxx.Role.employees: select employees0_.ROLE_ID as ROLE2___, employees0_.EMPLOYEE_ID as EMPLOYEE1___, employee1_.ID as ID0_, employee1_.LOGINNAME as LOGINNAME12_0_, employee1_.FULLNAME as FULLNAME12_0_, employee1_.EMAIL as EMAIL12_0_, employee1_.PASSWORD as PASSWORD12_0_ from EMPLOYEE_ROLE employees0_, EMPLOYEE employee1_ where employees0_.EMPLOYEE_ID=employee1_.ID and employees0_.ROLE_ID=?

[main] DEBUG org.hibernate.loader.collection.CollectionLoader - Static select for collection com.xxxxxxx.Employee.roles: select roles0_.EMPLOYEE_ID as EMPLOYEE1___, roles0_.ROLE_ID as ROLE2___, role1_.ID as ID0_, role1_.NAME as NAME15_0_, role1_.DESCRIPTION as DESCRIPT3_15_0_ from EMPLOYEE_ROLE roles0_, ROLE role1_ where roles0_.ROLE_ID=role1_.ID and roles0_.EMPLOYEE_ID=?

[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - registered: 4028810702dad5860102dad5954e0000 (com.xxx.hibernate.SessionFactory)
[main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Factory name: com.xxx.hibernate.SessionFactory
[main] INFO org.hibernate.util.NamingHelper - JNDI InitialContext properties:{}
[main] DEBUG org.hibernate.util.NamingHelper - binding: com.xxx.hibernate.SessionFactory
[main] WARN org.hibernate.impl.SessionFactoryObjectFactory - Could not bind factory to JNDI
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:640)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:243)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:280)
at javax.naming.InitialContext.getNameParser(InitialContext.java:429)
at org.hibernate.util.NamingHelper.bind(NamingHelper.java:52)
at org.hibernate.impl.SessionFactoryObjectFactory.addInstance(SessionFactoryObjectFactory.java:90)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:247)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1043)
at com.xxxxxxxxxx.ObjectListFactory.main(ObjectListFactory.java:110)
[main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiated session factory
[main] INFO org.hibernate.impl.SessionFactoryImpl - Checking 0 named queries
[main] INFO com.xxxxxxxxx.plugin.HibernatePlugin - Got Hibernate Session
[main] DEBUG org.hibernate.impl.SessionImpl - opened session
[main] DEBUG org.hibernate.impl.SessionImpl - find: from role
[main] DEBUG org.hibernate.engine.QueryParameters - named parameters: {}
[main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - parse() - HQL: from role
[main] DEBUG org.hibernate.hql.AST - --- HQL AST ---
\-[QUERY] CommonAST: 'query'
\-[SELECT_FROM] CommonAST: 'SELECT_FROM'
\-[FROM] CommonAST: 'from'
\-[IDENT] CommonAST: 'role'

[main] DEBUG hql.parser - throwQueryException() : no errors
[main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() << begin, level = 1
[main] ERROR hql.parser - *** ERROR: role is not mapped.
[main] DEBUG hql.parser - role is not mapped.
role is not mapped.
at org.hibernate.hql.ast.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:81)
at org.hibernate.hql.ast.FromElementFactory.addFromElement(FromElementFactory.java:77)
at org.hibernate.hql.ast.FromClause.addFromElement(FromClause.java:71)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:223)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2312)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2232)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:498)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:356)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:184)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:140)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:773)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at com.xxx.hibernate.DBQuery.execHQLList(DBQuery.java:55)
at com.xxxxxxxx.ObjectListFactory.getRoles(ObjectListFactory.java:84)
at com.xxxxxxxx.ObjectListFactory.main(ObjectListFactory.java:114)
[main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() : finishing up...
[main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - Derived SELECT clause created.
[main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() >> end, level = 1
[main] DEBUG org.hibernate.hql.AST - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT'
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
\-[FROM] FromClause: 'from' FromClause{from}

[main] DEBUG org.hibernate.impl.SessionImpl - closing session
org.hibernate.hql.ast.QuerySyntaxError: role is not mapped. [from role ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:195)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:773)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at com.xxx.hibernate.DBQuery.execHQLList(DBQuery.java:55)
at com.xxxxxx.ObjectListFactory.getRoles(ObjectListFactory.java:84)
at com.xxxxxx.ObjectListFactory.main(ObjectListFactory.java:114)
Caused by: role is not mapped.
at org.hibernate.hql.ast.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:81)
at org.hibernate.hql.ast.FromElementFactory.addFromElement(FromElementFactory.java:77)
at org.hibernate.hql.ast.FromClause.addFromElement(FromClause.java:71)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:223)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2312)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2232)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:498)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:356)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:184)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:140)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
... 9 more
Exception in thread "main"

Name and version of the database you are using:

Oracle 8.1.7

Issue

The code:



executes fine, as does:



however, the code below generates the above exception [note lower-case]:



Is HQL case-sensititve, is this a bug, or am I simply unable to locate a problem myself?

-Tim

Did you bother reading the documentation before posting here?

Am I expecting too much?


Sheesh.

Of course I did. I've read the online documentation, (half) of the print version of "Hibernate in Action", searched the E-book, and tried searching the forum.

This is a fantastic effort guys, and as a newcomer, I can say it's quite straightforward to adopt about 90% of it.

In the example above, can you please explain why "from employee" works as lowercase, but "from role" doesn't? I'm mystified. I can't find anything in my config files to explain the discrepancy.

Thanks,

-Tim

http://www.hibernate.org/hib_docs/v3/re ... ensitivity

http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-casesensitivity

14.1. Case Sensitivity

Queries are case-insensitive, except for names of Java classes and properties. So SeLeCT is the same as sELEct is the same as SELECT but org.hibernate.eg.FOO is not org.hibernate.eg.Foo and foo.barSet is not foo.BARSET.

This manual uses lowercase HQL keywords. Some users find queries with uppercase keywords more readable, but we find this convention ugly when embedded in Java code.




Hope this helps ;-)

I swear I read that before I posted to the forum ;-)

Can either of you kind souls please tie that back to my example? According to the docs, proper syntax in my example should be:

"from Role"
and
"from Employee"

Why does "from employee" work for me then?

Thanks much,

-Tim

Sorry!
I have no clue!

But your example only shows that "from role" do not work, maybe you could double check if "from employee" really works.

Maybe only paste the success part ;-)

Odd "from employee" is no longer working for me. Doubtful as it may sound, it was working in my environment yesterday and this morning, which is how I headed down the path of using lower-case letters for all values.

All set now. Thanks for your help.

-Tim

P.S. Reading the documentation doesn't necessarily mean that I understood it ;-)

Head up!

I exactly know what you mean ;-)