[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2213) INFINITE loop with HQL Query using select new SomeClass(queryclass)
andrew (JIRA)
noreply at atlassian.com
Sun Nov 5 19:33:04 EST 2006
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: Critical
Attachments: AdMgmtInfo.java, AdMgmtVw.java, IAdMgmtVw.java
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:
---------------------------------------------------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list