[EL Fine]: ClientSession(15830327)--Connection(29407392)--SELECT FKFOGGUID, FNR_FR, AREANR FROM AREA WHERE (FKFOGGUID = ?)
	bind => [859269b6-5200-49ab-b47f-785c4c305d4d]

@Entity
public class AreaSurface {
  
  @Id
  @Column(name = "GUID")
  private String uuid;
  
  @StructConverter(name = "GeometryConverter",
      converter = ConverterType.GEOMETRY_CONVERTER)
  @Convert("GeometryConverter")
  @Column(name = "SHAPE", columnDefinition = "MDSYS.SDO_GEOMETRY", nullable = false)
  private Geometry geometry;
  
  @OneToMany(mappedBy = "areaSurface") //if fetch = FetchType.EAGER is set it works
  private List<Area> areas;

  // Getters and setters..
  
}

@Entity
public class Area{
  
  @Id
  @Column(name = "FKFOGGUID")
  private String fkfogguid;
  
  @Column(name = "FNR_FR", insertable = false, updatable = false)
  private String areaId;
  
  @Column(name = "AREANR")
  private int areaNumber;
  
  @ManyToOne()
  @JoinColumn(name = "FKFOGGUID", referencedColumnName = "GUID", insertable = false, updatable = false)
  private AreaSurface areaSurface;
  
  // ...
  
}

