complex legacy table mapping frustration!

eXtorn · **Posted:** Thu May 05, 2005 11:41 am

Basically, I have 2 legacy tables I am attempting to shoe horn into an object model, and it is failing. Ive spent quite a bit of time trying what I can see the various ways of doing it are from the Docs, and this is how it has ended up.

The 2 tables are listed as follows in the real database schema

table : cadescrp
PK ds_rectyp = char(2)
PK ds_reckey = char(8)
ds_dscrn = char(40)
ds_partnr = char(1)

table : causerdp

ud_type = char(2) - This is a descriminator column for subtypes
PK ud_colnum = smallint
ud_desc = char(40)
ud_format = char(1)
ud_group = char(4)
ud_mandat = char(1)
ud_length = smallint
FK ud_select = char(2)

So.... what i WANT is the following java object structure seems best that hibernate can offer).

UserProfile UserProfileOptions
|
-----------------------------------------
| |
UserProfileTypeA UserProfileTypeB

where UserProfileOptions is a set contained within the UserProfile (since they are direct children objects).

Hibernate version:

3.0.1

Mapping documents:

File 1

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.axxia.pkc.core.afcl.domain">

  <class name="UserProfileListOption" table="cadescrp">
    
    <composite-id name="id" class="UserProfileListOptionId">
        <key-many-to-one name="userProfile" class="UserProfile" column="ds_rectyp"/>
        <key-property name="listOptionCode" column="ud_colnum" type="string" length="8"/>
    </composite-id>

    <property name="name" type="string">
      <column name="ds_dscrn" not-null="true" sql-type="CHAR" length="40"/>
    </property>
    
    <property name="partner" type="character">
      <column name="ud_select" not-null="true" sql-type="CHAR" length="1"/>
    </property>
    
  </class>
</hibernate-mapping>

File 2

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.axxia.pkc.core.afcl.domain">

  <class lazy="false" name="UserProfile" table="causerdp" where="ud_colnum &lt; '500'">
    <id name="code" type="short" >
      <column name="ud_colnum" not-null="true" sql-type="SMALLINT"/>
      <generator class="assigned"></generator>
    </id>

    <discriminator
        column="ud_type"
        type="string"
        insert="true"
    />
     
    <property name="name" type="string">
      <column name="ud_desc" not-null="true" sql-type="CHAR" length="20"/>
    </property>

    <set name="listOptions" inverse="true" >
      <key column="ud_select"/>
      <one-to-many class="UserProfileListOption"/>
    </set>

    <property name="select" type="string">
      <column name="ud_select" not-null="false" sql-type="CHAR" length="2"/>
    </property>

    <property name="format" type="character">
      <column name="ud_format" not-null="true" sql-type="CHAR" length="1"/>
    </property>

    <property name="group" type="string">
      <column name="ud_group" not-null="false" sql-type="CHAR" length="4"/>
    </property>

    <property name="mandatory" type="character">
      <column name="ud_mandat" not-null="false" sql-type="CHAR" length="1"/>
    </property>

    <property name="length" type="short">
      <column name="ud_length" not-null="true" sql-type="SMALLINT"/>
    </property>
    
  </class>
</hibernate-mapping>

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

Code:

EntityManager e = EntityManagerFactory.getEntityManager();
    Session s = e.getSession();
    assertEquals(0,s.createCriteria(UserProfile.class).list().size());
    //EntityManagerFactory.getEntityManager().beginTransaction();
    
    PersonnelUserProfile up = new PersonnelUserProfile();
    up.setCode((short)456);
    up.setFormat('1');
    up.setGroup(null);
    up.setLength((short)4);
    up.setMandatory('n');
    up.setName("barney");
    up.setSelect("fred");
    
    UserProfileListOptionId id = new UserProfileListOptionId();
    id.setListOptionCode("A Code");
    id.setUserProfile(up);
    
    UserProfileListOption uplo = new UserProfileListOption();
    uplo.setName("A name about a code");
    uplo.setPartner('y');
    uplo.setId(id);
    uplo.getId().setUserProfile(up);
    
    //uplo.setUserProfile(up);
    //Set options = new HashSet();
    //options.add(uplo);
    //up.setListOptions(options);

    e.save(uplo);
    //s.persist(uplo);
    //e.save(up);
    //e.commit();
    //assertEquals(1,s.createCriteria(UserProfile.class).list().size());
    
    Object o = e.getByPrimaryKey(UserProfileListOption.class,id ); 
    
    List list = e.runQuery("from UserProfileListOption", null);
    
    
    assertEquals(1,s.createCriteria(UserProfileListOption.class).list().size());

Full stack trace of any exception that occurs:

Code:

org.hibernate.HibernateException: instance not of expected entity type: com.axxia.pkc.core.afcl.domain.UserProfile
   at org.hibernate.persister.entity.BasicEntityPersister.getSubclassEntityPersister(BasicEntityPersister.java:2990)
   at org.hibernate.impl.SessionImpl.getEntityPersister(SessionImpl.java:1027)
   at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:180)
   at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:215)
   at org.hibernate.type.EntityType.getIdentifier(EntityType.java:88)
   at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:59)
   at org.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:191)
   at org.hibernate.persister.entity.BasicEntityPersister.getDatabaseSnapshot(BasicEntityPersister.java:885)
   at org.hibernate.engine.PersistenceContext.getDatabaseSnapshot(PersistenceContext.java:301)
   at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
   at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:407)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:82)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
   at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:432)
   at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:427)
   at com.axxia.util.hibernate.EntityManagerImpl.save(EntityManagerImpl.java:58)
   at com.axxia.invoice.hibernate.MappingFilesTest.testUserProfiles(MappingFilesTest.java:60)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at junit.framework.TestCase.runTest(TestCase.java:154)
   at junit.framework.TestCase.runBare(TestCase.java:127)
   at junit.framework.TestResult$1.protect(TestResult.java:106)
   at junit.framework.TestResult.runProtected(TestResult.java:124)
   at junit.framework.TestResult.run(TestResult.java:109)
   at junit.framework.TestCase.run(TestCase.java:118)
   at junit.framework.TestSuite.runTest(TestSuite.java:208)
   at junit.framework.TestSuite.run(TestSuite.java:203)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:474)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:342)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:194)

