Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of bdusausoy@yp5.be designates
 91.121.85.197 as permitted sender)
Message-ID: <4F749AC4.5040708@yp5.be>
Date: Thu, 29 Mar 2012 19:24:20 +0200
From: Bruno Dusausoy <bdusausoy@yp5.be>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: OpenJPA Users <users@openjpa.apache.org>
Subject: Join fetch not working properly
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I have a problem with the "join fetch" JPQL clause (OpenJPA 2.1.1).

The SQL executed underneath is ok, the "joins" are done and if I 
copy/paste the generated SQL request in SQL Server 2005, it returns the 
right results : right number of records, right number of columns, ...
But it seems there's a problem with the "mapping"; OpenJPA forgets 
somehow to map the Operation columns back to an entity.
My operation are always null.

Do I have to specify something to OpenJPA in order to force it to map 
the Operation entity ?

Here's the snippet for my entity :

@Entity
@Table(name = "PDrawingMapItems")
public class DrawingMapItem {

     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
     @Column(name = "Id")
     private Long id;

     @ManyToOne(fetch = FetchType.LAZY)
     @JoinColumn(name = "OperationId")
     private Operation operation;

     @ManyToMany(fetch = FetchType.EAGER)
     @JoinTable(
             name = "PDrawingMapItemMarkingLevels",
             joinColumns = {@JoinColumn(name = "ItemId")},
             inverseJoinColumns = {@JoinColumn(name = "MarkingId")}
     )
     private List<MarkingLevel> markingLevels;

     @Enumerated(EnumType.STRING)
     private TraceabilityType traceabilityType;

     @ManyToOne
     @JoinColumn(name = "DrawingMapId")
     private DrawingMap drawingMap;

     // Getters and setters omitted
}

And here's what I'm trying to execute :

private List<DrawingMapItem> 
getDrawingMapItemsWithOperationsByDrawingMapId(Long mapId) {
         final String queryString = "select dmi from DrawingMapItem dmi 
join fetch dmi.operation where dmi.drawingMap.id = :mapId order by dmi.id";
         List<DrawingMapItem> mapItems =
                 entityManager.createQuery(queryString, 
DrawingMapItem.class).setParameter("mapId", mapId).getResultList();
         return mapItems;
}

Regards.
-- 
Bruno Dusausoy
Software engineer
YP5 Software
--
Pensez environnement : limitez l'impression de ce mail.
Please don't print this e-mail unless you really need to.