Hibernate Community • View topic - Criteria Query with EmbeddedId -> "Unknown Column" Error

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria Query with EmbeddedId -> "Unknown Column" Error

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

elexx

Post subject: Criteria Query with EmbeddedId -> "Unknown Column" Error

Posted: Tue Sep 21, 2010 1:02 pm

Newbie

Joined: Tue Sep 21, 2010 12:43 pm
Posts: 6

Hello!

I would be pleased if you could help me with an issue that seems quite strange to me. I'm new to Hibernate, so please excuse me if it is a dumb question.

I have the Java classes "PropertyNameEntity" and "PropertyValueEntity".
The class "PropertyValueEntity" has an EmbeddedId referencing a class called "PropertyValuePK". This EmbeddedId class contains a ManyToOne Association to the class "PropertyNameEntity".

Everything is working fine, but a problem arises when I want to execute the following Hibernate Criteria Query:

Code:

crit = session
        .createCriteria(PropertyValueEntity.class)
        .createCriteria("propertyValuePK")
        .createCriteria("propertyNameEntity")
           .add(Restrictions.like("name", "GSM"));

I get the following error:

Code:

WARNUNG: SQL Error: 1054, SQLState: 42S22
21.09.2010 18:41:17 org.hibernate.util.JDBCExceptionReporter logExceptions
SCHWERWIEGEND: Unknown column 'propertyna2_.name' in 'where clause'
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query

The "createCriteria" statements are working. The error only arises when I add the "Restriction" to the criteria.

Thank u for any information!

Top

elexx

Post subject: Re: Criteria Query with EmbeddedId -> "Unknown Column" Error

Posted: Wed Sep 22, 2010 7:43 am

Newbie

Joined: Tue Sep 21, 2010 12:43 pm
Posts: 6

I still have no idea how to solve this problem. I tried the same query in HQL, and this is working:

Code:

from PropertyValueEntity where propertyValuePK.propertyNameEntity.name like 'GSM'

But no progress with the Criteria query. I've already tried setFetchMode and createAlias, but nothings working.

I've set the "show_sql" property to true, which shows, that the following SQL is produced from the Criteria Query:

Code:

Hibernate: /* criteria query */ select this_.artikelId as artikelId8_0_, this_.eigenschaftsNameId as eigensch3_8_0_, this_.eigenschaftsWert as eigensch2_8_0_ from haym_info.eigenschaftswert this_ where propertyna2_.name=?

Why the Criteria query does not result in a Join?

Top

elexx

Post subject: Re: Criteria Query with EmbeddedId -> "Unknown Column" Error

Posted: Wed Sep 22, 2010 7:47 am

Newbie

Joined: Tue Sep 21, 2010 12:43 pm
Posts: 6

Here is my code of the Embeddable class:

Code:

@Embeddable
public class PropertyValuePK implements Serializable {
    private Long articleId;

    @Basic
    @Column(name = "artikelId")
    public Long getArticleId() {
        return articleId;
    }

    public void setArticleId(Long articleId) {
        this.articleId = articleId;
    }

    private PropertyNameEntity propertyNameEntity;

    @ManyToOne
    @JoinColumn(name = "eigenschaftsNameId")
    public PropertyNameEntity getPropertyNameEntity() {
        return propertyNameEntity;
    }

    public void setPropertyNameEntity(PropertyNameEntity propertyNameEntity) {
        this.propertyNameEntity = propertyNameEntity;
    }

... equals ...

... hashCode ...

Top

danielkraus

Post subject: Re: Criteria Query with EmbeddedId -> "Unknown Column" Error

Posted: Wed Jan 02, 2013 12:57 pm

Newbie

Joined: Fri Nov 23, 2012 2:04 pm
Posts: 2

Hi, I have same problem in my application, you find any solution?

Top

Page 1 of 1

[ 4 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