Name and version of the database you are using:

HSQL2 (I think) comes standard with Hibernate

The generated SQL (show_sql=true):

Code:

Hibernate: select this_.ud_colnum as ud1_0_, this_.ud_desc as ud3_0_0_, this_.ud_select as ud4_0_0_, this_.ud_format as ud5_0_0_, this_.ud_group as ud6_0_0_, this_.ud_mandat as ud7_0_0_, this_.ud_length as ud8_0_0_, this_.ud_type as ud2_0_ from causerdp this_ where this_.ud_colnum < '500'
Hibernate: select userprofil_.ds_rectyp, userprofil_.ud_colnum, userprofil_.ds_dscrn as ds3_1_, userprofil_.ud_select as ud4_1_ from cadescrp userprofil_ where userprofil_.ds_rectyp=? and userprofil_.ud_colnum=?

Debug level Hibernate log excerpt:

Code:

16:23,554  INFO Environment:460 - Hibernate 3.0.1
16:23,570  INFO Environment:478 - loaded properties from resource hibernate.properties: {hibernate.connection.username=sa, hibernate.connection.password=****, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:., hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, hibernate.hbm2ddl.auto=create}
16:23,570  INFO Environment:506 - using CGLIB reflection optimizer
16:23,570  INFO Environment:536 - using JDK 1.4 java.sql.Timestamp handling
16:23,679  INFO Configuration:1175 - configuring from url: file:/C:/axxia-v3/invoice/test_src/com/axxia/invoice/hibernate/hibernate.cfg.xml
16:23,990 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath under org/hibernate/
16:24,006 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath
16:24,053 DEBUG Configuration:1117 - hibernate.dialect=org.hibernate.dialect.HSQLDialect
16:24,053 DEBUG Configuration:1117 - hibernate.connection.driver_class=org.hsqldb.jdbcDriver
16:24,053 DEBUG Configuration:1117 - hibernate.connection.url=jdbc:hsqldb:.
16:24,053 DEBUG Configuration:1117 - hibernate.connection.username=sa
16:24,053 DEBUG Configuration:1117 - hibernate.connection.password=
16:24,068 DEBUG Configuration:1117 - hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
16:24,068 DEBUG Configuration:1117 - hibernate.c3p0.min_size=1
16:24,068 DEBUG Configuration:1117 - hibernate.c3p0.max_size=5
16:24,068 DEBUG Configuration:1117 - hibernate.show_sql=true
16:24,068 DEBUG Configuration:1312 - null<-org.dom4j.tree.DefaultAttribute@124bbbf [Attribute: name resource value "com/axxia/pkc/core/afcl/domain/UserProfile.hbm.xml"]
16:24,068  INFO Configuration:441 - Mapping resource: com/axxia/pkc/core/afcl/domain/UserProfile.hbm.xml
16:24,084 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
16:24,084 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:24,255  INFO HbmBinder:258 - Mapping class: com.axxia.pkc.core.afcl.domain.UserProfile -> causerdp
16:24,255 DEBUG HbmBinder:1089 - Mapped property: code -> ud_colnum
16:24,271 DEBUG HbmBinder:1089 - Mapped property: name -> ud_desc
16:24,286 DEBUG HbmBinder:1089 - Mapped property: listOptions
16:24,286 DEBUG HbmBinder:1089 - Mapped property: select -> ud_select
16:24,286 DEBUG HbmBinder:1089 - Mapped property: format -> ud_format
16:24,286 DEBUG HbmBinder:1089 - Mapped property: group -> ud_group
16:24,286 DEBUG HbmBinder:1089 - Mapped property: mandatory -> ud_mandat
16:24,286 DEBUG HbmBinder:1089 - Mapped property: length -> ud_length
16:24,286 DEBUG Configuration:1312 - null<-org.dom4j.tree.DefaultAttribute@17fa65e [Attribute: name resource value "com/axxia/pkc/core/afcl/domain/UserProfileListOption.hbm.xml"]
16:24,286  INFO Configuration:441 - Mapping resource: com/axxia/pkc/core/afcl/domain/UserProfileListOption.hbm.xml
16:24,286 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
16:24,286 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:24,333  INFO HbmBinder:258 - Mapping class: com.axxia.pkc.core.afcl.domain.UserProfileListOption -> cadescrp
16:24,411 DEBUG HbmBinder:1089 - Mapped property: userProfile -> ds_rectyp
16:24,427 DEBUG HbmBinder:1089 - Mapped property: listOptionCode -> ud_colnum
16:24,427 DEBUG HbmBinder:1089 - Mapped property: id -> ds_rectyp, ud_colnum
16:24,442 DEBUG HbmBinder:1089 - Mapped property: name -> ds_dscrn
16:24,442 DEBUG HbmBinder:1089 - Mapped property: partner -> ud_select
16:24,442 DEBUG Configuration:1312 - null<-org.dom4j.tree.DefaultAttribute@76cbf7 [Attribute: name resource value "com/axxia/pkc/personnel/afcl/domain/FeeEarnerUserProfile.hbm.xml"]
16:24,442  INFO Configuration:441 - Mapping resource: com/axxia/pkc/personnel/afcl/domain/FeeEarnerUserProfile.hbm.xml
16:24,458 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
16:24,458 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:24,520  INFO HbmBinder:736 - Mapping subclass: com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile -> causerdp
16:24,520 DEBUG HbmBinder:2118 - Named query: com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile.getCount -> 
    
      select count(*) from FeeEarnerUserProfile
    
  
