Hello, I have a problem when hibernate converts my HQL into SQL. Hibernate reports no errors. Somehow a FROM element disappears in the conversion causing an element in the WHERE clause to be undefined.
Here's the subquery that comes out wrong:
Code:
select guide7_.id from gtm2.guide guide7_ where contents9_.language_id=?
The element in question is named contents9_ by hibernate. As you can see it is not in the FROM clause (but it was in HQL as you can see in the logs).
The weird part of the debug log is the following:
Code:
+-[FROM] FromClause: 'FROM' FromClause{level=2, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[g, c, i], fromElementByTableAlias=[contents9_, guide7_], fromElementsByPath=[i.contents], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'gtm2.guide guide7_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=g,role=null,tableName=gtm2.guide,tableAlias=guide7_,origin=null,colums={,className=se.guidetome.entity.Guide}}
It says fromElementCounter=2 but only one FROM_FRAGMENT is listed.
Queries and logs below. Any tips very much appreciated.
Hibernate version: 2008-11-26 15:25:34,697 INFO [org.hibernate.ejb.Version] Hibernate EntityManager 3.2.1.GA
2008-11-26 15:25:34,729 INFO [org.hibernate.cfg.annotations.Version] Hibernate Annotations 3.2.1.GA
2008-11-26 15:25:34,744 INFO [org.hibernate.cfg.Environment] Hibernate 3.2.4.sp1
Mapping documents:Code between sessionFactory.openSession() and session.close():Handled by Seam 2.1.0
Full stack trace of any exception that occurs:No exceptions
Name and version of the database you are using:MySQL 5
The generated SQL (show_sql=true):Code:
HQL
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: SELECT g,c,gp,i FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c JOIN i.informationblockMapmarkers im JOIN im.mapmarker.geoposition gp WHERE (c.language.id=:guideLanguageID OR c.language.id=i.language.id) AND gp.latitude IS NOT NULL AND gp.longitude IS NOT NULL AND c.id NOT IN (SELECT c.id FROM se.guidetome.entity.Content c WHERE c.language.id<>:guideLanguageID) AND g.id IN (SELECT g.id FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c WHERE c.language.id=:guideLanguageID)
SQL
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select guide0_.id as id25_0_, contents2_.id as id10_1_, geopositio5_.id as id24_2_, informatio1_.id as id33_3_, guide0_.informationblock_id as informat2_25_0_, contents2_.hits as hits10_1_, contents2_.presentation_image_id as presenta7_10_1_, contents2_.informationblock_id as informat8_10_1_, contents2_.language_id as language6_10_1_, contents2_.long_description as long3_10_1_, contents2_.short_description as short4_10_1_, contents2_.title as title10_1_, geopositio5_.latitude as latitude24_2_, geopositio5_.longitude as longitude24_2_, geopositio5_.name as name24_2_, informatio1_.created_date as created2_33_3_, informatio1_.default_language_id as default5_33_3_, informatio1_.offset as offset33_3_, informatio1_.publish_status as publish4_33_3_ from gtm2.guide guide0_ inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id inner join gtm2.content contents2_ on informatio1_.id=contents2_.informationblock_id inner join gtm2.informationblock_mapmarker informatio3_ on informatio1_.id=informatio3_.informationblock_id inner join gtm2.mapmarker mapmarker4_ on informatio3_.mapmarker_id=mapmarker4_.id inner join gtm2.geoposition geopositio5_ on mapmarker4_.geoposition_id=geopositio5_.id where (contents2_.language_id=? or contents2_.language_id=informatio1_.default_language_id) and (geopositio5_.latitude is not null) and (geopositio5_.longitude is not null) and (contents2_.id not in (select content6_.id from gtm2.content content6_ where content6_.language_id<>?)) and (guide0_.id in (select guide7_.id from gtm2.guide guide7_ where contents9_.language_id=?))
Debug level Hibernate log excerpt:Code:
2008-11-26 15:25:58,260 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking named query: Guide.findAllGuideMapWindowDatas
2008-11-26 15:25:58,260 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: SELECT g,c,gp,i FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c JOIN i.informationblockMapmarkers im JOIN im.mapmarker.geoposition gp WHERE (c.language.id=:guideLanguageID OR c.language.id=i.language.id) AND gp.latitude IS NOT NULL AND gp.longitude IS NOT NULL AND c.id NOT IN (SELECT c.id FROM se.guidetome.entity.Content c WHERE c.language.id<>:guideLanguageID) AND g.id IN (SELECT g.id FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c WHERE c.language.id=:guideLanguageID)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'FROM'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'se'
| | | | | | \-[IDENT] 'guidetome'
| | | | | \-[IDENT] 'entity'
| | | | \-[IDENT] 'Guide'
| | | \-[ALIAS] 'g'
| | +-[JOIN] 'JOIN'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'g'
| | | | \-[IDENT] 'informationblock'
| | | \-[ALIAS] 'i'
| | +-[JOIN] 'JOIN'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'i'
| | | | \-[IDENT] 'contents'
| | | \-[ALIAS] 'c'
| | +-[JOIN] 'JOIN'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'i'
| | | | \-[IDENT] 'informationblockMapmarkers'
| | | \-[ALIAS] 'im'
| | \-[JOIN] 'JOIN'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'im'
| | | | \-[IDENT] 'mapmarker'
| | | \-[IDENT] 'geoposition'
| | \-[ALIAS] 'gp'
| \-[SELECT] 'SELECT'
| +-[IDENT] 'g'
| +-[IDENT] 'c'
| +-[IDENT] 'gp'
| \-[IDENT] 'i'
\-[WHERE] 'WHERE'
\-[AND] 'AND'
+-[AND] 'AND'
| +-[AND] 'AND'
| | +-[AND] 'AND'
| | | +-[OR] 'OR'
| | | | +-[EQ] '='
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'c'
| | | | | | | \-[IDENT] 'language'
| | | | | | \-[IDENT] 'id'
| | | | | \-[COLON] ':'
| | | | | \-[IDENT] 'guideLanguageID'
| | | | \-[EQ] '='
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'c'
| | | | | | \-[IDENT] 'language'
| | | | | \-[IDENT] 'id'
| | | | \-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[IDENT] 'i'
| | | | | \-[IDENT] 'language'
| | | | \-[IDENT] 'id'
| | | \-[IS_NOT_NULL] 'is not null'
| | | \-[DOT] '.'
| | | +-[IDENT] 'gp'
| | | \-[IDENT] 'latitude'
| | \-[IS_NOT_NULL] 'is not null'
| | \-[DOT] '.'
| | +-[IDENT] 'gp'
| | \-[IDENT] 'longitude'
| \-[NOT_IN] 'not in'
| +-[DOT] '.'
| | +-[IDENT] 'c'
| | \-[IDENT] 'id'
| \-[IN_LIST] 'inList'
| \-[QUERY] 'query'
| +-[SELECT_FROM] 'SELECT_FROM'
| | +-[FROM] 'FROM'
| | | \-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'se'
| | | | | | \-[IDENT] 'guidetome'
| | | | | \-[IDENT] 'entity'
| | | | \-[IDENT] 'Content'
| | | \-[ALIAS] 'c'
| | \-[SELECT] 'SELECT'
| | \-[DOT] '.'
| | +-[IDENT] 'c'
| | \-[IDENT] 'id'
| \-[WHERE] 'WHERE'
| \-[NE] '<>'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[IDENT] 'c'
| | | \-[IDENT] 'language'
| | \-[IDENT] 'id'
| \-[COLON] ':'
| \-[IDENT] 'guideLanguageID'
\-[IN] 'in'
+-[DOT] '.'
| +-[IDENT] 'g'
| \-[IDENT] 'id'
\-[IN_LIST] 'inList'
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'FROM'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'se'
| | | | | | \-[IDENT] 'guidetome'
| | | | | \-[IDENT] 'entity'
| | | | \-[IDENT] 'Guide'
| | | \-[ALIAS] 'g'
| | +-[JOIN] 'JOIN'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'g'
| | | | \-[IDENT] 'informationblock'
| | | \-[ALIAS] 'i'
| | \-[JOIN] 'JOIN'
| | +-[DOT] '.'
| | | +-[IDENT] 'i'
| | | \-[IDENT] 'contents'
| | \-[ALIAS] 'c'
| \-[SELECT] 'SELECT'
| \-[DOT] '.'
| +-[IDENT] 'g'
| \-[IDENT] 'id'
\-[WHERE] 'WHERE'
\-[EQ] '='
+-[DOT] '.'
| +-[DOT] '.'
| | +-[IDENT] 'c'
| | \-[IDENT] 'language'
| \-[IDENT] 'id'
\-[COLON] ':'
\-[IDENT] 'guideLanguageID'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.Guide (g) -> guide0_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g -> guide0_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : informationblock -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Informationblock)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for informationblock in se.guidetome.entity.Guide (i) parent = [ {null} ]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.Informationblock (i) -> informatio1_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : g.informationblock -> gtm2.informationblock informatio1_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g.informationblock -> guide0_.informationblock_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'gtm2.informationblock informatio1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=i,role=null,tableName=gtm2.informationblock,tableAlias=informatio1_,origin=gtm2.guide guide0_,colums={guide0_.informationblock_id ,className=se.guidetome.entity.Informationblock}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i -> informatio1_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : contents -> org.hibernate.type.SetType(se.guidetome.entity.Informationblock.contents)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElementFactory] createEntityAssociation() : One to many - path = i.contents role = se.guidetome.entity.Informationblock.contents associatedEntityName = se.guidetome.entity.Content
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.Content (c) -> contents2_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : i.contents -> gtm2.content contents2_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceCollection() : Created new FROM element for i.contents : gtm2.content contents2_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i.contents -> .
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'gtm2.content contents2_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=se.guidetome.entity.Informationblock.contents,tableName=gtm2.content,tableAlias=contents2_,origin=gtm2.informationblock informatio1_,colums={informatio1_.id ,className=se.guidetome.entity.Content}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i -> informatio1_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : informationblockMapmarkers -> org.hibernate.type.SetType(se.guidetome.entity.Informationblock.informationblockMapmarkers)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElementFactory] createEntityAssociation() : One to many - path = i.informationblockMapmarkers role = se.guidetome.entity.Informationblock.informationblockMapmarkers associatedEntityName = se.guidetome.entity.InformationblockMapmarker
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.InformationblockMapmarker (im) -> informatio3_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : i.informationblockMapmarkers -> gtm2.informationblock_mapmarker informatio3_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceCollection() : Created new FROM element for i.informationblockMapmarkers : gtm2.informationblock_mapmarker informatio3_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i.informationblockMapmarkers -> .
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'gtm2.informationblock_mapmarker informatio3_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=im,role=se.guidetome.entity.Informationblock.informationblockMapmarkers,tableName=gtm2.informationblock_mapmarker,tableAlias=informatio3_,origin=gtm2.informationblock informatio1_,colums={informatio1_.id ,className=se.guidetome.entity.InformationblockMapmarker}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : im -> (informatio3_.informationblock_id, informatio3_.mapmarker_id)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : mapmarker -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Mapmarker)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for mapmarker in se.guidetome.entity.InformationblockMapmarker {no alias} parent = [ ( . ( . (informatio3_.informationblock_id, informatio3_.mapmarker_id) mapmarker ) geoposition ) ]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.Mapmarker (no alias) -> mapmarker4_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : im.mapmarker -> gtm2.mapmarker mapmarker4_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : im.mapmarker -> informatio3_.mapmarker_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : geoposition -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Geoposition)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for geoposition in se.guidetome.entity.Mapmarker (gp) parent = [ {null} ]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : se.guidetome.entity.Geoposition (gp) -> geopositio5_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : im.mapmarker.geoposition -> gtm2.geoposition geopositio5_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : im.mapmarker.geoposition -> mapmarker4_.geoposition_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] ImpliedFromElement: 'gtm2.mapmarker mapmarker4_' ImpliedFromElement{implied in FROM clause,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=gtm2.mapmarker,tableAlias=mapmarker4_,origin=gtm2.informationblock_mapmarker informatio3_,colums={informatio3_.mapmarker_id ,className=se.guidetome.entity.Mapmarker}}
\-[JOIN_FRAGMENT] FromElement: 'gtm2.geoposition geopositio5_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=gp,role=null,tableName=gtm2.geoposition,tableAlias=geopositio5_,origin=gtm2.mapmarker mapmarker4_,colums={mapmarker4_.geoposition_id ,className=se.guidetome.entity.Geoposition}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g -> guide0_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> contents2_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : gp -> geopositio5_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i -> informatio1_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> contents2_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Language)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property id in se.guidetome.entity.Content does not require a join.
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'language.id'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language -> contents2_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language.id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language.id -> contents2_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> contents2_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Language)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property id in se.guidetome.entity.Content does not require a join.
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'language.id'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language -> contents2_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language.id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language.id -> contents2_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i -> informatio1_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Language)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property id in se.guidetome.entity.Informationblock does not require a join.
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'language.id'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i.language -> informatio1_.default_language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language.id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i.language.id -> informatio1_.default_language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : gp -> geopositio5_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : latitude -> org.hibernate.type.DoubleType@e0f08
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : gp.latitude -> geopositio5_.latitude
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : gp -> geopositio5_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : longitude -> org.hibernate.type.DoubleType@e0f08
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : gp.longitude -> geopositio5_.longitude
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> contents2_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.id -> contents2_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=2} : se.guidetome.entity.Content (c) -> content6_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> content6_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.id -> content6_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> content6_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Language)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property id in se.guidetome.entity.Content does not require a join.
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'language.id'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language -> content6_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language.id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language.id -> content6_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} ( content6_.id content6_.id id ) ) ( FromClause{level=2} gtm2.content content6_ ) ( WHERE ( <> ( content6_.language_id ( content6_.language_id content6_.id language ) id ) ? ) ) )
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [gtm2.content content6_]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g -> guide0_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g.id -> guide0_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=2} : se.guidetome.entity.Guide (g) -> guide7_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g -> guide7_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : informationblock -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Informationblock)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for informationblock in se.guidetome.entity.Guide (i) parent = [ {null} ]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g.informationblock -> guide7_.informationblock_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'gtm2.informationblock informatio1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=i,role=null,tableName=gtm2.informationblock,tableAlias=informatio1_,origin=gtm2.guide guide0_,colums={guide0_.informationblock_id ,className=se.guidetome.entity.Informationblock}}
+-[JOIN_FRAGMENT] FromElement: 'gtm2.content contents2_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=se.guidetome.entity.Informationblock.contents,tableName=gtm2.content,tableAlias=contents2_,origin=gtm2.informationblock informatio1_,colums={informatio1_.id ,className=se.guidetome.entity.Content}}
\-[JOIN_FRAGMENT] FromElement: 'gtm2.informationblock_mapmarker informatio3_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=im,role=se.guidetome.entity.Informationblock.informationblockMapmarkers,tableName=gtm2.informationblock_mapmarker,tableAlias=informatio3_,origin=gtm2.informationblock informatio1_,colums={informatio1_.id ,className=se.guidetome.entity.InformationblockMapmarker}}
\-[JOIN_FRAGMENT] ImpliedFromElement: 'gtm2.mapmarker mapmarker4_' ImpliedFromElement{implied in FROM clause,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=gtm2.mapmarker,tableAlias=mapmarker4_,origin=gtm2.informationblock_mapmarker informatio3_,colums={informatio3_.mapmarker_id ,className=se.guidetome.entity.Mapmarker}}
\-[JOIN_FRAGMENT] FromElement: 'gtm2.geoposition geopositio5_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=gp,role=null,tableName=gtm2.geoposition,tableAlias=geopositio5_,origin=gtm2.mapmarker mapmarker4_,colums={mapmarker4_.geoposition_id ,className=se.guidetome.entity.Geoposition}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i -> informatio1_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : contents -> org.hibernate.type.SetType(se.guidetome.entity.Informationblock.contents)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElementFactory] createEntityAssociation() : One to many - path = i.contents role = se.guidetome.entity.Informationblock.contents associatedEntityName = se.guidetome.entity.Content
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=2} : se.guidetome.entity.Content (c) -> contents9_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : i.contents -> gtm2.content contents9_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceCollection() : Created new FROM element for i.contents : gtm2.content contents9_
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : i.contents -> .
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] ImpliedFromElement: 'gtm2.content contents9_' ImpliedFromElement{implied,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=se.guidetome.entity.Informationblock.contents,tableName=gtm2.content,tableAlias=contents9_,origin=gtm2.informationblock informatio1_,colums={informatio1_.id ,className=se.guidetome.entity.Content}}
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g -> guide7_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : g.id -> guide7_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c -> contents9_.id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language -> org.hibernate.type.ManyToOneType(se.guidetome.entity.Language)
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property id in se.guidetome.entity.Content does not require a join.
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'language.id'
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language -> contents9_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : language.id -> org.hibernate.type.IntegerType@14a050
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : c.language.id -> contents9_.language_id
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} ( guide7_.id guide7_.id id ) ) ( FromClause{level=2} gtm2.guide guide7_ ) ( WHERE ( = ( contents9_.language_id ( contents9_.language_id contents9_.id language ) id ) ? ) ) )
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [gtm2.guide guide7_]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=2, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} guide0_.id contents2_.id geopositio5_.id informatio1_.id ) ( FromClause{level=1} ( gtm2.guide guide0_ ( gtm2.informationblock informatio1_ gtm2.content contents2_ ( gtm2.informationblock_mapmarker informatio3_ ( gtm2.mapmarker mapmarker4_ gtm2.geoposition geopositio5_ ) ) ) ) ) ( WHERE ( AND ( AND ( AND ( AND ( OR ( = ( contents2_.language_id ( contents2_.language_id contents2_.id language ) id ) ? ) ( = ( contents2_.language_id ( contents2_.language_id contents2_.id language ) id ) ( informatio1_.default_language_id ( informatio1_.default_language_id informatio1_.id language ) id ) ) ) ( is not null ( geopositio5_.latitude geopositio5_.id latitude ) ) ) ( is not null ( geopositio5_.longitude geopositio5_.id longitude ) ) ) ( not in ( contents2_.id contents2_.id id ) ( inList ( SELECT ( {select clause} ( content6_.id content6_.id id ) ) ( FromClause{level=2} gtm2.content content6_ ) ( WHERE ( <> ( content6_.language_id ( content6_.language_id content6_.id language ) id ) ? ) ) ) ) ) ) ( in ( guide0_.id guide0_.id id ) ( inList ( SELECT ( {select clause} ( guide7_.id guide7_.id id ) ) ( FromClause{level=2} gtm2.guide guide7_ ) ( WHERE ( = ( contents9_.language_id ( contents9_.language_id contents9_.id language ) id ) ? ) ) ) ) ) ) ) )
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [gtm2.guide guide0_]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join gtm2.content contents2_ on informatio1_.id=contents2_.informationblock_id]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join gtm2.informationblock_mapmarker informatio3_ on informatio1_.id=informatio3_.informationblock_id]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join gtm2.mapmarker mapmarker4_ on informatio3_.mapmarker_id=mapmarker4_.id]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join gtm2.geoposition geopositio5_ on mapmarker4_.geoposition_id=geopositio5_.id]
2008-11-26 15:25:58,291 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (gtm2.geoposition,gtm2.guide,gtm2.mapmarker,gtm2.content,gtm2.informationblock_mapmarker,gtm2.informationblock)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[ALIAS_REF] IdentNode: 'guide0_.id as id25_0_' {alias=g, className=se.guidetome.entity.Guide, tableAlias=guide0_}
| +-[ALIAS_REF] IdentNode: 'contents2_.id as id10_1_' {alias=c, className=se.guidetome.entity.Content, tableAlias=contents2_}
| +-[ALIAS_REF] IdentNode: 'geopositio5_.id as id24_2_' {alias=gp, className=se.guidetome.entity.Geoposition, tableAlias=geopositio5_}
| +-[ALIAS_REF] IdentNode: 'informatio1_.id as id33_3_' {alias=i, className=se.guidetome.entity.Informationblock, tableAlias=informatio1_}
| +-[SQL_TOKEN] SqlFragment: 'guide0_.informationblock_id as informat2_25_0_'
| +-[SQL_TOKEN] SqlFragment: 'contents2_.hits as hits10_1_, contents2_.presentation_image_id as presenta7_10_1_, contents2_.informationblock_id as informat8_10_1_, contents2_.language_id as language6_10_1_, contents2_.long_description as long3_10_1_, contents2_.short_description as short4_10_1_, contents2_.title as title10_1_'
| +-[SQL_TOKEN] SqlFragment: 'geopositio5_.latitude as latitude24_2_, geopositio5_.longitude as longitude24_2_, geopositio5_.name as name24_2_'
| \-[SQL_TOKEN] SqlFragment: 'informatio1_.created_date as created2_33_3_, informatio1_.default_language_id as default5_33_3_, informatio1_.offset as offset33_3_, informatio1_.publish_status as publish4_33_3_'
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=6, fromElements=6, fromElementByClassAlias=[g, c, im, gp, i], fromElementByTableAlias=[informatio3_, guide0_, informatio1_, geopositio5_, mapmarker4_, contents2_], fromElementsByPath=[im.mapmarker.geoposition, i.informationblockMapmarkers, im.mapmarker, g.informationblock, i.contents], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'gtm2.guide guide0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=g,role=null,tableName=gtm2.guide,tableAlias=guide0_,origin=null,colums={,className=se.guidetome.entity.Guide}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=i,role=null,tableName=gtm2.informationblock,tableAlias=informatio1_,origin=gtm2.guide guide0_,colums={guide0_.informationblock_id ,className=se.guidetome.entity.Informationblock}}
| +-[JOIN_FRAGMENT] FromElement: 'inner join gtm2.content contents2_ on informatio1_.id=contents2_.informationblock_id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=se.guidetome.entity.Informationblock.contents,tableName=gtm2.content,tableAlias=contents2_,origin=inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id,colums={informatio1_.id ,className=se.guidetome.entity.Content}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join gtm2.informationblock_mapmarker informatio3_ on informatio1_.id=informatio3_.informationblock_id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=im,role=se.guidetome.entity.Informationblock.informationblockMapmarkers,tableName=gtm2.informationblock_mapmarker,tableAlias=informatio3_,origin=inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id,colums={informatio1_.id ,className=se.guidetome.entity.InformationblockMapmarker}}
| \-[JOIN_FRAGMENT] ImpliedFromElement: 'inner join gtm2.mapmarker mapmarker4_ on informatio3_.mapmarker_id=mapmarker4_.id' ImpliedFromElement{implied in FROM clause,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=gtm2.mapmarker,tableAlias=mapmarker4_,origin=inner join gtm2.informationblock_mapmarker informatio3_ on informatio1_.id=informatio3_.informationblock_id,colums={informatio3_.mapmarker_id ,className=se.guidetome.entity.Mapmarker}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join gtm2.geoposition geopositio5_ on mapmarker4_.geoposition_id=geopositio5_.id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=gp,role=null,tableName=gtm2.geoposition,tableAlias=geopositio5_,origin=inner join gtm2.mapmarker mapmarker4_ on informatio3_.mapmarker_id=mapmarker4_.id,colums={mapmarker4_.geoposition_id ,className=se.guidetome.entity.Geoposition}}
\-[WHERE] SqlNode: 'WHERE'
\-[AND] SqlNode: 'AND'
+-[AND] SqlNode: 'AND'
| +-[AND] SqlNode: 'AND'
| | +-[AND] SqlNode: 'AND'
| | | +-[OR] SqlNode: 'OR'
| | | | +-[EQ] BinaryLogicOperatorNode: '='
| | | | | +-[DOT] DotNode: 'contents2_.language_id' {propertyName=id,dereferenceType=4,propertyPath=language.id,path=c.language.id,tableAlias=contents2_,className=se.guidetome.entity.Content,classAlias=c}
| | | | | | +-[DOT] DotNode: 'contents2_.language_id' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=language.id,path=c.language,tableAlias=contents2_,className=se.guidetome.entity.Content,classAlias=c}
| | | | | | | +-[ALIAS_REF] IdentNode: 'contents2_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=contents2_}
| | | | | | | \-[IDENT] IdentNode: 'language' {originalText=language}
| | | | | | \-[IDENT] IdentNode: 'id' {originalText=id}
| | | | | \-[NAMED_PARAM] ParameterNode: '?' {name=guideLanguageID, expectedType=org.hibernate.type.IntegerType@14a050}
| | | | \-[EQ] BinaryLogicOperatorNode: '='
| | | | +-[DOT] DotNode: 'contents2_.language_id' {propertyName=id,dereferenceType=4,propertyPath=language.id,path=c.language.id,tableAlias=contents2_,className=se.guidetome.entity.Content,classAlias=c}
| | | | | +-[DOT] DotNode: 'contents2_.language_id' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=language.id,path=c.language,tableAlias=contents2_,className=se.guidetome.entity.Content,classAlias=c}
| | | | | | +-[ALIAS_REF] IdentNode: 'contents2_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=contents2_}
| | | | | | \-[IDENT] IdentNode: 'language' {originalText=language}
| | | | | \-[IDENT] IdentNode: 'id' {originalText=id}
| | | | \-[DOT] DotNode: 'informatio1_.default_language_id' {propertyName=id,dereferenceType=4,propertyPath=language.id,path=i.language.id,tableAlias=informatio1_,className=se.guidetome.entity.Informationblock,classAlias=i}
| | | | +-[DOT] DotNode: 'informatio1_.default_language_id' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=language.id,path=i.language,tableAlias=informatio1_,className=se.guidetome.entity.Informationblock,classAlias=i}
| | | | | +-[ALIAS_REF] IdentNode: 'informatio1_.id' {alias=i, className=se.guidetome.entity.Informationblock, tableAlias=informatio1_}
| | | | | \-[IDENT] IdentNode: 'language' {originalText=language}
| | | | \-[IDENT] IdentNode: 'id' {originalText=id}
| | | \-[IS_NOT_NULL] UnaryLogicOperatorNode: 'is not null'
| | | \-[DOT] DotNode: 'geopositio5_.latitude' {propertyName=latitude,dereferenceType=4,propertyPath=latitude,path=gp.latitude,tableAlias=geopositio5_,className=se.guidetome.entity.Geoposition,classAlias=gp}
| | | +-[ALIAS_REF] IdentNode: 'geopositio5_.id' {alias=gp, className=se.guidetome.entity.Geoposition, tableAlias=geopositio5_}
| | | \-[IDENT] IdentNode: 'latitude' {originalText=latitude}
| | \-[IS_NOT_NULL] UnaryLogicOperatorNode: 'is not null'
| | \-[DOT] DotNode: 'geopositio5_.longitude' {propertyName=longitude,dereferenceType=4,propertyPath=longitude,path=gp.longitude,tableAlias=geopositio5_,className=se.guidetome.entity.Geoposition,classAlias=gp}
| | +-[ALIAS_REF] IdentNode: 'geopositio5_.id' {alias=gp, className=se.guidetome.entity.Geoposition, tableAlias=geopositio5_}
| | \-[IDENT] IdentNode: 'longitude' {originalText=longitude}
| \-[NOT_IN] InLogicOperatorNode: 'not in'
| +-[DOT] DotNode: 'contents2_.id' {propertyName=id,dereferenceType=4,propertyPath=id,path=c.id,tableAlias=contents2_,className=se.guidetome.entity.Content,classAlias=c}
| | +-[ALIAS_REF] IdentNode: 'contents2_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=contents2_}
| | \-[IDENT] IdentNode: 'id' {originalText=id}
| \-[IN_LIST] SqlNode: 'inList'
| \-[SELECT] QueryNode: 'SELECT' querySpaces (gtm2.geoposition,gtm2.guide,gtm2.mapmarker,gtm2.content,gtm2.informationblock_mapmarker,gtm2.informationblock)
| +-[SELECT_CLAUSE] SelectClause: '{select clause}'
| | \-[DOT] DotNode: 'content6_.id' {propertyName=id,dereferenceType=4,propertyPath=id,path=c.id,tableAlias=content6_,className=se.guidetome.entity.Content,classAlias=c}
| | +-[ALIAS_REF] IdentNode: 'content6_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=content6_}
| | \-[IDENT] IdentNode: 'id' {originalText=id}
| +-[FROM] FromClause: 'FROM' FromClause{level=2, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[c], fromElementByTableAlias=[content6_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| | \-[FROM_FRAGMENT] FromElement: 'gtm2.content content6_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=null,tableName=gtm2.content,tableAlias=content6_,origin=null,colums={,className=se.guidetome.entity.Content}}
| \-[WHERE] SqlNode: 'WHERE'
| \-[NE] BinaryLogicOperatorNode: '<>'
| +-[DOT] DotNode: 'content6_.language_id' {propertyName=id,dereferenceType=4,propertyPath=language.id,path=c.language.id,tableAlias=content6_,className=se.guidetome.entity.Content,classAlias=c}
| | +-[DOT] DotNode: 'content6_.language_id' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=language.id,path=c.language,tableAlias=content6_,className=se.guidetome.entity.Content,classAlias=c}
| | | +-[ALIAS_REF] IdentNode: 'content6_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=content6_}
| | | \-[IDENT] IdentNode: 'language' {originalText=language}
| | \-[IDENT] IdentNode: 'id' {originalText=id}
| \-[NAMED_PARAM] ParameterNode: '?' {name=guideLanguageID, expectedType=org.hibernate.type.IntegerType@14a050}
\-[IN] InLogicOperatorNode: 'in'
+-[DOT] DotNode: 'guide0_.id' {propertyName=id,dereferenceType=4,propertyPath=id,path=g.id,tableAlias=guide0_,className=se.guidetome.entity.Guide,classAlias=g}
| +-[ALIAS_REF] IdentNode: 'guide0_.id' {alias=g, className=se.guidetome.entity.Guide, tableAlias=guide0_}
| \-[IDENT] IdentNode: 'id' {originalText=id}
\-[IN_LIST] SqlNode: 'inList'
\-[SELECT] QueryNode: 'SELECT' querySpaces (gtm2.geoposition,gtm2.guide,gtm2.mapmarker,gtm2.content,gtm2.informationblock_mapmarker,gtm2.informationblock)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| \-[DOT] DotNode: 'guide7_.id' {propertyName=id,dereferenceType=4,propertyPath=id,path=g.id,tableAlias=guide7_,className=se.guidetome.entity.Guide,classAlias=g}
| +-[ALIAS_REF] IdentNode: 'guide7_.id' {alias=g, className=se.guidetome.entity.Guide, tableAlias=guide7_}
| \-[IDENT] IdentNode: 'id' {originalText=id}
+-[FROM] FromClause: 'FROM' FromClause{level=2, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[g, c, i], fromElementByTableAlias=[contents9_, guide7_], fromElementsByPath=[i.contents], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'gtm2.guide guide7_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=g,role=null,tableName=gtm2.guide,tableAlias=guide7_,origin=null,colums={,className=se.guidetome.entity.Guide}}
\-[WHERE] SqlNode: 'WHERE'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'contents9_.language_id' {propertyName=id,dereferenceType=4,propertyPath=language.id,path=c.language.id,tableAlias=contents9_,className=se.guidetome.entity.Content,classAlias=c}
| +-[DOT] DotNode: 'contents9_.language_id' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=language.id,path=c.language,tableAlias=contents9_,className=se.guidetome.entity.Content,classAlias=c}
| | +-[ALIAS_REF] IdentNode: 'contents9_.id' {alias=c, className=se.guidetome.entity.Content, tableAlias=contents9_}
| | \-[IDENT] IdentNode: 'language' {originalText=language}
| \-[IDENT] IdentNode: 'id' {originalText=id}
\-[NAMED_PARAM] ParameterNode: '?' {name=guideLanguageID, expectedType=org.hibernate.type.IntegerType@14a050}
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: SELECT g,c,gp,i FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c JOIN i.informationblockMapmarkers im JOIN im.mapmarker.geoposition gp WHERE (c.language.id=:guideLanguageID OR c.language.id=i.language.id) AND gp.latitude IS NOT NULL AND gp.longitude IS NOT NULL AND c.id NOT IN (SELECT c.id FROM se.guidetome.entity.Content c WHERE c.language.id<>:guideLanguageID) AND g.id IN (SELECT g.id FROM se.guidetome.entity.Guide g JOIN g.informationblock i JOIN i.contents c WHERE c.language.id=:guideLanguageID)
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select guide0_.id as id25_0_, contents2_.id as id10_1_, geopositio5_.id as id24_2_, informatio1_.id as id33_3_, guide0_.informationblock_id as informat2_25_0_, contents2_.hits as hits10_1_, contents2_.presentation_image_id as presenta7_10_1_, contents2_.informationblock_id as informat8_10_1_, contents2_.language_id as language6_10_1_, contents2_.long_description as long3_10_1_, contents2_.short_description as short4_10_1_, contents2_.title as title10_1_, geopositio5_.latitude as latitude24_2_, geopositio5_.longitude as longitude24_2_, geopositio5_.name as name24_2_, informatio1_.created_date as created2_33_3_, informatio1_.default_language_id as default5_33_3_, informatio1_.offset as offset33_3_, informatio1_.publish_status as publish4_33_3_ from gtm2.guide guide0_ inner join gtm2.informationblock informatio1_ on guide0_.informationblock_id=informatio1_.id inner join gtm2.content contents2_ on informatio1_.id=contents2_.informationblock_id inner join gtm2.informationblock_mapmarker informatio3_ on informatio1_.id=informatio3_.informationblock_id inner join gtm2.mapmarker mapmarker4_ on informatio3_.mapmarker_id=mapmarker4_.id inner join gtm2.geoposition geopositio5_ on mapmarker4_.geoposition_id=geopositio5_.id where (contents2_.language_id=? or contents2_.language_id=informatio1_.default_language_id) and (geopositio5_.latitude is not null) and (geopositio5_.longitude is not null) and (contents2_.id not in (select content6_.id from gtm2.content content6_ where content6_.language_id<>?)) and (guide0_.id in (select guide7_.id from gtm2.guide guide7_ where contents9_.language_id=?))
2008-11-26 15:25:58,307 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
Login
FAQ
Search