Relationship Queries not Supported - Plus, ...

peterson.dean · **Joined:** Sun Nov 30, 2014 1:43 pm **Posts:** 8

I am trying to use the following query:

Code:

public CollectionItem getCollectionItemByItemId(String id)
   {
      
      String nativeQuery = "{'item_id':{'$oid' : '" + id + "'}}";
      //javax.persistence.Query q = em.createQuery("SELECT item FROM CollectionItem ci WHERE ci.item.id = '" + id + "'");
      
      try
      {
         javax.persistence.Query query = em.createNativeQuery(nativeQuery, CollectionItem.class);
         return (CollectionItem)query.getSingleResult();
      }
      catch(NoResultException e)
      {
         //no result
      }
      
      return null;
   }

The commented out code is a query that is currently not supported. Unfortunately, when I switch to the native query, I run into the existing error of not being able to execute multiple native queries in a single request. That causes the error: "cannot associate the collection with multiple sessions" error. I tried to pull down the latest OGM code and build it to see if some of these issues have been resolved but I ran into trouble there as well.

peterson.dean · **Joined:** Sun Nov 30, 2014 1:43 pm **Posts:** 8

I was finally able to wade through the build issues I was having and use the latest SNAPSHOT to get past this problem.

Gunnar · **Joined:** Sat Jan 24, 2009 12:46 pm **Posts:** 388

Ok, cool! That issue you run into is https://hibernate.atlassian.net/browse/OGM-638, glad to hear that the fix on master works for you. Will be part of the upcoming RC1 release.

--Gunnar

emmanuel · **Posted:** Thu Dec 11, 2014 3:47 am

For your info, the CR1 fixing your problem has been released.