Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version:
3.0
Mapping documents:
File employee.hbm.xml
Code:
<hibernate-mapping>
<class
name="com.xxxxx.Employee"
table="EMPLOYEE"
>
<id
name="id"
type="long"
column="ID"
>
<generator class="sequence">
<param name="sequence">SEQ_EMPLOYEE_ID</param>
</generator>
</id>
<property
name="loginName"
type="java.lang.String"
column="LOGINNAME"
length="50"
/>
<property
name="fullName"
type="java.lang.String"
column="FULLNAME"
length="50"
/>
<property
name="email"
type="java.lang.String"
column="EMAIL"
length="50"
/>
<property
name="password"
type="java.lang.String"
column="PASSWORD"
length="50"
/>
<!-- Associations -->
<!-- bi-directional many-to-many association to EmployeeRole -->
<bag name="roles" lazy="false" table="EMPLOYEE_ROLE">
<key column="EMPLOYEE_ID"/>
<many-to-many column="ROLE_ID"
class="com.microbia.services.db.studytracker.object.Role"/>
</bag>
</class>
</hibernate-mapping>
File role.hbm.xmlCode:
<hibernate-mapping>
<class
name="com.xxxxxx.Role"
table="ROLE"
>
<id
name="id"
type="long"
column="ID"
>
<generator class="sequence">
<param name="sequence">SEQ_ROLE_ID</param>
</generator>
</id>
<property
name="name"
type="java.lang.String"
column="NAME"
length="50"
/>
<property
name="description"
type="java.lang.String"
column="DESCRIPTION"
length="100"
/>
<!-- Associations -->
<!-- bi-directional many-to-many association to Employee -->
<bag name="employees" lazy="false" table="EMPLOYEE_ROLE">
<key column="ROLE_ID"/>
<many-to-many column="EMPLOYEE_ID"
class="com.microbia.services.db.studytracker.object.Employee"/>
</bag>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close(): Code:
static public List execHQLList(SessionFactory sf, String hql)
{
List objects = null;
// Open hibernate session
Session session = null;
try
{
// Open session
session = sf.openSession();
// Exec query
objects = session.createQuery(hql).list();
} finally // Note - do NOT catch exceptions so they bubble up to the calling class
{
// Always close session
if(session != null)
session.close();
}
return objects;
}
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
IssueThe code:
Code:
DBQuery.execHQLList(sf, "from employee");
executes fine, as does:
Code:
DBQuery.execHQLList(sf, "from Role");
however, the code below generates the above exception [note lower-case]:
Code:
DBQuery.execHQLList(sf, "from role");
Is HQL case-sensititve, is this a bug, or am I simply unable to locate a problem myself?
-Tim