Problem using find method with composite-id based query

matiello · **Posted:** Fri Jan 30, 2004 5:22 pm

Hello.

I'm new to Hibernate.
I'm having problem on performing a query using a composite-id key. My schema was generated by Middle-Gen.

I'm using the following query:

Code:

String id="10";
List params = s.find("from Parameter as parameter where parameter.comp_id.id = ?",id,Hibernate.STRING);

Following is the hbm map file:

Code:

<class 
    name="com.test.Parameter" 
    table="PARAMETERS"
>
    <composite-id name="comp_id" class="com.test.ParameterPK">
        <key-property 
            name="id" 
            column="ID" 
            type="java.lang.String"
            length="30"
        />
        <key-property 
            name="value" 
            column="VALUE" 
            type="java.lang.String"
            length="40"
        />
    </composite-id>    
    <property
        name="description"
        type="java.lang.String"
        column="DESCRIPTION"
        length="50"
    />
</class>

When executing, it throws the following exception:

Code:

net.sf.hibernate.QueryException: unexpected token: as [from Parameter as parameter where parameter.comp_id.id = ?]
        at net.sf.hibernate.hql.FromParser.token(FromParser.java:94)
        at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
        at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
        at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
        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:293)
        at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1493)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1464)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1454)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1450)

Does anybody knows what I'm doing wrong?

Regards,

Flavio Matiello

l.masini · **Posted:** Fri Jan 30, 2004 6:01 pm

Usually this happen when you don't have an import or an alias for your class.
What about them in your mapping/configuration ?
Ciao.

emmanuel · **Posted:** Sat Jan 31, 2004 7:46 am

Full class name

Code:

from com.test.Parameter

matiello · **Posted:** Mon Feb 02, 2004 8:54 am

[quote="l.masini"]Usually this happen when you don't have an import or an alias for your class.
What about them in your mapping/configuration ?
Ciao.[/quote]

Perfect. I've forgotten to put this file in the hibernate.xml.cfg file. My lack of attention.

Thxs.

matiello · **Posted:** Mon Feb 02, 2004 8:58 am

[quote="emmanuel"]Full class name
[code]from com.test.Parameter[/code][/quote]

It worked without the full class name. It is OK not to use the full class name? I'm asking this to avoid further compatiblity problems on a possible new Hibernate version upgrade.

Regards,

Fl

michael · **Posted:** Mon Feb 02, 2004 9:04 am

Yes it should be okay. However somtimes some peoples problems get fixed by using the complete class name, so keep that in mind if you are seraching for errors later.

emmanuel · **Posted:** Mon Feb 02, 2004 9:21 am

The full class name is required when several classes have the same name.