This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Can anyone tell why is this query not valid? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Can anyone tell why is this query not valid?" Watch "Can anyone tell why is this query not valid?" New topic
Author

Can anyone tell why is this query not valid?

Eduardo Born
Greenhorn

Joined: Oct 26, 2010
Posts: 3
Hello!
I have criteria query that, when executed, results the following exception thrown:



The id attribute is the entity's attribute which was annotated with @Id @GeneratedValue. Basically I'm trying to load the attribute "permissions", which is a collection uninitialized at the time, for the role object whose id is 2. The id attribute is of long type.

Any ideas on why this query would fail?

It seems correct to me...

I can post the code that creates the criteria query here, but it is fairly complicated (as it generates based on a LDAP filter, etc), so I'm hoping the error will be visible from the generated query string and the exception. Please let me know if that's not the case.

Thanks!!
Eduardo Born
Eduardo Born
Greenhorn

Joined: Oct 26, 2010
Posts: 3
Some more information...

The criteria query that generated this error was built this way:




The Role and Permission classes have been mapped with JPA and some Hibernate annotations like this:





I was expecting the call to typedQuery.getResultList() to return a list of collections with just one element: the collection of permission objects for the role with id = 2. This is an attempt to select just the "permissions" collection from the object role with id = 2.

I'm new to criteria queries and I'm having a hard time finding what's wrong with it.

What would be the correct criteria query to accomplish this?

Thank you!!

Eduardo
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can anyone tell why is this query not valid?
 
Similar Threads
Exception when accessing Javaranch
Unable to locate appropriate constructor
Can anyone tell why is this query not valid?
MySQL + Hibernate: HTTP servlet broken pipe with entity manager
@ManyToMany delete problem