Hi,
I'm experiencing some strange behavior with polymorphism and proxies.
We have a base class MemberHDO, which is extended by either an AdministrationMemberHDO or a CorporateMemberHDO. Because we found that it wasn't possible to do certain casting operations when using the concrete classes as the proxies, we now set the proxy attribute to interfaces which are implemented by the concrete hibernate classes, eg IMemberHDO, IAdministrationMemberHDO and ICorporateMemberHDO.
I am wondering when you use the interface and when you use the concrete class. FOr example, which do you use for loads and which do you use for queries ? And the relations in your class - should they be interfaces or concrete (presumable the type of the property would be the interface)?
I would also like to know if the interface files for the subclasses also need to extend the base interface, eg IAdministrationMember extends IMemberHDO (they have all the method declarations of the base class(using xdoclet), but not the 'extends') ?
The following code crashes with a class cast exception (when calling getParentCustomer)- however it seems to crash when loading a MemberHDO, not AdministrationMemberHDO or CorporateMemberHDO. Why would this be ? I have attached 3 stack traces -
1. MemberHDO
2. CorporateMemberHDO
3. AdministrationMemberHDO
Thanks, Tom.
*****CODE*****
IMemberHDO member = (IMemberHDO) session.load(MemberHDO.class, new Long (81));
logger.debug("member=" + Hibernate.getClass(member));
logger.debug("member=" + member.getClass());
MemberDAO dao = new MemberDAO();
Hibernate.initialize(member);
Object o = hdo.getParentCustomer();
****INFO******
Hibernate 2.1.1
sql server 7.0
*********mapping docs******
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO"
table="Member"
proxy="au.com.wanews.olps.framework.database.hibernate.interfaces.IMemberHDO"
dynamic-update="false"
dynamic-insert="false"
discriminator-value="Mbr"
>
<id
name="memberId"
column="memberId"
type="long"
>
<generator class="identity">
</generator>
</id>
<discriminator
column="hibernateDiscriminator"
type="string"
/>
<property
name="userName"
type="string"
update="true"
insert="true"
column="userName"
not-null="false"
/>
<property
name="expirePassword"
type="boolean"
update="true"
insert="true"
column="expirePassword"
not-null="false"
/>
<property
name="passwordLastUpdated"
type="timestamp"
update="true"
insert="true"
column="passwordLastUpdated"
not-null="false"
/>
<property
name="hibernateDiscriminator"
type="string"
update="false"
insert="false"
column="hibernateDiscriminator"
not-null="false"
/>
<property
name="firstName"
type="string"
update="true"
insert="true"
column="firstName"
not-null="false"
/>
<property
name="lastName"
type="string"
update="true"
insert="true"
column="lastName"
not-null="false"
/>
<property
name="lastSucessfulLogon"
type="timestamp"
update="true"
insert="true"
column="lastSucessfulLogon"
not-null="false"
/>
<many-to-one
name="accountState"
class="au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccountStatusHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="accountState"
/>
<many-to-one
name="parentCustomer"
class="au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="customerID"
/>
<many-to-one
name="email"
class="au.com.wanews.olps.framework.database.hibernate.hdo.EmailAddressHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="emailId"
/>
<many-to-one
name="accessLevel"
class="au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccessLevelHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="accessLevel"
/>
<many-to-one
name="updateDetails"
class="au.com.wanews.olps.framework.database.hibernate.hdo.UpdateDetailsHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="updateId"
/>
<set
name="mailingLists"
table="memberMailingList"
lazy="true"
inverse="true"
cascade="all"
sort="unsorted"
>
<key
column="memberId"
/>
<one-to-many
class="au.com.wanews.olps.framework.database.hibernate.hdo.MemberMailingListHDO"
/>
</set>
<property
name="unsuccessfulLogonAttempt"
type="long"
update="true"
insert="true"
column="unsuccessfulLogonAttempt"
not-null="false"
/>
<property
name="password"
type="string"
update="true"
insert="true"
column="password"
not-null="false"
/>
<many-to-one
name="securityQuestionRequest"
class="au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefSecurityQuestionHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="securityQuestionRequest"
/>
<property
name="securityQuestionResponse"
type="string"
update="true"
insert="true"
column="securityQuestionResponse"
not-null="false"
/>
<one-to-one
name="activationDetails"
class="au.com.wanews.olps.framework.database.hibernate.hdo.MemberActivationDetailsHDO"
cascade="all"
outer-join="auto"
constrained="false"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-MemberHDO.xml
containing the additional properties and place it in your merge dir.
-->
<subclass
name="au.com.wanews.olps.framework.database.hibernate.hdo.AdministrationMemberHDO"
dynamic-update="false"
dynamic-insert="false"
proxy="au.com.wanews.olps.framework.database.hibernate.interfaces.IAdministrationMemberHDO"
discriminator-value="AdminMbr"
>
<property
name="position"
type="string"
update="true"
insert="true"
column="position"
not-null="false"
/>
<property
name="wanStaffId"
type="string"
update="true"
insert="true"
column="wanStaffId"
not-null="false"
/>
</subclass>
<subclass
name="au.com.wanews.olps.framework.database.hibernate.hdo.CorporateMemberHDO"
dynamic-update="false"
dynamic-insert="false"
proxy="au.com.wanews.olps.framework.database.hibernate.interfaces.ICorporateMemberHDO"
discriminator-value="CorpMbr"
>
<many-to-one
name="defaultAccount"
class="au.com.wanews.olps.framework.database.hibernate.hdo.FinanceAccountHDO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="defaultAccount"
/>
<property
name="position"
type="string"
update="true"
insert="true"
column="position"
not-null="false"
/>
</subclass>
</class>
</hibernate-mapping>
***********STACH TRACE MemberHDO ****************
0 [main] DEBUG HibernateStartup - start
71 [main] INFO net.sf.hibernate.cfg.Environment - Hibernate 2.1 rc1
91 [main] INFO net.sf.hibernate.cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, hibernate.proxool.pool_alias=pool1, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, hibernate.show_sql=true}
101 [main] INFO net.sf.hibernate.cfg.Environment - using java.io streams to persist binary types
121 [main] INFO net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
121
10245 [main] INFO net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.SybaseDialect
10245 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use outer join fetching: true
10255 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
10255 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
10275 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - using driver: weblogic.jdbc.sqlserver.SQLServerDriver at URL: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa
10285 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - connection properties: {}
10295 [main] INFO net.sf.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
10295 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
10295 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
10825 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, Isolation Level: 2
10896 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
10896 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use scrollable result sets: true
10906 [main] INFO net.sf.hibernate.cfg.SettingsFactory - echoing all SQL to stdout
10906 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Query language substitutions: {no='N', true=1, yes='Y', false=0}
10906 [main] INFO net.sf.hibernate.cfg.SettingsFactory - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
10916 [main] INFO net.sf.hibernate.cfg.Configuration - instantiating and configuring caches
10986 [main] INFO net.sf.hibernate.impl.SessionFactoryImpl - building session factory
10996 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=D:\j2sdk1.4.1\jre\bin, java.vm.version=1.4.1-rc-b19, hibernate.proxool.pool_alias=pool1, 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=AU, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\bu07219.PTSCAMS\IdeaProjects\HibernateConfig, java.runtime.version=1.4.1-rc-b19, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=D:\j2sdk1.4.1\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\HAETH0~1.TAN\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=D:\j2sdk1.4.1\bin;.;C:\WINNT\system32;C:\WINNT;C:\Program Files\CA\Dcs\DMScripting\;C:\Program Files\CA\DCS\CAWIN\;C:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\CA\pec\bin;D:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\TNGSD\BIN;D:\Program Files\CA\CCC_Harvest;d:\development\wanews\working\apache-forrest-0.5.1-src\build\dist\shbat\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;d:\Apache\bin;d:\Apache\modules;D:\JRun\connectors\apache\intel-win;C:\CA_APPSW;C:\Program Files\ATI Technologies\ATI Control Panel;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\haeth01.TANT-A01, user.timezone=GMT+08:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, java.class.path=D:\java\HibernateConfig\conf;D:\development\wanews\src\conf\hibernate;D:\development\wanews\classes;D:\java\HibernateConfig;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\lib\jaws.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\ext\dnsns.jar;D:\j2sdk1.4.1\jre\lib\ext\ldapsec.jar;D:\j2sdk1.4.1\jre\lib\ext\localedata.jar;D:\j2sdk1.4.1\jre\lib\ext\sunjce_provider.jar;D:\java\HibernateConfig\lib\hibernate2.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\dom4j.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-logging.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-collections.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\odmg.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\ehcache.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\cglib2.jar;C:\bea\weblogic81\server\lib\weblogic.jar;D:\development\wanews\lib\log4j-1.2.8.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\hibern8ide.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\pf-joi-full.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\jgraph.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\bsh-2.0b1.jar;D:\downloads\hibernate-extensions-2.0.2\tools\hibernate-tools.jar;D:\development\wanews\working\abi\jdom.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-beanutils.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-collections.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-dbcp.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-lang.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-logging.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-pool.jar, user.name=HAETH01, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=D:\j2sdk1.4.1\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.1-rc, java.ext.dirs=D:\j2sdk1.4.1\jre\lib\ext, sun.boot.class.path=D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\i18n.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
24565 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
24575 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - registered: 539a9e04fbbafb2900fbbafb5ead0000 (unnamed)
24575 [main] INFO net.sf.hibernate.impl.SessionFactoryObjectFactory - no JNDI name configured
24575 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiated session factory
24715 [main] DEBUG net.sf.hibernate.impl.SessionImpl - opened session
24816 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - begin
24816 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
24816 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
24816 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - current autocommit status:false
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
24896 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
24896 [main] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
24896 [main] DEBUG net.sf.hibernate.persister.EntityPersister - Materializing entity: [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
24906 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
24906 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - prepared statement get: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
Hibernate: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
24916 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
25316 [main] DEBUG net.sf.hibernate.type.LongType - binding '103' to parameter: 1
25376 [main] DEBUG net.sf.hibernate.loader.Loader - processing result set
25386 [main] DEBUG net.sf.hibernate.type.LongType - returning null as column: memberId0_
25386 [main] DEBUG net.sf.hibernate.loader.Loader - result row: null, 103
25386 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Mbr' as column: hibernat2_1_
25386 [main] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 103
25396 [main] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103
25396 [main] DEBUG net.sf.hibernate.type.StringType - returning 'test1000' as column: userName1_
25396 [main] DEBUG net.sf.hibernate.type.BooleanType - returning 'false' as column: expirePa4_1_
25447 [main] DEBUG net.sf.hibernate.type.TimestampType - returning '05 April 2004 21:52:25' as column: password5_1_
25447 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Mbr' as column: hibernat2_1_
25447 [main] DEBUG net.sf.hibernate.type.StringType - returning 'John' as column: firstName1_
25447 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Citizen' as column: lastName1_
25447 [main] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: lastSuce8_1_
25447 [main] DEBUG net.sf.hibernate.type.StringType - returning 'ac' as column: accountS9_1_
25447 [main] DEBUG net.sf.hibernate.type.LongType - returning '99' as column: customerID1_
25447 [main] DEBUG net.sf.hibernate.type.LongType - returning '1' as column: emailId1_
25447 [main] DEBUG net.sf.hibernate.type.StringType - returning 'wom' as column: accessL12_1_
25457 [main] DEBUG net.sf.hibernate.type.IntegerType - returning '2' as column: updateId1_
25457 [main] DEBUG net.sf.hibernate.type.LongType - returning '0' as column: unsucce14_1_
25457 [main] DEBUG net.sf.hibernate.type.StringType - returning 'test1000' as column: password1_
25457 [main] DEBUG net.sf.hibernate.type.StringType - returning 'color' as column: securit16_1_
25457 [main] DEBUG net.sf.hibernate.type.StringType - returning 'blue' as column: securit17_1_
25457 [main] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
25467 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
25467 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
25477 [main] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
25477 [main] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
25477 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccountStatusHDO#ac]
25477 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO#99]
25477 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.EmailAddressHDO#1]
25477 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccessLevelHDO#wom]
25487 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.UpdateDetailsHDO#2]
25487 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
25507 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefSecurityQuestionHDO#color]
25507 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.MemberActivationDetailsHDO#103]
25507 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.MemberActivationDetailsHDO#103]
25507 [main] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#103]
25507 [main] DEBUG net.sf.hibernate.impl.SessionImpl - initializing non-lazy collections
25507 [main] DEBUG HibernateStartup - member=class au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO
25507 [main] DEBUG HibernateStartup - member=class au.com.wanews.olps.framework.database.hibernate.interfaces.ICorporateMemberHDO$$EnhancerByCGLIB$$c10ca2a0
java.lang.ClassCastException
at au.com.wanews.olps.framework.database.hibernate.interfaces.ICorporateMemberHDO$$FastClassByCGLIB$$19c992a4.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:189)
at net.sf.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:72)
at au.com.wanews.olps.framework.database.hibernate.interfaces.ICorporateMemberHDO$$EnhancerByCGLIB$$c10ca2a0.getParentCustomer(<generated>)
at au.com.wanews.olps.framework.database.dao.MemberDAO.loadLazyReferences(MemberDAO.java:542)
at HibernateStartup.loadMember(HibernateStartup.java:617)
at HibernateStartup.run(HibernateStartup.java:109)
at HibernateStartup.main(HibernateStartup.java:69)
Exception in thread "main" Process terminated with exit code 1
***********STACK TRACE CoporateHDO ****************
0 [main] DEBUG HibernateStartup - start
71 [main] INFO net.sf.hibernate.cfg.Environment - Hibernate 2.1 rc1
91 [main] INFO net.sf.hibernate.cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, hibernate.proxool.pool_alias=pool1, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, hibernate.show_sql=true}
101 [main] INFO net.sf.hibernate.cfg.Environment - using java.io streams to persist binary types
121 [main] INFO net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
121
9885 [main] INFO net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.SybaseDialect
9895 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use outer join fetching: true
9945 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
9945 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
9965 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - using driver: weblogic.jdbc.sqlserver.SQLServerDriver at URL: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa
9965 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - connection properties: {}
9975 [main] INFO net.sf.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
9985 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
9985 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
10455 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, Isolation Level: 2
10526 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
10526 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use scrollable result sets: true
10526 [main] INFO net.sf.hibernate.cfg.SettingsFactory - echoing all SQL to stdout
10526 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Query language substitutions: {no='N', true=1, yes='Y', false=0}
10526 [main] INFO net.sf.hibernate.cfg.SettingsFactory - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
10536 [main] INFO net.sf.hibernate.cfg.Configuration - instantiating and configuring caches
10596 [main] INFO net.sf.hibernate.impl.SessionFactoryImpl - building session factory
10596 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=D:\j2sdk1.4.1\jre\bin, java.vm.version=1.4.1-rc-b19, hibernate.proxool.pool_alias=pool1, 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=AU, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\bu07219.PTSCAMS\IdeaProjects\HibernateConfig, java.runtime.version=1.4.1-rc-b19, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=D:\j2sdk1.4.1\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\HAETH0~1.TAN\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=D:\j2sdk1.4.1\bin;.;C:\WINNT\system32;C:\WINNT;C:\Program Files\CA\Dcs\DMScripting\;C:\Program Files\CA\DCS\CAWIN\;C:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\CA\pec\bin;D:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\TNGSD\BIN;D:\Program Files\CA\CCC_Harvest;d:\development\wanews\working\apache-forrest-0.5.1-src\build\dist\shbat\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;d:\Apache\bin;d:\Apache\modules;D:\JRun\connectors\apache\intel-win;C:\CA_APPSW;C:\Program Files\ATI Technologies\ATI Control Panel;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\haeth01.TANT-A01, user.timezone=GMT+08:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, java.class.path=D:\java\HibernateConfig\conf;D:\development\wanews\src\conf\hibernate;D:\development\wanews\classes;D:\java\HibernateConfig;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\lib\jaws.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\ext\dnsns.jar;D:\j2sdk1.4.1\jre\lib\ext\ldapsec.jar;D:\j2sdk1.4.1\jre\lib\ext\localedata.jar;D:\j2sdk1.4.1\jre\lib\ext\sunjce_provider.jar;D:\java\HibernateConfig\lib\hibernate2.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\dom4j.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-logging.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-collections.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\odmg.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\ehcache.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\cglib2.jar;C:\bea\weblogic81\server\lib\weblogic.jar;D:\development\wanews\lib\log4j-1.2.8.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\hibern8ide.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\pf-joi-full.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\jgraph.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\bsh-2.0b1.jar;D:\downloads\hibernate-extensions-2.0.2\tools\hibernate-tools.jar;D:\development\wanews\working\abi\jdom.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-beanutils.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-collections.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-dbcp.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-lang.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-logging.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-pool.jar, user.name=HAETH01, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=D:\j2sdk1.4.1\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.1-rc, java.ext.dirs=D:\j2sdk1.4.1\jre\lib\ext, sun.boot.class.path=D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\i18n.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
23795 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
23805 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - registered: 539a9e04fbbaf8ee00fbbaf922a50000 (unnamed)
23805 [main] INFO net.sf.hibernate.impl.SessionFactoryObjectFactory - no JNDI name configured
23805 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiated session factory
23955 [main] DEBUG net.sf.hibernate.impl.SessionImpl - opened session
23965 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - begin
23965 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
23965 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
23965 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - current autocommit status:false
23975 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#104]
23985 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#104]
23985 [main] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#104]
23985 [main] DEBUG net.sf.hibernate.persister.EntityPersister - Materializing entity: [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#104]
23985 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
23985 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - prepared statement get: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
Hibernate: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
24125 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
24325 [main] DEBUG net.sf.hibernate.type.LongType - binding '104' to parameter: 1
24526 [main] DEBUG net.sf.hibernate.loader.Loader - processing result set
24526 [main] DEBUG net.sf.hibernate.type.LongType - returning null as column: memberId0_
24526 [main] DEBUG net.sf.hibernate.loader.Loader - result row: null, 104
24536 [main] DEBUG net.sf.hibernate.type.StringType - returning 'CorpMbr' as column: hibernat2_1_
24536 [main] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 104
24536 [main] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: au.com.wanews.olps.framework.database.hibernate.hdo.CorporateMemberHDO#104
24536 [main] DEBUG net.sf.hibernate.type.LongType - returning null as column: default20_1_
24536 [main] DEBUG net.sf.hibernate.type.StringType - returning null as column: position1_
24536 [main] DEBUG net.sf.hibernate.type.StringType - returning 'test2000' as column: userName1_
24536 [main] DEBUG net.sf.hibernate.type.BooleanType - returning 'false' as column: expirePa4_1_
24576 [main] DEBUG net.sf.hibernate.type.TimestampType - returning '05 April 2004 21:52:26' as column: password5_1_
24576 [main] DEBUG net.sf.hibernate.type.StringType - returning 'CorpMbr' as column: hibernat2_1_
24576 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Paul' as column: firstName1_
24576 [main] DEBUG net.sf.hibernate.type.StringType - returning 'MacDonald' as column: lastName1_
24576 [main] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: lastSuce8_1_
24586 [main] DEBUG net.sf.hibernate.type.StringType - returning 'ac' as column: accountS9_1_
24586 [main] DEBUG net.sf.hibernate.type.LongType - returning '100' as column: customerID1_
24586 [main] DEBUG net.sf.hibernate.type.LongType - returning '2' as column: emailId1_
24586 [main] DEBUG net.sf.hibernate.type.StringType - returning 'cm' as column: accessL12_1_
24586 [main] DEBUG net.sf.hibernate.type.IntegerType - returning '4' as column: updateId1_
24586 [main] DEBUG net.sf.hibernate.type.LongType - returning '0' as column: unsucce14_1_
24586 [main] DEBUG net.sf.hibernate.type.StringType - returning 'test2000' as column: password1_
24586 [main] DEBUG net.sf.hibernate.type.StringType - returning 'color' as column: securit16_1_
24586 [main] DEBUG net.sf.hibernate.type.StringType - returning 'green' as column: securit17_1_
24606 [main] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
24606 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
24606 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
24606 [main] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
24606 [main] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [au.com.wanews.olps.framework.database.hibernate.hdo.CorporateMemberHDO#104]
24606 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccountStatusHDO#ac]
24606 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO#100]
24616 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.EmailAddressHDO#2]
24616 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefAccessLevelHDO#cm]
24616 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.UpdateDetailsHDO#4]
24616 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24636 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefSecurityQuestionHDO#color]
24636 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.MemberActivationDetailsHDO#104]
24636 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.MemberActivationDetailsHDO#104]
24636 [main] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [au.com.wanews.olps.framework.database.hibernate.hdo.CorporateMemberHDO#104]
24636 [main] DEBUG net.sf.hibernate.impl.SessionImpl - initializing non-lazy collections
24646 [main] DEBUG HibernateStartup - member=class au.com.wanews.olps.framework.database.hibernate.hdo.CorporateMemberHDO
24646 [main] DEBUG HibernateStartup - member=class au.com.wanews.olps.framework.database.hibernate.interfaces.ICorporateMemberHDO$$EnhancerByCGLIB$$820ad9d9
24656 [main] DEBUG au.com.wanews.olps.framework.database.dao.MemberDAO - hdo=class au.com.wanews.olps.framework.database.hibernate.interfaces.IAdministrationOrganisationHDO$$EnhancerByCGLIB$$6f2596ce
24656 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO#100]
24656 [main] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO#100]
24656 [main] DEBUG net.sf.hibernate.persister.NormalizedEntityPersister - Materializing entity: [au.com.wanews.olps.framework.database.hibernate.hdo.CustomerHDO#100]
24656 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
24666 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - prepared statement get: select customer0_.customerID as customerID0_, case when customer0__1_.customerID is not null then 1 when customer0__2_.customerID is not null then 2 when customer0__3_.customerID is not null then 3 when customer0_.customerID is not null then 0 end as clazz_0_, customer0_.customerType as customer2_9_0_, customer0_.phone as phone9_0_, customer0_.fax as fax9_0_, customer0__1_.organisationName as organisa2_10_0_, customer0__2_.businessName as business2_11_0_, customer0__2_.tradingName as tradingN3_11_0_, customer0__2_.abn as abn11_0_, customer0__2_.acn as acn11_0_, customer0__2_.businessSize as business6_11_0_, customer0__2_.industry as industry11_0_, customer0__2_.sector as sector11_0_, customer0__2_.websiteUrl as websiteUrl11_0_, customer0__2_.corporateWebSiteAccess as corpora10_11_0_, customer0__2_.corporateimage as corpora11_11_0_, customer0__2_.batchLodgementEnabled as batchLo12_11_0_, customer0__3_.firstName as firstName12_0_, customer0__3_.lastName as lastName12_0_, customer0__3_.phoneMobile as phoneMob4_12_0_, customer0__3_.phoneAfterHours as phoneAft5_12_0_, customer0__3_.gender as gender12_0_, customer0__3_.dateOfBirth as dateOfBi7_12_0_ from Customer customer0_ left outer join AdministrationOrganisation customer0__1_ on customer0_.customerID=customer0__1_.customerID left outer join BusinessCustomer customer0__2_ on customer0_.customerID=customer0__2_.customerID left outer join PrivateCustomer customer0__3_ on customer0_.customerID=customer0__3_.customerID where customer0_.customerID=?
Hibernate: select customer0_.customerID as customerID0_, case when customer0__1_.customerID is not null then 1 when customer0__2_.customerID is not null then 2 when customer0__3_.customerID is not null then 3 when customer0_.customerID is not null then 0 end as clazz_0_, customer0_.customerType as customer2_9_0_, customer0_.phone as phone9_0_, customer0_.fax as fax9_0_, customer0__1_.organisationName as organisa2_10_0_, customer0__2_.businessName as business2_11_0_, customer0__2_.tradingName as tradingN3_11_0_, customer0__2_.abn as abn11_0_, customer0__2_.acn as acn11_0_, customer0__2_.businessSize as business6_11_0_, customer0__2_.industry as industry11_0_, customer0__2_.sector as sector11_0_, customer0__2_.websiteUrl as websiteUrl11_0_, customer0__2_.corporateWebSiteAccess as corpora10_11_0_, customer0__2_.corporateimage as corpora11_11_0_, customer0__2_.batchLodgementEnabled as batchLo12_11_0_, customer0__3_.firstName as firstName12_0_, customer0__3_.lastName as lastName12_0_, customer0__3_.phoneMobile as phoneMob4_12_0_, customer0__3_.phoneAfterHours as phoneAft5_12_0_, customer0__3_.gender as gender12_0_, customer0__3_.dateOfBirth as dateOfBi7_12_0_ from Customer customer0_ left outer join AdministrationOrganisation customer0__1_ on customer0_.customerID=customer0__1_.customerID left outer join BusinessCustomer customer0__2_ on customer0_.customerID=customer0__2_.customerID left outer join PrivateCustomer customer0__3_ on customer0_.customerID=customer0__3_.customerID where customer0_.customerID=?
24686 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
24696 [main] DEBUG net.sf.hibernate.type.LongType - binding '100' to parameter: 1
24706 [main] DEBUG net.sf.hibernate.loader.Loader - processing result set
24706 [main] DEBUG net.sf.hibernate.loader.Loader - result row: 100
24716 [main] DEBUG net.sf.hibernate.type.IntegerType - returning '2' as column: clazz_0_
24716 [main] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 100
24716 [main] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: au.com.wanews.olps.framework.database.hibernate.hdo.BusinessCustomerHDO#100
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Beilby Executive Search Selection and Assessment' as column: business2_11_0_
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning 'Beilby' as column: tradingN3_11_0_
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning 'adsf1234' as column: abn11_0_
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning 'adsf1234' as column: acn11_0_
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning '300' as column: business6_11_0_
24716 [main] DEBUG net.sf.hibernate.type.StringType - returning 'acc' as column: industry11_0_
24806 [main] DEBUG net.sf.hibernate.type.StringType - returning 'accg' as column: sector11_0_
24806 [main] DEBUG net.sf.hibernate.type.StringType - returning 'www.beilby.com' as column: websiteUrl11_0_
24806 [main] DEBUG net.sf.hibernate.type.BooleanType - returning 'true' as column: corpora10_11_0_
24806 [main] DEBUG net.sf.hibernate.type.LongType - returning null as column: corpora11_11_0_
24806 [main] DEBUG net.sf.hibernate.type.BooleanType - returning 'true' as column: batchLo12_11_0_
24806 [main] DEBUG net.sf.hibernate.type.StringType - returning 'business.customer' as column: customer2_9_0_
24816 [main] DEBUG net.sf.hibernate.type.StringType - returning '(08) 9876 5431' as column: phone9_0_
24816 [main] DEBUG net.sf.hibernate.type.StringType - returning '(08) 9876 5432' as column: fax9_0_
24816 [main] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
24816 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
24816 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
24816 [main] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [au.com.wanews.olps.framework.database.hibernate.hdo.BusinessCustomerHDO#100]
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefBusinessSizeHDO#300]
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefIndustryHDO#acc]
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.reference.RefIndustrySectorHDO#accg]
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24826 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24836 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24836 [main] DEBUG net.sf.hibernate.impl.SessionImpl - collection not cached
24836 [main] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [au.com.wanews.olps.framework.database.hibernate.hdo.BusinessCustomerHDO#100]
24836 [main] DEBUG net.sf.hibernate.impl.SessionImpl - initializing non-lazy collections
24836 [main] DEBUG au.com.wanews.olps.framework.database.dao.MemberDAO - hdo=class au.com.wanews.olps.framework.database.hibernate.hdo.BusinessCustomerHDO
Process terminated with exit code 1
***********STACK TRACE AdministrationMemberHDO ****************
0 [main] DEBUG HibernateStartup - start
71 [main] INFO net.sf.hibernate.cfg.Environment - Hibernate 2.1 rc1
91 [main] INFO net.sf.hibernate.cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, hibernate.proxool.pool_alias=pool1, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, hibernate.show_sql=true}
101 [main] INFO net.sf.hibernate.cfg.Environment - using java.io streams to persist binary types
121 [main] INFO net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
121
7051 [main] INFO net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.SybaseDialect
7051 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use outer join fetching: true
7061 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
7061 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
7071 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - using driver: weblogic.jdbc.sqlserver.SQLServerDriver at URL: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa
7071 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - connection properties: {}
7091 [main] INFO net.sf.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
7091 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
7101 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
7421 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, Isolation Level: 2
7461 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
7461 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use scrollable result sets: true
7461 [main] INFO net.sf.hibernate.cfg.SettingsFactory - echoing all SQL to stdout
7471 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Query language substitutions: {no='N', true=1, yes='Y', false=0}
7471 [main] INFO net.sf.hibernate.cfg.SettingsFactory - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
7471 [main] INFO net.sf.hibernate.cfg.Configuration - instantiating and configuring caches
7521 [main] INFO net.sf.hibernate.impl.SessionFactoryImpl - building session factory
7521 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=D:\j2sdk1.4.1\jre\bin, java.vm.version=1.4.1-rc-b19, hibernate.proxool.pool_alias=pool1, 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=AU, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\bu07219.PTSCAMS\IdeaProjects\HibernateConfig, java.runtime.version=1.4.1-rc-b19, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=D:\j2sdk1.4.1\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\HAETH0~1.TAN\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=D:\j2sdk1.4.1\bin;.;C:\WINNT\system32;C:\WINNT;C:\Program Files\CA\Dcs\DMScripting\;C:\Program Files\CA\DCS\CAWIN\;C:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\RadView\WebLoad4.6\bin;D:\Program Files\CA\pec\bin;D:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\TNGSD\BIN;D:\Program Files\CA\CCC_Harvest;d:\development\wanews\working\apache-forrest-0.5.1-src\build\dist\shbat\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;d:\Apache\bin;d:\Apache\modules;D:\JRun\connectors\apache\intel-win;C:\CA_APPSW;C:\Program Files\ATI Technologies\ATI Control Panel;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\haeth01.TANT-A01, user.timezone=GMT+08:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=weblogic.jdbc.sqlserver.SQLServerDriver, java.class.path=D:\java\HibernateConfig\conf;D:\development\wanews\src\conf\hibernate;D:\development\wanews\classes;D:\java\HibernateConfig;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\lib\jaws.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\ext\dnsns.jar;D:\j2sdk1.4.1\jre\lib\ext\ldapsec.jar;D:\j2sdk1.4.1\jre\lib\ext\localedata.jar;D:\j2sdk1.4.1\jre\lib\ext\sunjce_provider.jar;D:\java\HibernateConfig\lib\hibernate2.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\dom4j.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-logging.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\commons-collections.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\odmg.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\ehcache.jar;D:\java\HibernateConfig\hibernate-2.1rc1\hibernate-2.1\lib\cglib2.jar;C:\bea\weblogic81\server\lib\weblogic.jar;D:\development\wanews\lib\log4j-1.2.8.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\hibern8ide.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\pf-joi-full.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\jgraph.jar;D:\downloads\hibernate-extensions-2.0.2\hibern8ide\lib\bsh-2.0b1.jar;D:\downloads\hibernate-extensions-2.0.2\tools\hibernate-tools.jar;D:\development\wanews\working\abi\jdom.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-beanutils.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-collections.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-dbcp.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-lang.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-logging.jar;D:\java\hibernate\hibernate-2.0.1\hibernate-2.0\lib\commons-pool.jar, user.name=HAETH01, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=D:\j2sdk1.4.1\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.SybaseDialect, hibernate.connection.url=jdbc:bea:sqlserver://haeth01:1433;PortNumber=1433;ServerName=haeth01;DatabaseName=cnn;user=sa;password=sa, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.1-rc, java.ext.dirs=D:\j2sdk1.4.1\jre\lib\ext, sun.boot.class.path=D:\j2sdk1.4.1\jre\lib\rt.jar;D:\j2sdk1.4.1\jre\lib\i18n.jar;D:\j2sdk1.4.1\jre\lib\sunrsasign.jar;D:\j2sdk1.4.1\jre\lib\jsse.jar;D:\j2sdk1.4.1\jre\lib\jce.jar;D:\j2sdk1.4.1\jre\lib\charsets.jar;D:\j2sdk1.4.1\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
17325 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
17335 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - registered: 539a9e04fbbb490100fbbb49277d0000 (unnamed)
17335 [main] INFO net.sf.hibernate.impl.SessionFactoryObjectFactory - no JNDI name configured
17335 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiated session factory
17435 [main] DEBUG net.sf.hibernate.impl.SessionImpl - opened session
17435 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - begin
17435 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
17435 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
17435 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - current autocommit status:false
17435 [main] DEBUG net.sf.hibernate.impl.SessionImpl - loading [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#105]
17446 [main] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#105]
17446 [main] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#105]
17446 [main] DEBUG net.sf.hibernate.persister.EntityPersister - Materializing entity: [au.com.wanews.olps.framework.database.hibernate.hdo.MemberHDO#105]
17456 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
17456 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - prepared statement get: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
Hibernate: select memberhd0_.memberId as memberId1_, memberhd0_.hibernateDiscriminator as hibernat2_1_, memberhd0_.userName as userName1_, memberhd0_.expirePassword as expirePa4_1_, memberhd0_.passwordLastUpdated as password5_1_, memberhd0_.firstName as firstName1_, memberhd0_.lastName as lastName1_, memberhd0_.lastSucessfulLogon as lastSuce8_1_, memberhd0_.accountState as accountS9_1_, memberhd0_.customerID as customerID1_, memberhd0_.emailId as emailId1_, memberhd0_.accessLevel as accessL12_1_, memberhd0_.updateId as updateId1_, memberhd0_.unsuccessfulLogonAttempt as unsucce14_1_, memberhd0_.password as password1_, memberhd0_.securityQuestionRequest as securit16_1_, memberhd0_.securityQuestionResponse as securit17_1_, memberhd0_.position as position1_, memberhd0_.wanStaffId as wanStaffId1_, memberhd0_.defaultAccount as default20_1_, memberac1_.memberId as memberId0_, memberac1_.activationExpiry as activati2_0_, memberac1_.activationCode as activati3_0_ from Member memberhd0_ left outer join MemberActivationDetails memberac1_ on memberhd0_.memberId=memberac1_.memberId where memberhd0_.memberId=?
17466 [
Login
FAQ
Search