-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 7 posts ] 
  Previous topic | Next topic 
Author Message
ynnor
 Post subject: path expression ends in composite value
PostPosted: Thu Feb 24, 2005 5:22 am 
Newbie

Joined: Mon Jan 17, 2005 9:23 am
Posts: 15
Hey Hibernate experts,

What's wrong about this query? Thanks for any hints...

select count(l) from WebEintragLang as l
join l.eintrag as e
join l.language as lang
join e.kategorie as kat
where lang.code=:langCode
and l.visible=1
and kat.id=:kategorieID

Hibernate version: 2.1.7

Full stack trace of any exception that occurs:
path expression ends in a composite value: webeintrag36_ [
select count(l) from sps.data.WebEintragLang as l
join l.eintrag as e
join l.language as lang
join e.kategorie as kat
where lang.code=:langCode
and l.visible=1
and kat.id=:kategorieID
]
net.sf.hibernate.QueryException: path expression ends in a composite value: webeintrag36_ [
select count(l) from sps.data.WebEintragLang as l
join l.eintrag as e
join l.language as lang
join e.kategorie as kat
where lang.code=:langCode
and l.visible=1
and kat.id=:kategorieID
]
at net.sf.hibernate.hql.PathExpressionParser.getWhereColumn(PathExpressionParser.java:375)
at net.sf.hibernate.hql.SelectParser.token(SelectParser.java:160)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.ClauseParser.end(ClauseParser.java:114)
at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:143)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1571)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1542)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:550)

Name and version of the database you are using: Firebird 1.5

The generated SQL (show_sql=true): none
Top
 Profile  
 
ynnor
 Post subject:
PostPosted: Thu Feb 24, 2005 5:23 am 
Newbie

Joined: Mon Jan 17, 2005 9:23 am
Posts: 15
The exact same query, with select l instead of count(l) works fine.
Top
 Profile  
 
ynnor
 Post subject:
PostPosted: Thu Feb 24, 2005 1:27 pm 
Newbie

Joined: Mon Jan 17, 2005 9:23 am
Posts: 15
*BUMP*

Please help! Even more additional info:

lang.code is a String, like "de", "en", "fr", etc.
kategorieID is an Integer.
Top
 Profile  
 
michael
 Post subject:
PostPosted: Thu Feb 24, 2005 3:08 pm 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
No idea how to help you, because we don't have your mappings.
Top
 Profile  
 
ynnor
 Post subject:
PostPosted: Fri Feb 25, 2005 10:38 am 
Newbie

Joined: Mon Jan 17, 2005 9:23 am
Posts: 15
OK, this is my mapping. It is quite a lot of stuff but I think you might need all of this to fully understand my query. Thanks a lot for your help!

Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
   <class name="sps.data.WebEintrag" table="WEB_EINTRAG" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <id name="id" column="eintrag_id" type="int">
         <generator class="sequence" />
      </id>
      <property name="timestamp" column="creation_timestamp" type="timestamp" />
      <property name="name" type="string" />

      <many-to-one name="kategorie" class="sps.data.WebKategorie" column="kategorie_id" not-null="true" />
      <many-to-one name="image" class="sps.data.WebImage" column="image_id" />
       
        <set name="languages" outer-join="false" inverse="true" cascade="all" lazy="true" >
         <key column="eintrag_id" />
         <one-to-many class="sps.data.WebEintragLang" />
        </set>
    </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
    <class name="sps.data.WebEintragLang" table="WEB_EINTRAG_LANG" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <composite-id>
         <key-many-to-one name="eintrag" class="sps.data.WebEintrag" column="eintrag_id" />
           <key-many-to-one name="language" class="sps.data.WebLanguage" column="language_id" />
        </composite-id>
      <property name="titel" type="string" />
      <property name="teaser" type="string" />
      <property name="text" type="text" column="main_text"/>
      
      <!-- firebird does not like column name=timestamp -->
      <property name="timestamp" column="creation_timestamp" type="timestamp" />
      <property name="visible" type="boolean" />
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="false" default-access="property" default-cascade="none">
    <class name="sps.data.WebKategorie" table="WEB_KATEGORIE" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <id name="id" type="int">
         <generator class="sequence" />
      </id>
      <property name="name" type="string" />
      <many-to-one name="section" class="sps.data.WebSection" column="section_id" not-null="true" />
      
        <set name="languages" outer-join="false" inverse="true" cascade="all" lazy="true">
         <key column="kategorie_id" />
         <one-to-many class="sps.data.WebKategorieLang" />
        </set>
        <set name="eintraege" outer-join="false" inverse="true" cascade="all" lazy="true">
           <key column="kategorie_id" />
           <one-to-many class="sps.data.WebEintrag" />
        </set>
    </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
   
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
    <class name="sps.data.WebKategorieLang" table="WEB_KATEGORIE_LANG" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <composite-id>
         <key-many-to-one name="kategorie" class="sps.data.WebKategorie" column="kategorie_id" />
           <key-many-to-one name="language" class="sps.data.WebLanguage" column="language_id" />
        </composite-id>
      <property name="name" type="string" />
      <property name="text" type="text" />
      <property name="visible" type="boolean" />
   </class>
