[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2213) INFINITE loop with HQL Query using select new SomeClass(queryclass)

INFINITE loop with HQL Query using select new SomeClass(queryclass) ------------------------------------------------------------------- Key: HHH-2213 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2213 Project: Hibernate3 Type: Bug

Components: query-hql Versions: 3.2.0.cr3 Environment: Win XP, Hibernate version 3.2 cr4, August 24, 2006 Jboss jboss-4.0.4.GA, Oracle 10G Reporter: andrew Priority: Minor Attachments: AdMgmtInfo.java, AdMgmtVw.java, IAdMgmtVw.java, persistence.xml Hi, Run into an infinite loop problem when using HQL "select new" Query best if I report this in code: (also attaching relevant java classes, file being described is: AdMgmtInfo.java) I have following HQL query string: String queryString = "select new com.unicast.campaign.impl.AdMgmtInfo(admgmtvw) from com.unicast.campaign.impl.AdMgmtVw as admgmtvw" upon executing Query query = entityManager.createQuery(queryString); List<IAdMgmtInfo> adMgmtInfoList = (List<IAdMgmtInfo>) query.getResultList(); Hibernate goes into INFINITE loop creating follwoing repeating output (jboss log) 2006-11-05 19:08:26,316 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select new com.unicast.campaign.impl.AdMgmtInfo(admgmtvw) from com.unicast.campaign.impl.AdMgmtVw as admgmtvw 2006-11-05 19:08:26,347 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST --- \-[QUERY] 'query' \-[SELECT_FROM] 'SELECT_FROM' +-[FROM] 'from' | \-[RANGE] 'RANGE' | +-[DOT] '.' | | +-[DOT] '.' | | | +-[DOT] '.' | | | | +-[DOT] '.' | | | | | +-[IDENT] 'com' | | | | | \-[IDENT] 'unicast' | | | | \-[IDENT] 'campaign' | | | \-[IDENT] 'impl' | | \-[IDENT] 'AdMgmtVw' | \-[ALIAS] 'admgmtvw' \-[SELECT] 'select' \-[CONSTRUCTOR] '(' +-[DOT] '.' | +-[DOT] '.' | | +-[DOT] '.' | | | +-[DOT] '.' | | | | +-[IDENT] 'com' | | | | \-[IDENT] 'unicast' | | | \-[IDENT] 'campaign' | | \-[IDENT] 'impl' | \-[IDENT] 'AdMgmtInfo' \-[IDENT] 'admgmtvw' 2006-11-05 19:08:26,347 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2006-11-05 19:08:26,488 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select] 2006-11-05 19:08:26,550 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.unicast.campaign.impl.AdMgmtVw (admgmtvw) -> admgmtvw0_ 2006-11-05 19:08:26,566 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : admgmtvw -> admgmtvw0_.AD_ID 2006-11-05 19:08:26,581 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select] 2006-11-05 19:08:26,581 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} ( ( ( . ( . ( . ( . com unicast ) campaign ) impl ) AdMgmtInfo ) admgmtvw0_.AD_ID ) ) ( FromClause{level=1} FUSE_RP.AD_MGMT_VW admgmtvw0_ ) ) 2006-11-05 19:08:26,597 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [FUSE_RP.AD_MGMT_VW admgmtvw0_] 2006-11-05 19:08:26,597 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select] 2006-11-05 19:08:26,613 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST --- \-[SELECT] QueryNode: 'SELECT' querySpaces (FUSE_RP.AD_MGMT_VW) +-[SELECT_CLAUSE] SelectClause: '{select clause}' | \-[CONSTRUCTOR] ConstructorNode: '(' | +-[DOT] DotNode: '.' {propertyName=null,dereferenceType=ROOT_LEVEL,propertyPath=null,path=com.unicast.campaign.impl.AdMgmtInfo,no from element} | | +-[DOT] DotNode: '.' {propertyName=null,dereferenceType=ROOT_LEVEL,propertyPath=null,path=com.unicast.campaign.impl,no from element} | | | +-[DOT] DotNode: '.' {propertyName=null,dereferenceType=ROOT_LEVEL,propertyPath=null,path=com.unicast.campaign,no from element} | | | | +-[DOT] DotNode: '.' {propertyName=null,dereferenceType=ROOT_LEVEL,propertyPath=null,path=com.unicast,no from element} | | | | | +-[IDENT] IdentNode: 'com' {originalText=com} | | | | | \-[IDENT] IdentNode: 'unicast' {originalText=unicast} | | | | \-[IDENT] IdentNode: 'campaign' {originalText=campaign} | | | \-[IDENT] IdentNode: 'impl' {originalText=impl} | | \-[IDENT] IdentNode: 'AdMgmtInfo' {originalText=AdMgmtInfo} | \-[ALIAS_REF] IdentNode: 'admgmtvw0_.AD_ID as col_0_0_' {alias=admgmtvw, className=com.unicast.campaign.impl.AdMgmtVw, tableAlias=admgmtvw0_} \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[admgmtvw], fromElementByTableAlias=[admgmtvw0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} \-[FROM_FRAGMENT] FromElement: 'FUSE_RP.AD_MGMT_VW admgmtvw0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=admgmtvw,role=null,tableName=FUSE_RP.AD_MGMT_VW,tableAlias=admgmtvw0_,origin=null,colums={,className=com.unicast.campaign.impl.AdMgmtVw}} 2006-11-05 19:08:26,613 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2006-11-05 19:08:26,644 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: select new com.unicast.campaign.impl.AdMgmtInfo(admgmtvw) from com.unicast.campaign.impl.AdMgmtVw as admgmtvw 2006-11-05 19:08:26,644 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select admgmtvw0_.AD_ID as col_0_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ 2006-11-05 19:08:26,644 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2006-11-05 19:08:26,691 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-11-05 19:08:26,691 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-11-05 19:08:26,738 DEBUG [org.hibernate.SQL] select admgmtvw0_.AD_ID as col_0_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ 2006-11-05 19:08:26,738 INFO [STDOUT] Hibernate: select admgmtvw0_.AD_ID as col_0_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ 2006-11-05 19:08:27,003 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0) 2006-11-05 19:08:27,003 DEBUG [org.hibernate.loader.Loader] result row: 2006-11-05 19:08:27,081 DEBUG [org.hibernate.loader.Loader] loading entity: [com.unicast.campaign.impl.AdMgmtVw#210] 2006-11-05 19:08:27,081 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-11-05 19:08:27,081 DEBUG [org.hibernate.SQL] select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,081 INFO [STDOUT] Hibernate: select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,222 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1) 2006-11-05 19:08:27,222 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.unicast.campaign.impl.AdMgmtVw#210] 2006-11-05 19:08:27,284 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2) 2006-11-05 19:08:27,284 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2) 2006-11-05 19:08:27,316 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggresive-release due to open resources on batcher 2006-11-05 19:08:27,316 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [com.unicast.campaign.impl.AdMgmtVw#210] 2006-11-05 19:08:27,331 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [com.unicast.campaign.impl.AdMgmtVw#210] 2006-11-05 19:08:27,331 DEBUG [org.hibernate.loader.Loader] done entity load 2006-11-05 19:08:27,331 DEBUG [org.hibernate.loader.Loader] result row: 2006-11-05 19:08:27,331 DEBUG [org.hibernate.loader.Loader] loading entity: [com.unicast.campaign.impl.AdMgmtVw#208] 2006-11-05 19:08:27,331 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-11-05 19:08:27,331 DEBUG [org.hibernate.SQL] select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,331 INFO [STDOUT] Hibernate: select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,472 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1) 2006-11-05 19:08:27,472 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.unicast.campaign.impl.AdMgmtVw#208] 2006-11-05 19:08:27,503 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2) 2006-11-05 19:08:27,503 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2) 2006-11-05 19:08:27,534 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggresive-release due to open resources on batcher 2006-11-05 19:08:27,534 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [com.unicast.campaign.impl.AdMgmtVw#208] 2006-11-05 19:08:27,534 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [com.unicast.campaign.impl.AdMgmtVw#208] 2006-11-05 19:08:27,534 DEBUG [org.hibernate.loader.Loader] done entity load 2006-11-05 19:08:27,534 DEBUG [org.hibernate.loader.Loader] result row: 2006-11-05 19:08:27,534 DEBUG [org.hibernate.loader.Loader] loading entity: [com.unicast.campaign.impl.AdMgmtVw#1011] 2006-11-05 19:08:27,534 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-11-05 19:08:27,534 DEBUG [org.hibernate.SQL] select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,534 INFO [STDOUT] Hibernate: select admgmtvw0_.AD_ID as AD1_4_0_, admgmtvw0_.PLACEMENT_ID as PLACEMENT2_4_0_, admgmtvw0_.ADVERTISER_ID as ADVERTISER3_4_0_, admgmtvw0_.ADVERTISER_NAME as ADVERTISER4_4_0_, admgmtvw0_.AGENCY_ID as AGENCY5_4_0_, admgmtvw0_.AGENCY_NAME as AGENCY6_4_0_, admgmtvw0_.BILLING_NAME as BILLING7_4_0_, admgmtvw0_.CAMPAIGN_END_DATE as CAMPAIGN8_4_0_, admgmtvw0_.CAMPAIGN_ID as CAMPAIGN9_4_0_, admgmtvw0_.CAMPAIGN_NAME as CAMPAIGN10_4_0_, admgmtvw0_.CAMPAIGN_START_DATE as CAMPAIGN11_4_0_, admgmtvw0_.CREATIVE_FULL_PLAY_LENGTH as CREATIVE12_4_0_, admgmtvw0_.CREATIVE_ID as CREATIVE13_4_0_, admgmtvw0_.CREATIVE_NAME as CREATIVE14_4_0_, admgmtvw0_.PUBLISHER_NAME as PUBLISHER15_4_0_, admgmtvw0_.PLACEMENT_NAME as PLACEMENT16_4_0_, admgmtvw0_.CAMPAIGN_PO as CAMPAIGN17_4_0_, admgmtvw0_.PUBLISHER_ID as PUBLISHER18_4_0_, admgmtvw0_.BILLABLE_PARTY_BUS_TYPE as BILLABLE19_4_0_, admgmtvw0_.VWPT_SALES_MANAGER as VWPT20_4_0_, admgmtvw0_.VWPT_SALES_LOCATION as VWPT21_4_0_, admgmtvw0_.VWPT_CSR_ID as VWPT22_4_0_, admgmtvw0_.VWPT_CSR_NAME as VWPT23_4_0_, admgmtvw0_.PLACEMENT_CAP as PLACEMENT24_4_0_, admgmtvw0_.PLACEMENT_START_DATE as PLACEMENT25_4_0_, admgmtvw0_.PLACEMENT_END_DATE as PLACEMENT26_4_0_, admgmtvw0_.CREATIVE_PRODUCT_GROUP as CREATIVE27_4_0_, admgmtvw0_.CREATIVE_FORMAT as CREATIVE28_4_0_, admgmtvw0_.CREATIVE_TECHNOLOGY_TYPE as CREATIVE29_4_0_, admgmtvw0_.CREATIVE_FILE_SIZE as CREATIVE30_4_0_, admgmtvw0_.CREATIVE_CPM as CREATIVE31_4_0_, admgmtvw0_.BILLABLE_PARTY_CONTACT_NAME as BILLABLE32_4_0_, admgmtvw0_.BILLABLE_PARTY_ADDRESS as BILLABLE33_4_0_, admgmtvw0_.BILLABLE_PARTY_PHONE as BILLABLE34_4_0_, admgmtvw0_.BILLABLE_PARTY_FAX as BILLABLE35_4_0_, admgmtvw0_.BILLABLE_PARTY_EMAIL as BILLABLE36_4_0_, admgmtvw0_.AD_PLANNED_IMPS as AD37_4_0_, admgmtvw0_.IMPRESSION_TO_COUNT as IMPRESSION38_4_0_, admgmtvw0_.VIDEO_PLAY_TIME as VIDEO39_4_0_ from FUSE_RP.AD_MGMT_VW admgmtvw0_ where admgmtvw0_.AD_ID=? 2006-11-05 19:08:27,675 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1) 2006-11-05 19:08:27,675 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.unicast.campaign.impl.AdMgmtVw#1011] 2006-11-05 19:08:27,706 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2) 2006-11-05 19:08:27,706 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2) 2006-11-05 19:08:27,738 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggresive-release due to open resources on batcher 2006-11-05 19:08:27,738 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [com.unicast.campaign.impl.AdMgmtVw#1011] 2006-11-05 19:08:27,738 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [com.unicast.campaign.impl.AdMgmtVw#1011] 2006-11-05 19:08:27,738 DEBUG [org.hibernate.loader.Loader] done entity load 2006-11-05 19:08:27,738 DEBUG [org.hibernate.loader.Loader] result row: ---------------------------------------------------------------------------------------------------------