Hibernate Community • View topic - simple query syntax problem: entity not in entity.collection

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

simple query syntax problem: entity not in entity.collection

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

chiara

Post subject: simple query syntax problem: entity not in entity.collection

Posted: Mon Aug 31, 2009 1:30 pm

Newbie

Joined: Mon Aug 31, 2009 1:19 pm
Posts: 11

Hello, I have a query like this:

Code:

select e from MyEntity e where :otherEntity not in e.myCollection

But I cannot get it work. It throws an SQL syntax error.

Quote:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1:

Here is the SQL as is shown by Hibernate:

Code:

    select
        myEntity0_.id as id12_,
        myEntity0_.nombre as nombre12_,
    from
        MyEntity myEntity0_,
        MyEntity_MyEntity myColl1_,
        MyEntity myEntity2_ 
    where
        myEntity0_.id= myColl1_.e1_id 
        and myColl1_.e2_id=myEntity2_.id 
        and (
            ? not in  (
                .
            )
        )

could anyone help me?

Regards,
Chiara

Top

chiara

Post subject: Re: simple query syntax problem: entity not in entity.collection

Posted: Thu Oct 01, 2009 2:55 pm

Newbie

Joined: Mon Aug 31, 2009 1:19 pm
Posts: 11

the solution is using elements:

Code:

select e from MyEntity e where :otherEntity not in elements(e.myCollection)

Top

Page 1 of 1

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