</hibernate-mapping>      


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
    <class name="sps.data.WebLanguage" table="WEB_LANGUAGE" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <id name="id" column="language_id" type="int">
         <generator class="sequence"/>
      </id>
      <property name="name" type="string" />
      <property name="code" type="string" />

        <set name="sections" lazy="true" outer-join="false" inverse="true" cascade="none">
         <key column="language_id" />
         <one-to-many class="sps.data.WebSectionLang" />         
        </set>
        <set name="kategorien" lazy="true" outer-join="false" inverse="true" cascade="none">
         <key column="language_id" />
         <one-to-many class="sps.data.WebKategorieLang" />         
        </set>
        <set name="eintraege" lazy="true" outer-join="false" inverse="true" cascade="none">
         <key column="language_id" />
         <one-to-many class="sps.data.WebEintragLang" />         
        </set>
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
    <class name="sps.data.WebSection" table="WEB_SECTION" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
        <id name="id" column="section_id" type="int">
            <generator class="sequence" />
        </id>
        <set name="languages" outer-join="false" inverse="true" cascade="all" lazy="true">
         <key column="section_id" />
         <one-to-many class="sps.data.WebSectionLang" />
        </set>
        <set name="kategorien" outer-join="false" inverse="true" cascade="all" lazy="true">
           <key column="section_id" />
           <one-to-many class="sps.data.WebKategorie" />
        </set>
        <property name="name" type="string" />
    </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
   
<hibernate-mapping auto-import="true" default-access="property" default-cascade="none">
   <class name="sps.data.WebSectionLang" table="WEB_SECTION_LANG" batch-size="1" mutable="true" dynamic-update="false" polymorphism="implicit" optimistic-lock="version" dynamic-insert="false" select-before-update="false">
      <composite-id>
         <key-many-to-one name="section" class="sps.data.WebSection" column="section_id" />
         <key-many-to-one name="language" class="sps.data.WebLanguage" column="language_id" />
      </composite-id>
      <property name="name" type="string" />
      <property name="text" type="text" />      
      <property name="visible" type="boolean" />
   </class>
</hibernate-mapping>      
Top
 Profile  
 
ynnor
 Post subject:
PostPosted: Mon Feb 28, 2005 6:25 am 
Newbie

Joined: Mon Jan 17, 2005 9:23 am
Posts: 15
PLEASE! Can someone have a look at this?
Top
 Profile  
 
infinitum
 Post subject: use count(*) instead of count(l)
PostPosted: Thu Sep 22, 2005 8:50 am 
Newbie

Joined: Thu Sep 22, 2005 8:17 am
Posts: 1
ynnor wrote:
PLEASE! Can someone have a look at this?


use count(*) instead of count(l)
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 7 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.