16:24,520  INFO Configuration:1272 - Configured SessionFactory: null
16:24,536 DEBUG Configuration:1273 - properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=, sun.boot.library.path=C:\Program Files\Java\jre1.5.0_02\bin, java.vm.version=1.5.0_02-b09, hibernate.connection.username=sa, 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=GB, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\axxia-v3\invoice, com.axxia.util.hibernate.EntityManagerFactory-class=com.axxia.util.hibernate.testutil.TestEntityManagerFactory, java.runtime.version=1.5.0_02-b09, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.5.0_02\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\delig\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre1.5.0_02\bin;.;C:\WINDOWS\system32;C:\WINDOWS;c:\program files\imagemagick-6.1.3-q16;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Informix\Connect\bin;C:\Program Files\GnuWin32\bin;S:\pvcs\VM\Win32\Bin;C:\Java_cur_ver\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\delig, user.timezone=Europe/London, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, java.class.path=/c:/Program Files/eclipse3.1M5/eclipse/plugins/org.eclipse.jdt.junit_3.1.0/junitsupport.jar;/c:/Program Files/eclipse3.1M5/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.1.0/junitruntime.jar;C:\axxia-v3\invoice\bin;C:\axxia-v3\util\bin;C:\Program Files\eclipse3.1M5\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\axxia-v3\ThirdParties\avalon\avalon-framework-4.1.4.jar;C:\axxia-v3\ThirdParties\fop\batik.jar;C:\axxia-v3\ThirdParties\Graphs\graphs.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\c3p0-0.8.5.jar;C:\axxia-v3\ThirdParties\InformixJDBC-2.21.JC5\ifxjdbc-2.21.JC5.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils.jar;C:\axxia-v3\ThirdParties\jakarta-chain-20041108\commons-chain.jar;C:\axxia-v3\ThirdParties\jakarta-collections\commons-collections-3.1.jar;C:\axxia-v3\ThirdParties\jakarta-commons-logging\commons-logging.jar;C:\axxia-v3\ThirdParties\jakarta-digester-1.6\commons-digester.jar;C:\axxia-v3\ThirdParties\jakarta-lang\commons-lang.jar;C:\axxia-v3\ThirdParties\jakarta-log4j-1.2.5\log4j-1.2.5.jar;C:\axxia-v3\ThirdParties\jbpm.3\commons-codec-1.3.jar;C:\axxia-v3\ThirdParties\jtds-SQLServerJDBC\jtds-1.0.jar;C:\axxia-v3\ThirdParties\unittest\easymock.jar;C:\axxia-v3\ThirdParties\antlr\ognl-3.0.0-pre-2.jar;C:\axxia-v3\ThirdParties\fop\fop.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\commons-collections-2.1.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\commons-logging-1.0.4.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\concurrent-1.3.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\connector.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\dom4j-1.5.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\ehcache-1.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\hibernate3.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jaas.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jacc-1_0-fr.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jaxen-1.1-beta-4.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-cache.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-common.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-jmx.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-system.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jdbc2_0-stdext.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jgroups-2.2.7.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jta.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\oscache-2.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\proxool-0.8.3.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\swarmcache-1.0rc2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\versioncheck.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\xerces-2.6.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\xml-apis.jar;C:\axxia-v3\ThirdParties\InformixJDBC-2.21.JC5\ifxjdbcx-2.21.JC5.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils-bean-collections.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils-core.jar;C:\axxia-v3\ThirdParties\unittest\junit.jar;C:\axxia-v3\ThirdParties\jboss-aop-1.1.1\jboss-aspect-library-jdk50.jar;C:\axxia-v3\ThirdParties\jbpm.3\bsh-2.0b2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\asm.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\asm-attrs.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\cglib-2.1.jar;C:\axxia-v3\ThirdParties\jboss-aop-1.1.1\jboss-aop-jdk50.jar;C:\axxia-v3\ThirdParties\antlr\antlr-2.7.5H3.jar;C:\axxia-v3\ThirdParties\jbpm.3\jbpm-3.0-alpha3.jar;C:\axxia-v3\ThirdParties\jstl\jstl.jar;C:\axxia-v3\ThirdParties\jstl\standard.jar;C:\axxia-v3\ThirdParties\json-rpc\jsonrpc.jar;C:\axxia-v3\ThirdParties\hsqldb-1.7.3.3.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\jboss-j2ee.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\javax.servlet.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\javax.servlet.jsp.jar;C:\axxia-v3\xmlgen\bin;C:\axxia-v3\personnel\bin;C:\axxia-v3\client\bin;C:\axxia-v3\core\bin;C:\axxia-v3\file\bin;C:\axxia-v3\core\bin;C:\axxia-v3\plan\bin;C:\axxia-v3\firm\bin;C:\axxia-v3\timerecording\bin;C:\axxia-v3\PKC\bin;C:\axxia-v3\workflow\bin;C:\axxia-v3\durian\bin;C:\axxia-v3\PKCTest\bin;C:\Program Files\eclipse3.1M5\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\axxia-v3\invoice\test_src\com\axxia\invoice\hibernate, user.name=delig, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre1.5.0_02, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:., user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=5, awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, sharing, java.version=1.5.0_02, java.ext.dirs=C:\Program Files\Java\jre1.5.0_02\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.5.0_02\lib\rt.jar;C:\Program Files\Java\jre1.5.0_02\lib\i18n.jar;C:\Program Files\Java\jre1.5.0_02\lib\sunrsasign.jar;C:\Program Files\Java\jre1.5.0_02\lib\jsse.jar;C:\Program Files\Java\jre1.5.0_02\lib\jce.jar;C:\Program Files\Java\jre1.5.0_02\lib\charsets.jar;C:\Program Files\Java\jre1.5.0_02\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.hbm2ddl.auto=create, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=}
16:24,567 DEBUG Configuration:1048 - Preparing to build session factory with filters : {}
16:24,567  INFO Configuration:852 - processing extends queue
16:24,567  INFO Configuration:856 - processing collection mappings
16:24,567 DEBUG HbmBinder:2342 - Second pass for collection: com.axxia.pkc.core.afcl.domain.UserProfile.listOptions
16:24,567  INFO HbmBinder:1962 - Mapping collection: com.axxia.pkc.core.afcl.domain.UserProfile.listOptions -> cadescrp
16:24,567 DEBUG HbmBinder:2358 - Mapped collection key: ud_select, one-to-many: com.axxia.pkc.core.afcl.domain.UserProfileListOption
16:24,567  INFO Configuration:865 - processing association property references
16:24,567  INFO Configuration:894 - processing foreign key constraints
16:24,567 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:24,567 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:24,816  INFO Dialect:91 - Using dialect: org.hibernate.dialect.HSQLDialect
16:24,832 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
16:24,832  INFO SettingsFactory:91 - Default batch fetch size: 1
16:24,832  INFO SettingsFactory:95 - Generate SQL with comments: disabled
16:24,832  INFO SettingsFactory:99 - Order SQL updates by primary key: disabled
16:24,832  INFO SettingsFactory:285 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
16:24,848  INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
16:24,848  INFO SettingsFactory:107 - Query language substitutions: {}
16:24,848  INFO C3P0ConnectionProvider:50 - C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:.
16:24,848  INFO C3P0ConnectionProvider:51 - Connection properties: {user=sa, password=****}
16:24,848  INFO C3P0ConnectionProvider:54 - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@e1d5ea [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@4b035d [ 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 -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@bb7759 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:., properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> e1d5ea ] 
16:25,642  INFO SettingsFactory:149 - JDBC batch size: 15
16:25,658  INFO SettingsFactory:152 - JDBC batch updates for versioned data: disabled
16:25,658  INFO SettingsFactory:157 - Scrollable result sets: enabled
16:25,658 DEBUG SettingsFactory:161 - Wrap result sets: disabled
16:25,658  INFO SettingsFactory:165 - JDBC3 getGeneratedKeys(): disabled
16:25,658  INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
16:25,658  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
16:25,674  INFO SettingsFactory:177 - Automatic flush during beforeCompletion(): disabled
16:25,674  INFO SettingsFactory:180 - Automatic session close at end of transaction: disabled
16:25,674  INFO SettingsFactory:186 - Second-level cache: enabled
16:25,674  INFO SettingsFactory:190 - Query cache: disabled
16:25,674  INFO SettingsFactory:272 - Cache provider: org.hibernate.cache.EhCacheProvider
16:25,674  INFO SettingsFactory:205 - Optimize cache for minimal puts: disabled
16:25,674  INFO SettingsFactory:214 - Structured second-level cache entries: enabled
16:25,674  INFO SettingsFactory:222 - Echoing all SQL to stdout
16:25,674  INFO SettingsFactory:226 - Statistics: disabled
16:25,674  INFO SettingsFactory:230 - Deleted entity synthetic identifier rollback: disabled
16:25,674  INFO SettingsFactory:244 - Default entity-mode: pojo
16:25,720  INFO SessionFactoryImpl:147 - building session factory
16:25,720 DEBUG SessionFactoryImpl:156 - Session factory constructed with filter configurations : {}
16:25,720 DEBUG SessionFactoryImpl:159 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=, sun.boot.library.path=C:\Program Files\Java\jre1.5.0_02\bin, java.vm.version=1.5.0_02-b09, hibernate.connection.username=sa, 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=GB, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\axxia-v3\invoice, com.axxia.util.hibernate.EntityManagerFactory-class=com.axxia.util.hibernate.testutil.TestEntityManagerFactory, java.runtime.version=1.5.0_02-b09, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.5.0_02\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\delig\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre1.5.0_02\bin;.;C:\WINDOWS\system32;C:\WINDOWS;c:\program files\imagemagick-6.1.3-q16;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Informix\Connect\bin;C:\Program Files\GnuWin32\bin;S:\pvcs\VM\Win32\Bin;C:\Java_cur_ver\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\delig, user.timezone=Europe/London, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, java.class.path=/c:/Program Files/eclipse3.1M5/eclipse/plugins/org.eclipse.jdt.junit_3.1.0/junitsupport.jar;/c:/Program Files/eclipse3.1M5/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.1.0/junitruntime.jar;C:\axxia-v3\invoice\bin;C:\axxia-v3\util\bin;C:\Program Files\eclipse3.1M5\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\axxia-v3\ThirdParties\avalon\avalon-framework-4.1.4.jar;C:\axxia-v3\ThirdParties\fop\batik.jar;C:\axxia-v3\ThirdParties\Graphs\graphs.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\c3p0-0.8.5.jar;C:\axxia-v3\ThirdParties\InformixJDBC-2.21.JC5\ifxjdbc-2.21.JC5.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils.jar;C:\axxia-v3\ThirdParties\jakarta-chain-20041108\commons-chain.jar;C:\axxia-v3\ThirdParties\jakarta-collections\commons-collections-3.1.jar;C:\axxia-v3\ThirdParties\jakarta-commons-logging\commons-logging.jar;C:\axxia-v3\ThirdParties\jakarta-digester-1.6\commons-digester.jar;C:\axxia-v3\ThirdParties\jakarta-lang\commons-lang.jar;C:\axxia-v3\ThirdParties\jakarta-log4j-1.2.5\log4j-1.2.5.jar;C:\axxia-v3\ThirdParties\jbpm.3\commons-codec-1.3.jar;C:\axxia-v3\ThirdParties\jtds-SQLServerJDBC\jtds-1.0.jar;C:\axxia-v3\ThirdParties\unittest\easymock.jar;C:\axxia-v3\ThirdParties\antlr\ognl-3.0.0-pre-2.jar;C:\axxia-v3\ThirdParties\fop\fop.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\commons-collections-2.1.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\commons-logging-1.0.4.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\concurrent-1.3.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\connector.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\dom4j-1.5.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\ehcache-1.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\hibernate3.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jaas.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jacc-1_0-fr.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jaxen-1.1-beta-4.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-cache.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-common.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-jmx.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jboss-system.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jdbc2_0-stdext.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jgroups-2.2.7.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\jta.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\oscache-2.1.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\proxool-0.8.3.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\swarmcache-1.0rc2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\versioncheck.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\xerces-2.6.2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\xml-apis.jar;C:\axxia-v3\ThirdParties\InformixJDBC-2.21.JC5\ifxjdbcx-2.21.JC5.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils-bean-collections.jar;C:\axxia-v3\ThirdParties\jakarta-beanutils\commons-beanutils-core.jar;C:\axxia-v3\ThirdParties\unittest\junit.jar;C:\axxia-v3\ThirdParties\jboss-aop-1.1.1\jboss-aspect-library-jdk50.jar;C:\axxia-v3\ThirdParties\jbpm.3\bsh-2.0b2.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\asm.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\asm-attrs.jar;C:\axxia-v3\ThirdParties\hibernate-3.0\cglib-2.1.jar;C:\axxia-v3\ThirdParties\jboss-aop-1.1.1\jboss-aop-jdk50.jar;C:\axxia-v3\ThirdParties\antlr\antlr-2.7.5H3.jar;C:\axxia-v3\ThirdParties\jbpm.3\jbpm-3.0-alpha3.jar;C:\axxia-v3\ThirdParties\jstl\jstl.jar;C:\axxia-v3\ThirdParties\jstl\standard.jar;C:\axxia-v3\ThirdParties\json-rpc\jsonrpc.jar;C:\axxia-v3\ThirdParties\hsqldb-1.7.3.3.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\jboss-j2ee.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\javax.servlet.jar;C:\jboss-4.0.1sp1\server\V3_Artiion_Informix\lib\javax.servlet.jsp.jar;C:\axxia-v3\xmlgen\bin;C:\axxia-v3\personnel\bin;C:\axxia-v3\client\bin;C:\axxia-v3\core\bin;C:\axxia-v3\file\bin;C:\axxia-v3\core\bin;C:\axxia-v3\plan\bin;C:\axxia-v3\firm\bin;C:\axxia-v3\timerecording\bin;C:\axxia-v3\PKC\bin;C:\axxia-v3\workflow\bin;C:\axxia-v3\durian\bin;C:\axxia-v3\PKCTest\bin;C:\Program Files\eclipse3.1M5\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\axxia-v3\invoice\test_src\com\axxia\invoice\hibernate, user.name=delig, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre1.5.0_02, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:., user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=5, awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, sharing, java.version=1.5.0_02, java.ext.dirs=C:\Program Files\Java\jre1.5.0_02\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.5.0_02\lib\rt.jar;C:\Program Files\Java\jre1.5.0_02\lib\i18n.jar;C:\Program Files\Java\jre1.5.0_02\lib\sunrsasign.jar;C:\Program Files\Java\jre1.5.0_02\lib\jsse.jar;C:\Program Files\Java\jre1.5.0_02\lib\jce.jar;C:\Program Files\Java\jre1.5.0_02\lib\charsets.jar;C:\Program Files\Java\jre1.5.0_02\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.hbm2ddl.auto=create, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=}
16:25,736  WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/axxia-v3/ThirdParties/hibernate-3.0/ehcache-1.1.jar!/ehcache-failsafe.xml
16:25,892 DEBUG BasicEntityPersister:2229 - Static SQL for entity: com.axxia.pkc.core.afcl.domain.UserProfile
16:25,892 DEBUG BasicEntityPersister:2231 -  Version select: select ud_colnum from causerdp where ud_colnum =?
16:25,892 DEBUG BasicEntityPersister:2232 -  Snapshot select: select userprofil_.ud_colnum, userprofil_.ud_desc as ud3_0_, userprofil_.ud_select as ud4_0_, userprofil_.ud_format as ud5_0_, userprofil_.ud_group as ud6_0_, userprofil_.ud_mandat as ud7_0_, userprofil_.ud_length as ud8_0_ from causerdp userprofil_ where userprofil_.ud_colnum=?
16:25,892 DEBUG BasicEntityPersister:2234 -  Insert 0: insert into causerdp (ud_desc, ud_select, ud_format, ud_group, ud_mandat, ud_length, ud_type, ud_colnum) values (?, ?, ?, ?, ?, ?, 'com.axxia.pkc.core.afcl.domain.UserProfile', ?)
16:25,892 DEBUG BasicEntityPersister:2235 -  Update 0: update causerdp set ud_desc=?, ud_select=?, ud_format=?, ud_group=?, ud_mandat=?, ud_length=? where ud_colnum=?
16:25,892 DEBUG BasicEntityPersister:2236 -  Delete 0: delete from causerdp where ud_colnum=?
16:26,032 DEBUG BasicEntityPersister:2229 - Static SQL for entity: com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile
16:26,032 DEBUG BasicEntityPersister:2231 -  Version select: select ud_colnum from causerdp where ud_colnum =?
16:26,032 DEBUG BasicEntityPersister:2232 -  Snapshot select: select feeearneru_.ud_colnum, feeearneru_.ud_desc as ud3_0_, feeearneru_.ud_select as ud4_0_, feeearneru_.ud_format as ud5_0_, feeearneru_.ud_group as ud6_0_, feeearneru_.ud_mandat as ud7_0_, feeearneru_.ud_length as ud8_0_ from causerdp feeearneru_ where feeearneru_.ud_colnum=?
16:26,032 DEBUG BasicEntityPersister:2234 -  Insert 0: insert into causerdp (ud_desc, ud_select, ud_format, ud_group, ud_mandat, ud_length, ud_type, ud_colnum) values (?, ?, ?, ?, ?, ?, 'FE', ?)
16:26,032 DEBUG BasicEntityPersister:2235 -  Update 0: update causerdp set ud_desc=?, ud_select=?, ud_format=?, ud_group=?, ud_mandat=?, ud_length=? where ud_colnum=?
16:26,032 DEBUG BasicEntityPersister:2236 -  Delete 0: delete from causerdp where ud_colnum=?
16:26,079 DEBUG BasicEntityPersister:2229 - Static SQL for entity: com.axxia.pkc.core.afcl.domain.UserProfileListOption
16:26,079 DEBUG BasicEntityPersister:2231 -  Version select: select ds_rectyp, ud_colnum from cadescrp where ds_rectyp =? and ud_colnum =?
16:26,079 DEBUG BasicEntityPersister:2232 -  Snapshot select: select userprofil_.ds_rectyp, userprofil_.ud_colnum, userprofil_.ds_dscrn as ds3_1_, userprofil_.ud_select as ud4_1_ from cadescrp userprofil_ where userprofil_.ds_rectyp=? and userprofil_.ud_colnum=?
16:26,079 DEBUG BasicEntityPersister:2234 -  Insert 0: insert into cadescrp (ds_dscrn, ud_select, ds_rectyp, ud_colnum) values (?, ?, ?, ?)
16:26,094 DEBUG BasicEntityPersister:2235 -  Update 0: update cadescrp set ds_dscrn=?, ud_select=? where ds_rectyp=? and ud_colnum=?
16:26,094 DEBUG BasicEntityPersister:2236 -  Delete 0: delete from cadescrp where ds_rectyp=? and ud_colnum=?
16:26,094 DEBUG AbstractCollectionPersister:479 - Static SQL for collection: com.axxia.pkc.core.afcl.domain.UserProfile.listOptions
16:26,094 DEBUG AbstractCollectionPersister:480 -  Row insert: update cadescrp set ud_select=? where ds_rectyp=? and ud_colnum=?
16:26,094 DEBUG AbstractCollectionPersister:482 -  Row delete: update cadescrp set ud_select=null where ud_select=? and ds_rectyp=? and ud_colnum=?
16:26,094 DEBUG AbstractCollectionPersister:483 -  One-shot delete: update cadescrp set ud_select=null where ud_select=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfile: select userprofil0_.ud_colnum as ud1_0_, userprofil0_.ud_desc as ud3_0_0_, userprofil0_.ud_select as ud4_0_0_, userprofil0_.ud_format as ud5_0_0_, userprofil0_.ud_group as ud6_0_0_, userprofil0_.ud_mandat as ud7_0_0_, userprofil0_.ud_length as ud8_0_0_, userprofil0_.ud_type as ud2_0_ from causerdp userprofil0_ where userprofil0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfile: select userprofil0_.ud_colnum as ud1_0_, userprofil0_.ud_desc as ud3_0_0_, userprofil0_.ud_select as ud4_0_0_, userprofil0_.ud_format as ud5_0_0_, userprofil0_.ud_group as ud6_0_0_, userprofil0_.ud_mandat as ud7_0_0_, userprofil0_.ud_length as ud8_0_0_, userprofil0_.ud_type as ud2_0_ from causerdp userprofil0_ where userprofil0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfile: select userprofil0_.ud_colnum as ud1_0_, userprofil0_.ud_desc as ud3_0_0_, userprofil0_.ud_select as ud4_0_0_, userprofil0_.ud_format as ud5_0_0_, userprofil0_.ud_group as ud6_0_0_, userprofil0_.ud_mandat as ud7_0_0_, userprofil0_.ud_length as ud8_0_0_, userprofil0_.ud_type as ud2_0_ from causerdp userprofil0_ where userprofil0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfile: select userprofil0_.ud_colnum as ud1_0_, userprofil0_.ud_desc as ud3_0_0_, userprofil0_.ud_select as ud4_0_0_, userprofil0_.ud_format as ud5_0_0_, userprofil0_.ud_group as ud6_0_0_, userprofil0_.ud_mandat as ud7_0_0_, userprofil0_.ud_length as ud8_0_0_, userprofil0_.ud_type as ud2_0_ from causerdp userprofil0_ where userprofil0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile: select feeearneru0_.ud_colnum as ud1_0_, feeearneru0_.ud_desc as ud3_0_0_, feeearneru0_.ud_select as ud4_0_0_, feeearneru0_.ud_format as ud5_0_0_, feeearneru0_.ud_group as ud6_0_0_, feeearneru0_.ud_mandat as ud7_0_0_, feeearneru0_.ud_length as ud8_0_0_ from causerdp feeearneru0_ where feeearneru0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile: select feeearneru0_.ud_colnum as ud1_0_, feeearneru0_.ud_desc as ud3_0_0_, feeearneru0_.ud_select as ud4_0_0_, feeearneru0_.ud_format as ud5_0_0_, feeearneru0_.ud_group as ud6_0_0_, feeearneru0_.ud_mandat as ud7_0_0_, feeearneru0_.ud_length as ud8_0_0_ from causerdp feeearneru0_ where feeearneru0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile: select feeearneru0_.ud_colnum as ud1_0_, feeearneru0_.ud_desc as ud3_0_0_, feeearneru0_.ud_select as ud4_0_0_, feeearneru0_.ud_format as ud5_0_0_, feeearneru0_.ud_group as ud6_0_0_, feeearneru0_.ud_mandat as ud7_0_0_, feeearneru0_.ud_length as ud8_0_0_ from causerdp feeearneru0_ where feeearneru0_.ud_colnum=?
16:26,126 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile: select feeearneru0_.ud_colnum as ud1_0_, feeearneru0_.ud_desc as ud3_0_0_, feeearneru0_.ud_select as ud4_0_0_, feeearneru0_.ud_format as ud5_0_0_, feeearneru0_.ud_group as ud6_0_0_, feeearneru0_.ud_mandat as ud7_0_0_, feeearneru0_.ud_length as ud8_0_0_ from causerdp feeearneru0_ where feeearneru0_.ud_colnum=?
16:26,141 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfileListOption: select userprofil0_.ds_rectyp as ds1_0_, userprofil0_.ud_colnum as ud2_0_, userprofil0_.ds_dscrn as ds3_1_0_, userprofil0_.ud_select as ud4_1_0_ from cadescrp userprofil0_ where userprofil0_.ds_rectyp=? and userprofil0_.ud_colnum=?
16:26,141 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfileListOption: select userprofil0_.ds_rectyp as ds1_0_, userprofil0_.ud_colnum as ud2_0_, userprofil0_.ds_dscrn as ds3_1_0_, userprofil0_.ud_select as ud4_1_0_ from cadescrp userprofil0_ where userprofil0_.ds_rectyp=? and userprofil0_.ud_colnum=?
16:26,141 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfileListOption: select userprofil0_.ds_rectyp as ds1_0_, userprofil0_.ud_colnum as ud2_0_, userprofil0_.ds_dscrn as ds3_1_0_, userprofil0_.ud_select as ud4_1_0_ from cadescrp userprofil0_ where userprofil0_.ds_rectyp=? and userprofil0_.ud_colnum=?
16:26,141 DEBUG EntityLoader:120 - Static select for entity com.axxia.pkc.core.afcl.domain.UserProfileListOption: select userprofil0_.ds_rectyp as ds1_0_, userprofil0_.ud_colnum as ud2_0_, userprofil0_.ds_dscrn as ds3_1_0_, userprofil0_.ud_select as ud4_1_0_ from cadescrp userprofil0_ where userprofil0_.ds_rectyp=? and userprofil0_.ud_colnum=?
16:26,141 DEBUG OneToManyLoader:98 - Static select for one-to-many com.axxia.pkc.core.afcl.domain.UserProfile.listOptions: select listoption0_.ud_select as ud4___, listoption0_.ds_rectyp as ds1___, listoption0_.ud_colnum as ud2___, listoption0_.ds_rectyp as ds1_0_, listoption0_.ud_colnum as ud2_0_, listoption0_.ds_dscrn as ds3_1_0_, listoption0_.ud_select as ud4_1_0_ from cadescrp listoption0_ where listoption0_.ud_select=?
16:26,157 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
16:26,157 DEBUG SessionFactoryObjectFactory:76 - registered: 8a818ac803ad6dd30103ad6dd59d0000 (unnamed)
16:26,157  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
16:26,157 DEBUG SessionFactoryImpl:256 - instantiated session factory
16:26,172  INFO Dialect:91 - Using dialect: org.hibernate.dialect.HSQLDialect
16:26,172  INFO Configuration:852 - processing extends queue
16:26,172  INFO Configuration:856 - processing collection mappings
16:26,172  INFO Configuration:865 - processing association property references
16:26,172  INFO Configuration:894 - processing foreign key constraints
16:26,172 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:26,172 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:26,172  INFO Configuration:852 - processing extends queue
16:26,172  INFO Configuration:856 - processing collection mappings
16:26,188  INFO Configuration:865 - processing association property references
16:26,188  INFO Configuration:894 - processing foreign key constraints
16:26,188 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:26,188 DEBUG Configuration:941 - resolving reference to class: com.axxia.pkc.core.afcl.domain.UserProfile
16:26,188  INFO SchemaExport:114 - Running hbm2ddl schema export
16:26,188  INFO SchemaExport:130 - exporting generated schema to database
16:26,188  INFO C3P0ConnectionProvider:50 - C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:.
16:26,188  INFO C3P0ConnectionProvider:51 - Connection properties: {user=sa, password=****}
16:26,188  INFO C3P0ConnectionProvider:54 - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@a613f8 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@589e56 [ 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 -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@472d48 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:., properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> a613f8 ] 
16:26,406 DEBUG SchemaExport:144 - alter table cadescrp drop constraint FKE7BA7A6D734981D9
16:26,593 DEBUG SchemaExport:150 - Unsuccessful: alter table cadescrp drop constraint FKE7BA7A6D734981D9
16:26,593 DEBUG SchemaExport:151 - Table not found: CADESCRP in statement [alter table cadescrp]
16:26,593 DEBUG SchemaExport:144 - alter table cadescrp drop constraint FKE7BA7A6DAF370ED8
16:26,593 DEBUG SchemaExport:150 - Unsuccessful: alter table cadescrp drop constraint FKE7BA7A6DAF370ED8
16:26,593 DEBUG SchemaExport:151 - Table not found: CADESCRP in statement [alter table cadescrp]
16:26,593 DEBUG SchemaExport:144 - drop table cadescrp if exists
16:26,593 DEBUG SchemaExport:144 - drop table causerdp if exists
16:26,593 DEBUG SchemaExport:162 - create table cadescrp (
   ds_rectyp smallint not null,
   ud_colnum varchar(8) not null,
   ds_dscrn CHAR not null,
   ud_select CHAR not null,
   primary key (ds_rectyp, ud_colnum)
)
16:26,593 DEBUG SchemaExport:162 - create table causerdp (
   ud_colnum SMALLINT not null,
   ud_type varchar(255) not null,
   ud_desc CHAR not null,
   ud_select CHAR,
   ud_format CHAR not null,
   ud_group CHAR,
   ud_mandat CHAR,
   ud_length SMALLINT not null,
   primary key (ud_colnum)
)
16:26,609 DEBUG SchemaExport:162 - alter table cadescrp add constraint FKE7BA7A6D734981D9 foreign key (ud_select) references causerdp
16:26,609 ERROR SchemaExport:168 - Unsuccessful: alter table cadescrp add constraint FKE7BA7A6D734981D9 foreign key (ud_select) references causerdp
16:26,609 ERROR SchemaExport:169 - Column types do not match in statement [alter table cadescrp add constraint FKE7BA7A6D734981D9 foreign key (ud_select) references causerdp]
16:26,609 DEBUG SchemaExport:162 - alter table cadescrp add constraint FKE7BA7A6DAF370ED8 foreign key (ds_rectyp) references causerdp
16:26,609  INFO SchemaExport:174 - schema export complete
16:26,609  INFO SessionFactoryImpl:373 - Checking 1 named queries
16:26,609 DEBUG SessionFactoryImpl:380 - Checking named query: com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile.getCount
16:26,687 DEBUG QueryTranslatorImpl:207 - parse() - HQL: 
    
      select count(*) from com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile
    
  
