The query compiles and executes just fine.
However, when it's pulling the values from the resultset, Hibernate requests the value of a column using a name that isn't present in the generated SQL. This causes an SQLException to be thrown by the Oracle JDBC driver.
This is a super-long post, but I tried to include all information that could possibly be useful.
Hibernate version:
3.1.2, duplicated with 3.2.5ga
Mapping documents:
Group and Contact both subclass Party, and here's the mapping file for both:
Code:
<hibernate-mapping>
<class name="com.sas.mis.cdhub.hibernate.Party" table="party" batch-size="500" abstract="true">
<id name="partyId" type="java.lang.Long">
<column name="party_id" />
<generator class="sequence">
<param name="sequence">party_sequence</param>
</generator>
</id>
<discriminator column="party_type" type="string"/>
<property name="mailPreferenceFlg" type="string">
<column name="mail_preference_flg" length="1" />
</property>
<property name="mailReasonCd" type="string">
<column name="mail_reason_cd" length="30" />
</property>
<property name="emailPreferenceFlg" type="string">
<column name="email_preference_flg" length="1" />
</property>
<property name="emailReasonCd" type="string">
<column name="email_reason_cd" length="30" />
</property>
<property name="preferredEmailFormat" type="string">
<column name="preferred_email_format" length="30" />
</property>
<property name="preferredCommMethod" type="string">
<column name="preferred_comm_method" length="30" />
</property>
<property name="secondaryCommMethod" type="string">
<column name="secondary_comm_method" length="30" />
</property>
<property name="notesTxt" type="string">
<column name="notes_txt" length="1000" />
</property>
<property name="languagePreferenceCd" type="string">
<column name="language_preference_cd" length="30" />
</property>
<property name="creationDttm" type="timestamp">
<column name="creation_dttm" length="23" />
</property>
<property name="createdBy" type="string">
<column name="created_by" length="15" />
</property>
<property name="lastUpdateDttm" type="timestamp">
<column name="last_update_dttm" length="23" />
</property>
<property name="lastUpdatedBy" type="string">
<column name="last_updated_by" length="15" />
</property>
<property name="countryOfOrigin" type="string">
<column name="country_of_origin" length="3" />
</property>
<property name="status" type="string">
<column name="status" length="1" />
</property>
<property name="validatedFlg" type="string">
<column name="validated_flg" length="1" />
</property>
<property name="createdBySystemCd" type="string">
<column name="created_by_system_cd" length="15" />
</property>
<property name="lastUpdatedBySystemCd" type="string">
<column name="last_updated_by_system_cd" length="15" />
</property>
<set name="enrichmentDataSources" inverse="true" batch-size="500">
<key>
<column name="entity_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.EnrichmentDatasource" />
</set>
<set name="partyXTags" inverse="true">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.PartyXTag" />
</set>
<set name="emails" inverse="true" batch-size="500">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Email" />
</set>
<one-to-one name="defaultPrimaryEmail" property-ref="defaultPrimaryEmail">
<formula>party_id</formula>
<formula>'Y'</formula>
</one-to-one>
<set name="urls" inverse="true" batch-size="500">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Url" />
</set>
<one-to-one name="defaultPrimaryUrl" property-ref="defaultPrimaryUrl">
<formula>party_id</formula>
<formula>'Y'</formula>
</one-to-one>
<set name="addresses" inverse="true" batch-size="500">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Address" />
</set>
<one-to-one name="defaultPrimaryAddress" property-ref="defaultPrimaryAddress">
<formula>party_id</formula>
<formula>'Y'</formula>
</one-to-one>
<set name="phones" inverse="true" batch-size="500">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Phone" />
</set>
<one-to-one name="defaultPrimaryPhone" property-ref="defaultPrimaryPhone">
<formula>party_id</formula>
<formula>'Y'</formula>
</one-to-one>
<set name="relationshipsAsSubject" inverse="true">
<key>
<column name="subject_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Relationship" />
</set>
<set name="relationshipsAsObject" inverse="true">
<key>
<column name="object_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.Relationship" />
</set>
<subclass name="com.sas.mis.cdhub.hibernate.Contact" discriminator-value="CONTACT">
<set name="crossReferences" inverse="true">
<key>
<column name="contact_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.xref.ContactXref" />
</set>
<set name="jobTitles" inverse="true" batch-size="500">
<key>
<column name="contact_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.JobTitle" />
</set>
<set name="contactAddressRelationships" inverse="true" batch-size="500">
<key>
<column name="party_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.ContactAddressRelationship" />
</set>
<join table="contact">
<key column="party_id"/>
<property name="contactType" type="string">
<column name="contact_type" length="15" />
</property>
<many-to-one name="relationship" class="com.sas.mis.cdhub.hibernate.Relationship" fetch="select" unique="true">
<column name="relationship_id" unique="true" not-null="true" />
</many-to-one>
<property name="department" type="string">
<column name="department" length="60" />
</property>
<property name="roomNum" type="string">
<column name="room_num" length="50" />
</property>
<property name="goneReasonCd" type="string">
<column name="gone_reason_cd" length="30" />
</property>
<property name="assistantNm" type="string">
<column name="assistant_nm" length="300" />
</property>
</join>
</subclass>
<subclass name="com.sas.mis.cdhub.hibernate.Group" discriminator-value="GROUP">
<set name="crossReferences" inverse="true">
<key>
<column name="group_id" not-null="true" />
</key>
<one-to-many class="com.sas.mis.cdhub.hibernate.xref.GroupXref" />
</set>
<join table="group_party">
<key column="party_id"/>
<property name="groupNm" type="string">
<column name="group_nm" length="360" />
</property>
</join>
</subclass>
</class>
</hibernate-mapping>
Lots, 'cause sessions are bound to transactions, which are demarcated around higher-level service methods using Spring AOP. But the relevant HQL query that's failing is as follows:
Code:
select contact, subj, rel
from com.sas.mis.cdhub.hibernate.Contact as contact
join contact.relationship as rel
join fetch rel.subject as subj,
com.sas.mis.cdhub.hibernate.Group groupParty
where
subj=groupParty
and nls_upper(groupParty.groupNm, 'NLS_SORT = GENERIC_M') like :groupPartygroupNm0
order by groupParty.groupNm
Full stack trace of any exception that occurs:Code:
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.sas.mis.cdhub.dao.SearchDAO.findGroupContactByName(SearchDAO.java:1436)
at com.sas.mis.cdhub.service.SearchServiceImpl.findGroupContactByName(SearchServiceImpl.java:673)
at com.sas.mis.cdhub.service.SearchServiceImpl.findGroupContactByName(SearchServiceImpl.java:664)
at com.sas.mis.cdhub.service.TestSearchService.testFindGroupContactByName(TestSearchService.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:164)
at junit.framework.TestCase.runBare(TestCase.java:130)
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:120)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3295)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1575)
at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:239)
at org.hibernate.type.LongType.get(LongType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1097)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:565)
at org.hibernate.loader.Loader.doQuery(Loader.java:701)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 27 more
Name and version of the database you are using:Oracle, version 10 I think
The generated SQL (show_sql=true):Code:
select
*
from
( select
contact0_.party_id as party1_24_0_,
party2_.party_id as party1_24_1_,
relationsh1_.relationship_id as relation1_40_2_,
party2_.party_id as party1_24_3_,
contact0_.mail_preference_flg as mail3_24_0_,
contact0_.mail_reason_cd as mail4_24_0_,
contact0_.email_preference_flg as email5_24_0_,
contact0_.email_reason_cd as email6_24_0_,
contact0_.preferred_email_format as preferred7_24_0_,
contact0_.preferred_comm_method as preferred8_24_0_,
contact0_.secondary_comm_method as secondary9_24_0_,
contact0_.notes_txt as notes10_24_0_,
contact0_.language_preference_cd as language11_24_0_,
contact0_.creation_dttm as creation12_24_0_,
contact0_.created_by as created13_24_0_,
contact0_.last_update_dttm as last14_24_0_,
contact0_.last_updated_by as last15_24_0_,
contact0_.country_of_origin as country16_24_0_,
contact0_.status as status24_0_,
contact0_.validated_flg as validated18_24_0_,
contact0_.created_by_system_cd as created19_24_0_,
contact0_.last_updated_by_system_cd as last20_24_0_,
contact0_1_.contact_type as contact2_27_0_,
contact0_1_.relationship_id as relation3_27_0_,
contact0_1_.department as department27_0_,
contact0_1_.room_num as room5_27_0_,
contact0_1_.gone_reason_cd as gone6_27_0_,
contact0_1_.assistant_nm as assistant7_27_0_,
contact0_.party_id as formula0_0_,
'Y' as formula1_0_,
contact0_.party_id as formula2_0_,
'Y' as formula3_0_,
contact0_.party_id as formula4_0_,
'Y' as formula5_0_,
contact0_.party_id as formula6_0_,
'Y' as formula7_0_,
party2_.mail_preference_flg as mail3_24_1_,
party2_.mail_reason_cd as mail4_24_1_,
party2_.email_preference_flg as email5_24_1_,
party2_.email_reason_cd as email6_24_1_,
party2_.preferred_email_format as preferred7_24_1_,
party2_.preferred_comm_method as preferred8_24_1_,
party2_.secondary_comm_method as secondary9_24_1_,
party2_.notes_txt as notes10_24_1_,
party2_.language_preference_cd as language11_24_1_,
party2_.creation_dttm as creation12_24_1_,
party2_.created_by as created13_24_1_,
party2_.last_update_dttm as last14_24_1_,
party2_.last_updated_by as last15_24_1_,
party2_.country_of_origin as country16_24_1_,
party2_.status as status24_1_,
party2_.validated_flg as validated18_24_1_,
party2_.created_by_system_cd as created19_24_1_,
party2_.last_updated_by_system_cd as last20_24_1_,
party2_1_.native_language_nm as native2_25_1_,
party2_1_.category_cd as category3_25_1_,
party2_1_.VAT_Number as VAT4_25_1_,
party2_1_.stock_cd as stock5_25_1_,
party2_1_.line_of_business as line6_25_1_,
party2_1_.out_of_business_flg as out7_25_1_,
party2_1_.incorporation_st as incorpor8_25_1_,
party2_1_.headquarters_st as headquar9_25_1_,
party2_2_.first_nm as first2_26_1_,
party2_2_.middle_nm as middle3_26_1_,
party2_2_.last_nm as last4_26_1_,
party2_2_.prefix_title as prefix5_26_1_,
party2_2_.suffix as suffix26_1_,
party2_2_.previous_last_nm as previous7_26_1_,
party2_2_.gender as gender26_1_,
party2_2_.nickname as nickname26_1_,
party2_3_.contact_type as contact2_27_1_,
party2_3_.relationship_id as relation3_27_1_,
party2_3_.department as department27_1_,
party2_3_.room_num as room5_27_1_,
party2_3_.gone_reason_cd as gone6_27_1_,
party2_3_.assistant_nm as assistant7_27_1_,
party2_4_.group_nm as group2_28_1_,
party2_.party_id as formula0_1_,
'Y' as formula1_1_,
party2_.party_id as formula2_1_,
'Y' as formula3_1_,
party2_.party_id as formula4_1_,
'Y' as formula5_1_,
party2_.party_id as formula6_1_,
'Y' as formula7_1_,
party2_.party_type as party2_24_1_,
relationsh1_.subject_id as subject2_40_2_,
relationsh1_.object_id as object3_40_2_,
relationsh1_.relationship_type as relation4_40_2_,
relationsh1_.creation_dttm as creation5_40_2_,
relationsh1_.created_by as created6_40_2_,
relationsh1_.last_update_dttm as last7_40_2_,
relationsh1_.last_updated_by as last8_40_2_,
relationsh1_.country_of_origin as country9_40_2_,
relationsh1_.status as status40_2_,
relationsh1_.created_by_system_cd as created11_40_2_,
relationsh1_.last_updated_by_system_cd as last12_40_2_,
party2_.mail_preference_flg as mail3_24_3_,
party2_.mail_reason_cd as mail4_24_3_,
party2_.email_preference_flg as email5_24_3_,
party2_.email_reason_cd as email6_24_3_,
party2_.preferred_email_format as preferred7_24_3_,
party2_.preferred_comm_method as preferred8_24_3_,
party2_.secondary_comm_method as secondary9_24_3_,
party2_.notes_txt as notes10_24_3_,
party2_.language_preference_cd as language11_24_3_,
party2_.creation_dttm as creation12_24_3_,
party2_.created_by as created13_24_3_,
party2_.last_update_dttm as last14_24_3_,
party2_.last_updated_by as last15_24_3_,
party2_.country_of_origin as country16_24_3_,
party2_.status as status24_3_,
party2_.validated_flg as validated18_24_3_,
party2_.created_by_system_cd as created19_24_3_,
party2_.last_updated_by_system_cd as last20_24_3_,
party2_1_.native_language_nm as native2_25_3_,
party2_1_.category_cd as category3_25_3_,
party2_1_.VAT_Number as VAT4_25_3_,
party2_1_.stock_cd as stock5_25_3_,
party2_1_.line_of_business as line6_25_3_,
party2_1_.out_of_business_flg as out7_25_3_,
party2_1_.incorporation_st as incorpor8_25_3_,
party2_1_.headquarters_st as headquar9_25_3_,
party2_2_.first_nm as first2_26_3_,
party2_2_.middle_nm as middle3_26_3_,
party2_2_.last_nm as last4_26_3_,
party2_2_.prefix_title as prefix5_26_3_,
party2_2_.suffix as suffix26_3_,
party2_2_.previous_last_nm as previous7_26_3_,
party2_2_.gender as gender26_3_,
party2_2_.nickname as nickname26_3_,
party2_3_.contact_type as contact2_27_3_,
party2_3_.relationship_id as relation3_27_3_,
party2_3_.department as department27_3_,
party2_3_.room_num as room5_27_3_,
party2_3_.gone_reason_cd as gone6_27_3_,
party2_3_.assistant_nm as assistant7_27_3_,
party2_4_.group_nm as group2_28_3_,
party2_.party_id as formula0_3_,
'Y' as formula1_3_,
party2_.party_id as formula2_3_,
'Y' as formula3_3_,
party2_.party_id as formula4_3_,
'Y' as formula5_3_,
party2_.party_id as formula6_3_,
'Y' as formula7_3_,
party2_.party_type as party2_24_3_
from
party contact0_
inner join
contact contact0_1_
on contact0_.party_id=contact0_1_.party_id
inner join
relationship relationsh1_
on contact0_1_.relationship_id=relationsh1_.relationship_id
inner join
party party2_
on relationsh1_.subject_id=party2_.party_id
left outer join
company party2_1_
on party2_.party_id=party2_1_.party_id
left outer join
person party2_2_
on party2_.party_id=party2_2_.party_id
left outer join
contact party2_3_
on party2_.party_id=party2_3_.party_id
left outer join
group_party party2_4_
on party2_.party_id=party2_4_.party_id,
party group3_
inner join
group_party group3_1_
on group3_.party_id=group3_1_.party_id
where
contact0_.party_type='CONTACT'
and group3_.party_type='GROUP'
and party2_.party_id=group3_.party_id
and (
nls_upper(group3_1_.group_nm, 'NLS_SORT = GENERIC_M') like ?
)
order by
group3_1_.group_nm )
where
rownum <= ?
Debug level Hibernate log excerpt:
[code]
18672 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - parse() - HQL: select contact, subj, rel from com.sas.mis.cdhub.hibernate.Contact as contact join contact.relationship as rel join fetch rel.subject as subj, com.sas.mis.cdhub.hibernate.Group groupParty where subj=groupParty and nls_upper(groupParty.groupNm, 'NLS_SORT = GENERIC_M') like :groupPartygroupNm0 order by groupParty.groupNm
18688 [main] DEBUG org.hibernate.hql.ast.HqlParser - weakKeywords() : new LT(1) token - ["Group",<120> previously: <24>,line=1,col=173,possibleID=true]
18703 [main] DEBUG org.hibernate.hql.ast.AST - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'com'
| | | | | | | | \-[IDENT] 'sas'
| | | | | | | \-[IDENT] 'mis'
| | | | | | \-[IDENT] 'cdhub'
| | | | | \-[IDENT] 'hibernate'
| | | | \-[IDENT] 'Contact'
| | | \-[ALIAS] 'contact'
| | +-[JOIN] 'join'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'contact'
| | | | \-[IDENT] 'relationship'
| | | \-[ALIAS] 'rel'
| | +-[JOIN] 'join'
| | | +-[FETCH] 'fetch'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'rel'
| | | | \-[IDENT] 'subject'
| | | \-[ALIAS] 'subj'
| | \-[RANGE] 'RANGE'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'sas'
| | | | | | \-[IDENT] 'mis'
| | | | | \-[IDENT] 'cdhub'
| | | | \-[IDENT] 'hibernate'
| | | \-[IDENT] 'Group'
| | \-[ALIAS] 'groupParty'
| \-[SELECT] 'select'
| +-[IDENT] 'contact'
| +-[IDENT] 'subj'
| \-[IDENT] 'rel'
+-[WHERE] 'where'
| \-[AND] 'and'
| +-[EQ] '='
| | +-[IDENT] 'subj'
| | \-[IDENT] 'groupParty'
| \-[LIKE] 'like'
| +-[METHOD_CALL] '('
| | +-[IDENT] 'nls_upper'
| | \-[EXPR_LIST] 'exprList'
| | +-[DOT] '.'
| | | +-[IDENT] 'groupParty'
| | | \-[IDENT] 'groupNm'
| | \-[QUOTED_STRING] ''NLS_SORT = GENERIC_M''
| \-[COLON] ':'
| \-[IDENT] 'groupPartygroupNm0'
\-[ORDER] 'order'
\-[DOT] '.'
+-[IDENT] 'groupParty'
\-[IDENT] 'groupNm'
18703 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
18766 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - select << begin [level=1, statement=select]
18813 [main] DEBUG org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : com.sas.mis.cdhub.hibernate.Contact (contact) -> contact0_
18813 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : contact -> contact0_.party_id
18813 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - getDataType() : relationship -> org.hibernate.type.ManyToOneType(com.sas.mis.cdhub.hibernate.Relationship)
18813 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - dereferenceEntityJoin() : generating join for relationship in com.sas.mis.cdhub.hibernate.Contact (rel) parent = [ {null} ]
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : com.sas.mis.cdhub.hibernate.Relationship (rel) -> relationsh1_
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromClause - addJoinByPathMap() : contact.relationship -> relationship relationsh1_
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : contact.relationship -> contact0_1_.relationship_id
18828 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'relationship relationsh1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=rel,role=null,tableName=relationship,tableAlias=relationsh1_,origin=party contact0_,colums={contact0_1_.relationship_id ,className=com.sas.mis.cdhub.hibernate.Relationship}}
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : rel -> relationsh1_.relationship_id
18828 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - getDataType() : subject -> org.hibernate.type.ManyToOneType(com.sas.mis.cdhub.hibernate.Party)
18828 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - dereferenceEntityJoin() : generating join for subject in com.sas.mis.cdhub.hibernate.Relationship (subj) parent = [ {null} ]
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : com.sas.mis.cdhub.hibernate.Party (subj) -> party2_
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromClause - addJoinByPathMap() : rel.subject -> party party2_
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : rel.subject -> relationsh1_.subject_id
18828 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'party party2_' FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=subj,role=null,tableName=party,tableAlias=party2_,origin=relationship relationsh1_,colums={relationsh1_.subject_id ,className=com.sas.mis.cdhub.hibernate.Party}}
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : com.sas.mis.cdhub.hibernate.Group (groupParty) -> group3_
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : contact -> contact0_.party_id
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : subj -> party2_.party_id
18828 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : rel -> relationsh1_.relationship_id
18844 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : subj -> party2_.party_id
18844 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : groupParty -> group3_.party_id
18844 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : groupParty -> group3_.party_id
18844 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - getDataType() : groupNm -> org.hibernate.type.StringType@a6aa31
18844 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : groupParty.groupNm -> group3_1_.group_nm
18859 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : groupParty -> group3_.party_id
18859 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - getDataType() : groupNm -> org.hibernate.type.StringType@a6aa31
18859 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : groupParty.groupNm -> group3_1_.group_nm
18859 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - select : finishing up [level=1, statement=select]
18859 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - processQuery() : ( SELECT ( {select clause} contact0_.party_id party2_.party_id relationsh1_.relationship_id ) ( FromClause{level=1} ( party contact0_ ( relationship relationsh1_ party party2_ ) ) party group3_ ) ( where ( and ( = party2_.party_id group3_.party_id ) ( like ( ( nls_upper ( exprList ( group3_1_.group_nm group3_.party_id groupNm ) 'NLS_SORT = GENERIC_M' ) ) ? ) ) ) ( order ( group3_1_.group_nm group3_.party_id groupNm ) ) )
18859 [main] DEBUG org.hibernate.hql.ast.util.JoinProcessor - Using FROM fragment [party contact0_ inner join contact contact0_1_ on contact0_.party_id=contact0_1_.party_id]
18859 [main] DEBUG org.hibernate.hql.ast.util.SyntheticAndFactory - Using WHERE fragment [contact0_.party_type='CONTACT']
18859 [main] DEBUG org.hibernate.hql.ast.util.JoinProcessor - Using FROM fragment [inner join relationship relationsh1_ on contact0_1_.relationship_id=relationsh1_.relationship_id]
18859 [main] DEBUG org.hibernate.hql.ast.util.JoinProcessor - Using FROM fragment [inner join party party2_ on relationsh1_.subject_id=party2_.party_id left outer join company party2_1_ on party2_.party_id=party2_1_.party_id left outer join person party2_2_ on party2_.party_id=party2_2_.party_id left outer join contact party2_3_ on party2_.party_id=party2_3_.party_id left outer join group_party party2_4_ on party2_.party_id=party2_4_.party_id]
18859 [main] DEBUG org.hibernate.hql.ast.util.JoinProcessor - Using FROM fragment [party group3_ inner join group_party group3_1_ on group3_.party_id=group3_1_.party_id]
18859 [main] DEBUG org.hibernate.hql.ast.util.SyntheticAndFactory - Using WHERE fragment [group3_.party_type='GROUP']
18859 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - select >> end [level=1, statement=select]
18875 [main] DEBUG org.hibernate.hql.ast.AST - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (group_party,contact,party,relationship)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[ALIAS_REF] IdentNode: 'contact0_.party_id as party1_24_0_' {alias=contact, className=com.sas.mis.cdhub.hibernate.Contact, tableAlias=contact0_}
| +-[ALIAS_REF] IdentNode: 'party2_.party_id as party1_24_1_' {alias=subj, className=com.sas.mis.cdhub.hibernate.Party, tableAlias=party2_}
| +-[ALIAS_REF] IdentNode: 'relationsh1_.relationship_id as relation1_40_2_' {alias=rel, className=com.sas.mis.cdhub.hibernate.Relationship, tableAlias=relationsh1_}
| +-[SELECT_EXPR] SelectExpressionImpl: 'party2_.party_id as party1_24_3_' {FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=subj,role=null,tableName=party,tableAlias=party2_,origin=inner join relationship relationsh1_ on contact0_1_.relationship_id=relationsh1_.relationship_id,colums={relationsh1_.subject_id ,className=com.sas.mis.cdhub.hibernate.Party}}}
| +-[SQL_TOKEN] SqlFragment: 'contact0_.mail_preference_flg as mail3_24_0_, contact0_.mail_reason_cd as mail4_24_0_, contact0_.email_preference_flg as email5_24_0_, contact0_.email_reason_cd as email6_24_0_, contact0_.preferred_email_format as preferred7_24_0_, contact0_.preferred_comm_method as preferred8_24_0_, contact0_.secondary_comm_method as secondary9_24_0_, contact0_.notes_txt as notes10_24_0_, contact0_.language_preference_cd as language11_24_0_, contact0_.creation_dttm as creation12_24_0_, contact0_.created_by as created13_24_0_, contact0_.last_update_dttm as last14_24_0_, contact0_.last_updated_by as last15_24_0_, contact0_.country_of_origin as country16_24_0_, contact0_.status as status24_0_, contact0_.validated_flg as validated18_24_0_, contact0_.created_by_system_cd as created19_24_0_, contact0_.last_updated_by_system_cd as last20_24_0_, contact0_1_.contact_type as contact2_27_0_, contact0_1_.relationship_id as relation3_27_0_, contact0_1_.department as department27_0_, contact0_1_.room_num as room5_27_0_, contact0_1_.gone_reason_cd as gone6_27_0_, contact0_1_.assistant_nm as assistant7_27_0_, contact0_.party_id as formula0_0_, 'Y' as formula1_0_, contact0_.party_id as formula2_0_, 'Y' as formula3_0_, contact0_.party_id as formula4_0_, 'Y' as formula5_0_, contact0_.party_id as formula6_0_, 'Y' as formula7_0_'
| +-[SQL_TOKEN] SqlFragment: 'party2_.mail_preference_flg as mail3_24_1_, party2_.mail_reason_cd as mail4_24_1_, party2_.email_preference_flg as email5_24_1_, party2_.email_reason_cd as email6_24_1_, party2_.preferred_email_format as preferred7_24_1_, party2_.preferred_comm_method as preferred8_24_1_, party2_.secondary_comm_method as secondary9_24_1_, party2_.notes_txt as notes10_24_1_, party2_.language_preference_cd as language11_24_1_, party2_.creation_dttm as creation12_24_1_, party2_.created_by as created13_24_1_, party2_.last_update_dttm as last14_24_1_, party2_.last_updated_by as last15_24_1_, party2_.country_of_origin as country16_24_1_, party2_.status as status24_1_, party2_.validated_flg as validated18_24_1_, party2_.created_by_system_cd as created19_24_1_, party2_.last_updated_by_system_cd as last20_24_1_, party2_1_.native_language_nm as native2_25_1_, party2_1_.category_cd as category3_25_1_, party2_1_.VAT_Number as VAT4_25_1_, party2_1_.stock_cd as stock5_25_1_, party2_1_.line_of_business as line6_25_1_, party2_1_.out_of_business_flg as out7_25_1_, party2_1_.incorporation_st as incorpor8_25_1_, party2_1_.headquarters_st as headquar9_25_1_, party2_2_.first_nm as first2_26_1_, party2_2_.middle_nm as middle3_26_1_, party2_2_.last_nm as last4_26_1_, party2_2_.prefix_title as prefix5_26_1_, party2_2_.suffix as suffix26_1_, party2_2_.previous_last_nm as previous7_26_1_, party2_2_.gender as gender26_1_, party2_2_.nickname as nickname26_1_, party2_3_.contact_type as contact2_27_1_, party2_3_.relationship_id as relation3_27_1_, party2_3_.department as department27_1_, party2_3_.room_num as room5_27_1_, party2_3_.gone_reason_cd as gone6_27_1_, party2_3_.assistant_nm as assistant7_27_1_, party2_4_.group_nm as group2_28_1_, party2_.party_id as formula0_1_, 'Y' as formula1_1_, party2_.party_id as formula2_1_, 'Y' as formula3_1_, party2_.party_id as formula4_1_, 'Y' as formula5_1_, party2_.party_id as formula6_1_, 'Y' as formula7_1_, party2_.party_type as party2_24_1_'
| +-[SQL_TOKEN] SqlFragment: 'relationsh1_.subject_id as subject2_40_2_, relationsh1_.object_id as object3_40_2_, relationsh1_.relationship_type as relation4_40_2_, relationsh1_.creation_dttm as creation5_40_2_, relationsh1_.created_by as created6_40_2_, relationsh1_.last_update_dttm as last7_40_2_, relationsh1_.last_updated_by as last8_40_2_, relationsh1_.country_of_origin as country9_40_2_, relationsh1_.status as status40_2_, relationsh1_.created_by_system_cd as created11_40_2_, relationsh1_.last_updated_by_system_cd as last12_40_2_'
| \-[SQL_TOKEN] SqlFragment: 'party2_.mail_preference_flg as mail3_24_3_, party2_.mail_reason_cd as mail4_24_3_, party2_.email_preference_flg as email5_24_3_, party2_.email_reason_cd as email6_24_3_, party2_.preferred_email_format as preferred7_24_3_, party2_.preferred_comm_method as preferred8_24_3_, party2_.secondary_comm_method as secondary9_24_3_, party2_.notes_txt as notes10_24_3_, party2_.language_preference_cd as language11_24_3_, party2_.creation_dttm as creation12_24_3_, party2_.created_by as created13_24_3_, party2_.last_update_dttm as last14_24_3_, party2_.last_updated_by as last15_24_3_, party2_.country_of_origin as country16_24_3_, party2_.status as status24_3_, party2_.validated_flg as validated18_24_3_, party2_.created_by_system_cd as created19_24_3_, party2_.last_updated_by_system_cd as last20_24_3_, party2_1_.native_language_nm as native2_25_3_, party2_1_.category_cd as category3_25_3_, party2_1_.VAT_Number as VAT4_25_3_, party2_1_.stock_cd as stock5_25_3_, party2_1_.line_of_business as line6_25_3_, party2_1_.out_of_business_flg as out7_25_3_, party2_1_.incorporation_st as incorpor8_25_3_, party2_1_.headquarters_st as headquar9_25_3_, party2_2_.first_nm as first2_26_3_, party2_2_.middle_nm as middle3_26_3_, party2_2_.last_nm as last4_26_3_, party2_2_.prefix_title as prefix5_26_3_, party2_2_.suffix as suffix26_3_, party2_2_.previous_last_nm as previous7_26_3_, party2_2_.gender as gender26_3_, party2_2_.nickname as nickname26_3_, party2_3_.contact_type as contact2_27_3_, party2_3_.relationship_id as relation3_27_3_, party2_3_.department as department27_3_, party2_3_.room_num as room5_27_3_, party2_3_.gone_reason_cd as gone6_27_3_, party2_3_.assistant_nm as assistant7_27_3_, party2_4_.group_nm as group2_28_3_, party2_.party_id as formula0_3_, 'Y' as formula1_3_, party2_.party_id as formula2_3_, 'Y' as formula3_3_, party2_.party_id as formula4_3_, 'Y' as formula5_3_, party2_.party_id as formula6_3_, 'Y' as formula7_3_, party2_.party_type as party2_24_3_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=4, fromElements=4, fromElementByClassAlias=[contact, groupParty, subj, rel], fromElementByTableAlias=[contact0_, party2_, group3_, relationsh1_], fromElementsByPath=[rel.subject, contact.relationship], collectionJoinFromElementsByPath=[], impliedElements=[]}
| +-[FROM_FRAGMENT] FromElement: 'party contact0_ inner join contact contact0_1_ on contact0_.party_id=contact0_1_.party_id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=contact,role=null,tableName=party,tableAlias=contact0_,origin=null,colums={,className=com.sas.mis.cdhub.hibernate.Contact}}
| | \-[JOIN_FRAGMENT] FromElement: 'inner join relationship relationsh1_ on contact0_1_.relationship_id=relationsh1_.relationship_id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=rel,role=null,tableName=relationship,tableAlias=relationsh1_,origin=party contact0_ inner join contact contact0_1_ on contact0_.party_id=contact0_1_.party_id,colums={contact0_1_.relationship_id ,className=com.sas.mis.cdhub.hibernate.Relationship}}
| | \-[JOIN_FRAGMENT] FromElement: 'inner join party party2_ on relationsh1_.subject_id=party2_.party_id left outer join company party2_1_ on party2_.party_id=party2_1_.party_id left outer join person party2_2_ on party2_.party_id=party2_2_.party_id left outer join contact party2_3_ on party2_.party_id=party2_3_.party_id left outer join group_party party2_4_ on party2_.party_id=party2_4_.party_id' FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=subj,role=null,tableName=party,tableAlias=party2_,origin=inner join relationship relationsh1_ on contact0_1_.relationship_id=relationsh1_.relationship_id,colums={relationsh1_.subject_id ,className=com.sas.mis.cdhub.hibernate.Party}}
| \-[FROM_FRAGMENT] FromElement: 'party group3_ inner join group_party group3_1_ on group3_.party_id=group3_1_.party_id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=groupParty,role=null,tableName=party,tableAlias=group3_,origin=null,colums={,className=com.sas.mis.cdhub.hibernate.Group}}
+-[WHERE] SqlNode: 'where'
| +-[FILTERS] SqlNode: '{filter conditions}'
| | +-[SQL_TOKEN] SqlFragment: 'contact0_.party_type='CONTACT''
| | \-[SQL_TOKEN] SqlFragment: 'group3_.party_type='GROUP''
| \-[AND] SqlNode: 'and'
| +-[EQ] BinaryLogicOperatorNode: '='
| | +-[ALIAS_REF] IdentNode: 'party2_.party_id' {alias=subj, className=com.sas.mis.cdhub.hibernate.Party, tableAlias=party2_}
| | \-[ALIAS_REF] IdentNode: 'group3_.party_id' {alias=groupParty, className=com.sas.mis.cdhub.hibernate.Group, tableAlias=group3_}
| \-[LIKE] BinaryLogicOperatorNode: 'like'
| +-[METHOD_CALL] MethodNode: '('
| | +-[METHOD_NAME] IdentNode: 'nls_upper' {originalText=nls_upper}
| | \-[EXPR_LIST] SqlNode: 'exprList'
| | +-[DOT] DotNode: 'group3_1_.group_nm' {propertyName=groupNm,dereferenceType=4,propertyPath=groupNm,path=groupParty.groupNm,tableAlias=group3_,className=com.sas.mis.cdhub.hibernate.Group,classAlias=groupParty}
| | | +-[ALIAS_REF] IdentNode: 'group3_.party_id' {alias=groupParty, className=com.sas.mis.cdhub.hibernate.Group, tableAlias=group3_}
| | | \-[IDENT] IdentNode: 'groupNm' {originalText=groupNm}
| | \-[QUOTED_STRING] LiteralNode: ''NLS_SORT = GENERIC_M''
| \-[NAMED_PARAM] ParameterNode: '?' {name=groupPartygroupNm0, expectedType=null}
\-[ORDER] OrderByClause: 'order'
\-[DOT] DotNode: 'group3_1_.group_nm' {propertyName=groupNm,dereferenceType=4,propertyPath=groupNm,path=groupParty.groupNm,tableAlias=group3_,className=com.sas.mis.cdhub.hibernate.Group,classAlias=groupParty}
+-[ALIAS_REF] IdentNode: 'group3_.party_id' {alias=groupParty, className=com.sas.mis.cdhub.hibernate.Group, tableAlias=group3_}
\-[IDENT] IdentNode: 'groupNm' {originalText=groupNm}
18875 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
18891 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - HQL: select contact, subj, rel from com.sas.mis.cdhub.hibernate.Contact as contact join contact.relationship as rel join fetch rel.subject as subj, com.sas.mis.cdhub.hibernate.Group groupParty where subj=groupParty and nls_upper(groupParty.groupNm, 'NLS_SORT = GENERIC_M') like :groupPartygroupNm0 order by groupParty.groupNm
18891 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select contact0_.party_id as party1_24_0_, party2_.party_id as party1_24_1_, relationsh1_.relationship_id as relation1_40_2_, party2_.party_id as party1_24_3_, contact0_.mail_preference_flg as mail3_24_0_, contact0_.mail_reason_cd as mail4_24_0_, contact0_.email_preference_flg as email5_24_0_, contact0_.email_reason_cd as email6_24_0_, contact0_.preferred_email_format as preferred7_24_0_, contact0_.preferred_comm_method as preferred8_24_0_, contact0_.secondary_comm_method as secondary9_24_0_, contact0_.notes_txt as notes10_24_0_, contact0_.language_preference_cd as language11_24_0_, contact0_.creation_dttm as creation12_24_0_, contact0_.created_by as created13_24_0_, contact0_.last_update_dttm as last14_24_0_, contact0_.last_updated_by as last15_24_0_, contact0_.country_of_origin as country16_24_0_, contact0_.status as status24_0_, contact0_.validated_flg as validated18_24_0_, contact0_.created_by_system_cd as created19_24_0_, contact0_.last_updated_by_system_cd as last20_24_0_, contact0_1_.contact_type as contact2_27_0_, contact0_1_.relationship_id as relation3_27_0_, contact0_1_.department as department27_0_, contact0_1_.room_num as room5_27_0_, contact0_1_.gone_reason_cd as gone6_27_0_, contact0_1_.assistant_nm as assistant7_27_0_, contact0_.party_id as formula0_0_, 'Y' as formula1_0_, contact0_.party_id as formula2_0_, 'Y' as formula3_0_, contact0_.party_id as formula4_0_, 'Y' as formula5_0_, contact0_.party_id as formula6_0_, 'Y' as formula7_0_, party2_.mail_preference_flg as mail3_24_1_, party2_.mail_reason_cd as mail4_24_1_, party2_.email_preference_flg as email5_24_1_, party2_.email_reason_cd as email6_24_1_, party2_.preferred_email_format as preferred7_24_1_, party2_.preferred_comm_method as preferred8_24_1_, party2_.secondary_comm_method as secondary9_24_1_, party2_.notes_txt as notes10_24_1_, party2_.language_preference_cd as language11_24_1_, party2_.creation_dttm as creation12_24_1_, party2_.created_by as created13_24_1_, party2_.last_update_dttm as last14_24_1_, party2_.last_updated_by as last15_24_1_, party2_.country_of_origin as country16_24_1_, party2_.status as status24_1_, party2_.validated_flg as validated18_24_1_, party2_.created_by_system_cd as created19_24_1_, party2_.last_updated_by_system_cd as last20_24_1_, party2_1_.native_language_nm as native2_25_1_, party2_1_.category_cd as category3_25_1_, party2_1_.VAT_Number as VAT4_25_1_, party2_1_.stock_cd as stock5_25_1_, party2_1_.line_of_business as line6_25_1_, party2_1_.out_of_business_flg as out7_25_1_, party2_1_.incorporation_st as incorpor8_25_1_, party2_1_.headquarters_st as headquar9_25_1_, party2_2_.first_nm as first2_26_1_, party2_2_.middle_nm as middle3_26_1_, party2_2_.last_nm as last4_26_1_, party2_2_.prefix_title as prefix5_26_1_, party2_2_.suffix as suffix26_1_, party2_2_.previous_last_nm as previous7_26_1_, party2_2_.gender as gender26_1_, party2_2_.nickname as nickname26_1_, party2_3_.contact_type as contact2_27_1_, party2_3_.relationship_id as relation3_27_1_, party2_3_.department as department27_1_, party2_3_.room_num as room5_27_1_, party2_3_.gone_reason_cd as gone6_27_1_, party2_3_.assistant_nm as assistant7_27_1_, party2_4_.group_nm as group2_28_1_, party2_.party_id as formula0_1_, 'Y' as formula1_1_, party2_.party_id as formula2_1_, 'Y' as formula3_1_, party2_.party_id as formula4_1_, 'Y' as formula5_1_, party2_.party_id as formula6_1_, 'Y' as formula7_1_, party2_.party_type as party2_24_1_, relationsh1_.subject_id as subject2_40_2_, relationsh1_.object_id as object3_40_2_, relationsh1_.relationship_type as relation4_40_2_, relationsh1_.creation_dttm as creation5_40_2_, relationsh1_.created_by as created6_40_2_, relationsh1_.last_update_dttm as last7_40_2_, relationsh1_.last_updated_by as last8_40_2_, relationsh1_.country_of_origin as country9_40_2_, relationsh1_.status as status40_2_, relationsh1_.created_by_system_cd as created11_40_2_, relationsh1_.last_updated_by_system_cd as last12_40_2_, party2_.mail_preference_flg as mail3_24_3_, party2_.mail_reason_cd as mail4_24_3_, party2_.email_preference_flg as email5_24_3_, party2_.email_reason_cd as email6_24_3_, party2_.preferred_email_format as preferred7_24_3_, party2_.preferred_comm_method as preferred8_24_3_, party2_.secondary_comm_method as secondary9_24_3_, party2_.notes_txt as notes10_24_3_, party2_.language_preference_cd as language11_24_3_, party2_.creation_dttm as creation12_24_3_, party2_.created_by as created13_24_3_, party2_.last_update_dttm as last14_24_3_, party2_.last_updated_by as last15_24_3_, party2_.country_of_origin as country16_24_3_, party2_.status as status24_3_, party2_.validated_flg as validated18_24_3_, party2_.created_by_system_cd as created19_24_3_, party2_.last_updated_by_system_cd as last20_24_3_, party2_1_.native_language_nm as native2_25_3_, party2_1_.category_cd as category3_25_3_, party2_1_.VAT_Number as VAT4_25_3_, party2_1_.stock_cd as stock5_25_3_, party2_1_.line_of_business as line6_25_3_, party2_1_.out_of_business_flg as out7_25_3_, party2_1_.incorporation_st as incorpor8_25_3_, party2_1_.headquarters_st as headquar9_25_3_, party2_2_.first_nm as first2_26_3_, party2_2_.middle_nm as middle3_26_3_, party2_2_.last_nm as last4_26_3_, party2_2_.prefix_title as prefix5_26_3_, party2_2_.suffix as suffix26_3_, party2_2_.previous_last_nm as previous7_26_3_, party2_2_.gender as gender26_3_, party2_2_.nickname as nickname26_3_, party2_3_.contact_type as contact2_27_3_, party2_3_.relationship_id as relation3_27_3_, party2_3_.department as department27_3_, party2_3_.room_num as room5_27_3_, party2_3_.gone_reason_cd as gone6_27_3_, party2_3_.assistant_nm as assistant7_27_3_, party2_4_.group_nm as group2_28_3_, party2_.party_id as formula0_3_, 'Y' as formula1_3_, party2_.party_id as formula2_3_, 'Y' as formula3_3_, party2_.party_id as formula4_3_, 'Y' as formula5_3_, party2_.party_id as formula6_3_, 'Y' as formula7_3_, party2_.party_type as party2_24_3_ from party contact0_ inner join contact contact0_1_ on contact0_.party_id=contact0_1_.party_id inner join relationship relationsh1_ on contact0_1_.relationship_id=relationsh1_.relationship_id inner join party party2_ on relationsh1_.subject_id=party2_.party_id left outer join company party2_1_ on party2_.party_id=party2_1_.party_id left outer join person party2_2_ on party2_.party_id=party2_2_.party_id left outer join contact party2_3_ on party2_.party_id=party2_3_.party_id left outer join group_party party2_4_ on party2_.party_id=party2_4_.party_id, party group3_ inner join group_party group3_1_ on group3_.party_id=group3_1_.party_id where contact0_.party_type='CONTACT' and group3_.party_type='GROUP' and party2_.party_id=group3_.party_id and (nls_upper(group3_1_.group_nm, 'NLS_SORT = GENERIC_M') like ?) order by group3_1_.group_nm
18891 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
18922 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - processing flush-time cascades
18922 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - dirty checking collections
18922 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 0 deletions to 37 objects
18922 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
18922 [main] DEBUG org.hibernate.pretty.Printer - listing entities:
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=FSSET, registeredDttm=2006-09-07 11:13:00, registeredBy=krirvi, status=A, sourceSystemCd=FSSET, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Unknown, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=UNKNOWN, syncsVia=null}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ENCORE, registeredDttm=2006-09-07 11:14:00, registeredBy=krirvi, status=A, sourceSystemCd=Encore, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Customer Data Hub, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=CDHUB, syncsVia=null}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Cdm AdminTool v1.5, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=CDHUB ADMIN V1, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=EIDB, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=EIDB, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Regoff, registeredDttm=2008-06-02 16:20:00, registeredBy=asmahe, status=A, sourceSystemCd=REGOFF, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ORACLE MERGE, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=ORACLE_MERGE, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ONS, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=ONS, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=SUGI, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=SUGI, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=CDHUB V1, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=CDHUB V1, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ENCORE, registeredDttm=2006-09-07 11:14:00, registeredBy=krirvi, status=A, sourceSystemCd=ENCORE, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ORACLE APP, registeredDttm=2007-03-07 01:27:00, registeredBy=krirvi, status=A, sourceSystemCd=ORACLE APP, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Synapse AUS, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=SYNAPSE-AUS, syncsVia=null}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=LEGACY, registeredDttm=2007-03-07 01:27:00, registeredBy=krirvi, status=I, sourceSystemCd=LEGACY, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Oracle TCA, registeredDttm=2006-12-05 08:35:00, registeredBy=ampear, status=A, sourceSystemCd=ORACLE, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=ORDERS, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=ORDERS, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=PUBSPEC, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=PUBSPEC, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Synapse, registeredDttm=2006-09-07 11:12:00, registeredBy=krirvi, status=A, sourceSystemCd=SYNAPSE, syncsVia=null}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=GIDB (Contracts), registeredDttm=2006-09-07 11:13:00, registeredBy=krirvi, status=A, sourceSystemCd=GIDB, syncsVia=ORCL}
18938 [main] DEBUG org.hibernate.pretty.Printer - com.sas.mis.cdhub.hibernate.SourceSystem{sourceSystemNm=Test2, registeredDttm=2008-04-07 00:00:00, registeredBy=asmahe, status=A, sourceSystemCd=TEST2, syncsVia=null}
18938 [main] DEBUG org.hibernate.pretty.Printer - more......
18938 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
18984 [main] DEBUG org.hibernate.SQL -
/* select
contact,
subj,
rel
from
Contact as contact
join
contact.relationship as rel
join
fetch rel.subject as subj,
Group groupParty where
subj=groupParty
and nls_upper(groupParty.groupNm, 'NLS_SORT = GENERIC_M') like :groupPartygroupNm0
order by
groupParty.groupNm */ select
*
from
( select
contact0_.party_id as party1_24_0_,
party2_.party_id as party1_24_1_,
relationsh1_.relationship_id as relation1_40_2_,
party2_.party_id as party1_24_3_,
contact0_.mail_preference_flg as mail3_24_0_,
contact0_.mail_reason_cd as mail4_24_0_,
contact0_.email_preference_flg as email5_24_0_,
contact0_.email_reason_cd as email6_24_0_,
contact0_.preferred_email_format as preferred7_24_0_,
contact0_.preferred_comm_method as preferred8_24_0_,
contact0_.secondary_comm_method as secondary9_24_0_,
contact0_.notes_txt as notes10_24_0_,
contact0_.language_preference_cd as language11_24_0_,
contact0_.creation_dttm as creation12_24_0_,
contact0_.created_by as created13_24_0_,
contact0_.last_update_dttm as last14_24_0_,
contact0_.last_updated_by as last15_24_0_,
contact0_.country_of_origin as country16_24_0_,
contact0_.status as status24_0_,
contact0_.validated_flg as validated18_24_0_,
contact0_.created_by_system_cd as created19_24_0_,
contact0_.last_updated_by_system_cd as last20_24_0_,
contact0_1_.contact_type as contact2_27_0_,
contact0_1_.relationship_id as relation3_27_0_,
contact0_1_.department as depart
Login
FAQ
Search