[EL Finest]: UnitOfWork(3966697)--Execute query ReadAllQuery(referenceClass=AreaSurface )
[EL Finest]: ClientSession(32314330)--Execute query ReadAllQuery(referenceClass=AreaSurface)
[EL Fine]: ClientSession(32314330)--Connection(5511938)--SELECT GUID, SHAPE FROM AREA_SURFACE WHERE ((MDSYS.SDO_FILTER(SHAPE, ?, ?) = ?) AND (MDSYS.SDO_RELATE(SHAPE, ?, ?) = ?))
	bind => [JGeometry (gtype=1, dim=2, srid=3006, QUERYTYPE=WINDOW, TRUE, JGeometry (gtype=1, dim=2, srid=3006, MASK=ANYINTERACT QUERYTYPE=WINDOW, TRUE]
[EL Finest]: ClientSession(32314330)--Execute query ReadAllQuery(name="areas" referenceClass=Area sql="SELECT FKFOGGUID, FNR_FR, AREANR FROM AREA WHERE (FKFOGGUID = ?)")
[EL Fine]: ClientSession(32314330)--Connection(5511938)--SELECT FKFOGGUID, FNR_FR, AREANR FROM AREA WHERE (FKFOGGUID = ?))
	bind => [859269b6-5200-49ab-b47f-785c4c305d4d]
[EL Finest]: ClientSession(32314330)--Execute query ReadObjectQuery(name="areaSurface" referenceClass=AreaSurface )
[EL Finer]: UnitOfWork(3966697)--release unit of work
[EL Finer]: ClientSession(32314330)--Connection(5511938)--rollback transaction
[EL Finer]: ClientSession(32314330)--client released

[EL Finest]: UnitOfWork(26193147)--Execute query ReadAllQuery(referenceClass=AreaSurface )
[EL Finest]: ClientSession(32579087)--Execute query ReadAllQuery(referenceClass=AreaSurface )
[EL Fine]: ClientSession(32579087)--Connection(27595538)--SELECT GUID, SHAPE FROM AREA_SURFACE WHERE ((MDSYS.SDO_FILTER(SHAPE, ?, ?) = ?) AND (MDSYS.SDO_RELATE(SHAPE, ?, ?) = ?))
	bind => [JGeometry (gtype=1, dim=2, srid=3006, QUERYTYPE=WINDOW, TRUE, JGeometry (gtype=1, dim=2, srid=3006, MASK=ANYINTERACT QUERYTYPE=WINDOW, TRUE]
[EL Finest]: ServerSession(22238933)--Execute query ReadAllQuery(name="areas" referenceClass=Area )
[EL Finest]: ServerSession(22238933)--reconnecting to external connection pool
[EL Fine]: ServerSession(22238933)--Connection(1399004)--SELECT FKFOGGUID, FNR_FR, AREANR FROM AREA WHERE (FKFOGGUID = ?))
	bind => [859269b6-5200-49ab-b47f-785c4c305d4d]
[EL Finer]: UnitOfWork(26193147)--release unit of work
[EL Finer]: ClientSession(32579087)--Connection(27595538)--rollback transaction
[EL Finer]: ClientSession(32579087)--client released
[EL Finer]: ServerSession(22238933)--client acquired
[EL Finer]: ClientSession(5174832)--Connection(322649)--begin transaction

java.lang.AssertionError: expected:<1> but was:<0>
	at org.junit.Assert.fail(Assert.java:74)
	at org.junit.Assert.failNotEquals(Assert.java:448)
	...

  @Test
  public void findAreaByPointInAreaSurface() {
    Point point = new GeometryFactory(new PrecisionModel(),3006).createPoint(new Coordinate(6598735, 714690));
    List<AreaSurface> surfaces = repository.findSurfacesByGeometry(point, AreaSurface.class);
    assertEquals(1, surfaces.size());
    AreaSurface surface = surfaces.get(0);
    assertNotNull(surface.getAreas());
    assertEquals(1, surface.getAreas().size()); // <-- fails if lazy!
    Area area = surface.getAreas().get(0);
    ...

  public List<AreaSurface> findSurfacesByGeometry(Geometry geometry, Class clazz) {
    ReadAllQuery query = new ReadAllQuery(clazz);
    query.setIsReadOnly(true);
    ExpressionBuilder builder = query.getExpressionBuilder();
    
    SpatialParameters spatialParameters = new SpatialParameters();
    spatialParameters.setQueryType(SpatialParameters.QueryType.WINDOW);
    
    SpatialParameters spatialParameters2 = new SpatialParameters();
    spatialParameters2.setQueryType(SpatialParameters.QueryType.WINDOW);
    
    SpatialParameters.Mask [] mask;
    
    if(geometry instanceof Polygon || geometry instanceof MultiPolygon) {
      mask = new SpatialParameters.Mask [] {
              SpatialParameters.Mask.EQUAL,
              SpatialParameters.Mask.OVERLAPBDYDISJOINT,
              SpatialParameters.Mask.OVERLAPBDYINTERSECT,
              SpatialParameters.Mask.CONTAINS,
              SpatialParameters.Mask.COVERS,
              SpatialParameters.Mask.INSIDE,
              SpatialParameters.Mask.COVEREDBY,
              SpatialParameters.Mask.ON
      };      // Basically ANYINTERACT - TOUCH.
    } else {
      mask = new SpatialParameters.Mask [] {
              SpatialParameters.Mask.ANYINTERACT
      };
    }
    
    spatialParameters2.setMasks(mask);

    JGeometry jgeometry = GeometryConverter.toJGeometry(geometry);
    Expression filter = SpatialExpressionFactory.filter(builder.get("geometry"), jgeometry, spatialParameters);
    Expression relate = SpatialExpressionFactory.relate(builder.get("geometry"), jgeometry, spatialParameters2);
    
    Expression spatialCriteria = filter.and(relate);
    query.setSelectionCriteria(spatialCriteria);
    
    return (List<AreaSurface>) entityManager.getActiveSession().executeQuery(query);
  }

  public List<AreaSurface> findSurfacesByGeometry(JGeometry geometry, Class clazz) {
    ReadAllQuery query = new ReadAllQuery(clazz);
    query.setIsReadOnly(true);
    ExpressionBuilder builder = query.getExpressionBuilder();
    
    SpatialParameters spatialParameters = new SpatialParameters();

    // Spatial stuff...
    
    List<AreaSurface> surfaces = (List<AreaSurface>) entityManager.getActiveSession().executeQuery(query);
    
    // Make id query in order to get lazy loading to work.
    if(surfaces.size() > 0) {
      String[] uuids = new String[surfaces.size()];
      for(int i = 0; i<uuids.length; i++) {
        uuids[i] = surfaces.get(i).getUuid();
      }
    
      query = new ReadAllQuery(clazz);
      builder = query.getExpressionBuilder();
      Expression expression = builder.get("uuid").in(uuids);
      query.setSelectionCriteria(expression);
      return (List<AreaSurface>) entityManager.getActiveSession().executeQuery(query);
    } else {
      return surfaces;
    }
  }