16:26,718 DEBUG AST:223 - --- HQL AST ---
 \-[QUERY] 'query'
    \-[SELECT_FROM] 'SELECT_FROM'
       +-[FROM] 'from'
       |  \-[RANGE] 'RANGE'
       |     \-[DOT] '.'
       |        +-[DOT] '.'
       |        |  +-[DOT] '.'
       |        |  |  +-[DOT] '.'
       |        |  |  |  +-[DOT] '.'
       |        |  |  |  |  +-[DOT] '.'
       |        |  |  |  |  |  +-[IDENT] 'com'
       |        |  |  |  |  |  \-[IDENT] 'axxia'
       |        |  |  |  |  \-[IDENT] 'pkc'
       |        |  |  |  \-[IDENT] 'personnel'
       |        |  |  \-[IDENT] 'afcl'
       |        |  \-[IDENT] 'domain'
       |        \-[IDENT] 'FeeEarnerUserProfile'
       \-[SELECT] 'select'
          \-[COUNT] 'count'
             \-[ROW_STAR] '*'

16:26,718 DEBUG ErrorCounter:72 - throwQueryException() : no errors
16:26,765 DEBUG HqlSqlBaseWalker:120 - query() << begin, level = 1
16:26,796 DEBUG FromElement:81 - FromClause{level=1} :  com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile (no alias) -> feeearneru0_
16:26,796 DEBUG HqlSqlBaseWalker:125 - query() : finishing up , level = 1
16:26,796 DEBUG HqlSqlWalker:331 - processQuery() :  ( SELECT ( {select clause} ( count * ) ) ( FromClause{level=1} causerdp feeearneru0_ ) )
16:26,811 DEBUG JoinProcessor:112 - Using FROM fragment [causerdp feeearneru0_]
16:26,811 DEBUG SyntheticAndFactory:47 - Using WHERE fragment [feeearneru0_.ud_type='FE' and feeearneru0_.ud_colnum < '500']
16:26,811 DEBUG QueryNode:44 - getWhereClause() : Creating a new WHERE clause...
16:26,811 DEBUG HqlSqlBaseWalker:128 - query() >> end, level = 1
16:26,827 DEBUG AST:193 - --- SQL AST ---
 \-[SELECT] QueryNode: 'SELECT'  querySpaces (causerdp)
    +-[SELECT_CLAUSE] SelectClause: '{select clause}'
    |  +-[COUNT] CountNode: 'count'
    |  |  \-[ROW_STAR] SqlNode: '*'
    |  \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
    +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[feeearneru0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
    |  \-[FROM_FRAGMENT] FromElement: 'causerdp feeearneru0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=causerdp,tableAlias=feeearneru0_,colums={,className=com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile}}
    \-[WHERE] SqlNode: 'WHERE'
       \-[FILTERS] SqlNode: '{filter conditions}'
          \-[SQL_TOKEN] SqlFragment: 'feeearneru0_.ud_type='FE' and feeearneru0_.ud_colnum < '500''

16:26,827 DEBUG ErrorCounter:72 - throwQueryException() : no errors
16:26,843 DEBUG QueryTranslatorImpl:177 - HQL: 
    
      select count(*) from com.axxia.pkc.personnel.afcl.domain.FeeEarnerUserProfile
    
  
16:26,843 DEBUG QueryTranslatorImpl:178 - SQL: select count(*) as col_0_0_ from causerdp feeearneru0_ where feeearneru0_.ud_type='FE' and feeearneru0_.ud_colnum < '500'
16:26,843 DEBUG ErrorCounter:72 - throwQueryException() : no errors
16:26,905 DEBUG SessionImpl:237 - opened session at timestamp: 4568294141370368
16:26,920 DEBUG AbstractBatcher:276 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
16:26,920 DEBUG AbstractBatcher:414 - opening JDBC connection
16:26,920 DEBUG SQL:310 - select this_.ud_colnum as ud1_0_, this_.ud_desc as ud3_0_0_, this_.ud_select as ud4_0_0_, this_.ud_format as ud5_0_0_, this_.ud_group as ud6_0_0_, this_.ud_mandat as ud7_0_0_, this_.ud_length as ud8_0_0_, this_.ud_type as ud2_0_ from causerdp this_ where this_.ud_colnum < '500'
Hibernate: select this_.ud_colnum as ud1_0_, this_.ud_desc as ud3_0_0_, this_.ud_select as ud4_0_0_, this_.ud_format as ud5_0_0_, this_.ud_group as ud6_0_0_, this_.ud_mandat as ud7_0_0_, this_.ud_length as ud8_0_0_, this_.ud_type as ud2_0_ from causerdp this_ where this_.ud_colnum < '500'
16:26,920 DEBUG AbstractBatcher:364 - preparing statement
16:26,952 DEBUG AbstractBatcher:292 - about to open ResultSet (open ResultSets: 0, globally: 0)
16:26,952 DEBUG Loader:382 - processing result set
16:26,967 DEBUG Loader:406 - done processing result set (0 rows)
16:26,967 DEBUG AbstractBatcher:299 - about to close ResultSet (open ResultSets: 1, globally: 1)
16:26,967 DEBUG AbstractBatcher:284 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
16:26,967 DEBUG AbstractBatcher:392 - closing statement
16:26,967 DEBUG Loader:492 - total objects hydrated: 0
16:26,967 DEBUG PersistenceContext:758 - initializing non-lazy collections
16:26,967 DEBUG Cascades:587 - id unsaved-value strategy UNDEFINED
16:26,967 DEBUG BasicEntityPersister:879 - Getting current persistent state for: [com.axxia.pkc.core.afcl.domain.UserProfileListOption#component[userProfile,listOptionCode]{listOptionCode=A Code, userProfile=com.axxia.pkc.core.afcl.domain.UserProfile#456}]
16:26,983 DEBUG AbstractBatcher:276 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
16:26,983 DEBUG SQL:310 - select userprofil_.ds_rectyp, userprofil_.ud_colnum, userprofil_.ds_dscrn as ds3_1_, userprofil_.ud_select as ud4_1_ from cadescrp userprofil_ where userprofil_.ds_rectyp=? and userprofil_.ud_colnum=?
Hibernate: select userprofil_.ds_rectyp, userprofil_.ud_colnum, userprofil_.ds_dscrn as ds3_1_, userprofil_.ud_select as ud4_1_ from cadescrp userprofil_ where userprofil_.ds_rectyp=? and userprofil_.ud_colnum=?
16:26,983 DEBUG AbstractBatcher:364 - preparing statement
16:26,983 DEBUG AbstractBatcher:284 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
16:26,983 DEBUG AbstractBatcher:392 - closing statement

vgiguere · **Posted:** Thu May 05, 2005 12:19 pm

Hi,

In your UserProfileListOption mapping, you declare your userProfile relationship to be of type UserProfile.

Yet, on your code, you set the userProfile with an instance of PersonnelUserProfile.

You probably need to modify your mapping to inform hibernate that PersonnelUserProfile is a subclass of UserProfile.

I suggest you read about inheritance mapping: http://www.hibernate.org/hib_docs/v3/re ... tance.html

eXtorn · **Posted:** Thu May 05, 2005 3:36 pm

Thanks. Ive been reading those docs quite a bit, but to be honest I find them rather overwhelming. I'm going to have another whirl at it tomorrow, so hopefully I pick up on the way to as you say; inform the hibernate engine that subclasses are being used.

eXtorn · **Posted:** Sat May 07, 2005 9:55 pm

I have discovered that there are several reasons that this is failing and though I have not yet established a fully working mapping file, I feel that noone more should reply to this topic since it is no longer of interest to me.

Admins, please remove it (I couldn't work out how to myself).