...
    	String hql = "DELETE FROM com.intellex.marksist.hbn.model.GbCapacityEntity "  + 
	     			 "WHERE orgId = :some_id";
    	dao.delete(hql, id);
    	
    	hql = "DELETE FROM com.intellex.marksist.hbn.model.GbLoadForecast "  + 
		 	  "WHERE orgId = :some_id";    	
    	dao.delete(hql, id);

...

...

@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_LOAD_FORECAST")
public class GbLoadForecast {
	@Id	
	@Column(name = "ORG_ID")
	private Integer orgId;
	...	
	@ManyToOne(cascade={CascadeType.ALL},fetch = FetchType.LAZY)
	private List<GbCapacityEntity> gbCapacityEntity;	
    public List<GbCapacityEntity> getGbLoadForecast() {
        return gbCapacityEntity;
    }
    /**
     * @param gbLoadForecast
     */
    public void setGbLoadForecast(List<GbCapacityEntity> gbCapacityEntity) {
        this.gbCapacityEntity = gbCapacityEntity;
    }


...

@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_CAPACITY")
public class GbCapacityEntity {
	@Id
	@Column(name = "ORG_ID")
	private Integer orgId;
	
...	
	@OneToMany(targetEntity=com.intellex.marksist.hbn.model.GbLoadForecast.class, cascade={CascadeType.ALL}, fetch=FetchType.LAZY)
	@JoinTable(name="MARKSIST.GB_LOAD_FORECAST",joinColumns={@JoinColumn(name="ORG_ID")},inverseJoinColumns={@JoinColumn(name="ORG_ID")})
	@OnDelete(action=OnDeleteAction.CASCADE)
	private List<GbLoadForecast> gbLoadForecast;
	
    @JoinColumn(name="ORG_ID", nullable = false)
    @OnDelete(action=OnDeleteAction.CASCADE)
    public List<GbLoadForecast> getGbLoadForecast() {
        return gbLoadForecast;
    }
    /**
     * 
     * @param gbLoadForecast
     */
    public void setGbLoadForecast(List<GbLoadForecast> gbLoadForecast) {
        this.gbLoadForecast = gbLoadForecast;
    }

...

...
@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_LOAD_FORECAST")
public class GbLoadForecast {
	@Id	
	@Column(name = "ORG_ID")
	private Integer orgId;
...
	@ManyToOne
    private GbCapacityEntity gbCapacityEntity;
	/**
	 * 
	 * @return
	 */
    public GbCapacityEntity getGbLoadForecast() {
        return gbCapacityEntity;
    }
    /**
     * @param gbLoadForecast
     */
    public void setGbLoadForecast(GbCapacityEntity gbCapacityEntity) {
        this.gbCapacityEntity = gbCapacityEntity;
    }
...

@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_CAPACITY")
public class GbCapacityEntity {
	@Id
	@Column(name = "ORG_ID")
	private Integer orgId;
	
...	
	@OneToMany(targetEntity=com.intellex.marksist.hbn.model.GbLoadForecast.class, cascade={CascadeType.ALL}, fetch=FetchType.LAZY)
	@JoinTable(name="MARKSIST.GB_LOAD_FORECAST",joinColumns={@JoinColumn(name="ORG_ID")},inverseJoinColumns={@JoinColumn(name="ORG_ID")})
	@OnDelete(action=OnDeleteAction.CASCADE)
	private List<GbLoadForecast> gbLoadForecast;
	/**
	 * 
	 * @return
	 */
    public List<GbLoadForecast> getGbLoadForecast() {
        return gbLoadForecast;
    }
    /**
     * 
     * @param gbLoadForecast
     */
    public void setGbLoadForecast(List<GbLoadForecast> gbLoadForecast) {
        this.gbLoadForecast = gbLoadForecast;
    }
...

@ManyToOne

...
	    String hql = "FROM com.intellex.marksist.hbn.model.GbLoadForecast E " +
		 			 "WHERE E.orgId = :id1 AND E.cargoGroup = :id2";

...
		query.setParameter("id1", orgId);
		query.setParameter("id2", gcId);
                List results = query.list();
...

// GbCapacityEntity class
...
	@OneToMany(targetEntity=com.intellex.marksist.hbn.model.GbLoadForecast.class, cascade={CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="gbCapacityEntity")
	@JoinTable(name="MARKSIST.GB_LOAD_FORECAST",joinColumns={@JoinColumn(name="ORG_ID")})
	private List<GbLoadForecast> gbLoadForecast;

// GbLoadForecast class
...
	@ManyToOne
	private GbCapacityEntity gbCapacityEntity;

...

...

// GbCapacityEntity class
...
	@OneToMany(targetEntity=com.intellex.marksist.hbn.model.GbLoadForecast.class, cascade={CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="gbCapacityEntity")
	@JoinTable(name="MARKSIST.GB_LOAD_FORECAST",joinColumns={@JoinColumn(name="ORG_ID")})
	private List<GbLoadForecast> gbLoadForecast;

// GbLoadForecast class
...
	@ManyToOne
	private GbCapacityEntity gbCapacityEntity;
        @JoinColumn(name = "ORG_ID")
...

...
// GbCapacityEntity class

	@OneToMany(cascade = CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="gbCapacityEntity")
	private List<GbLoadForecast> gbLoadForecast;
	/**
	 * 
	 * @return
	 */
    public List<GbLoadForecast> getGbLoadForecast() {
        return gbLoadForecast;
    }
    /**
     * 
     * @param gbLoadForecast
     */
    public void setGbLoadForecast(List<GbLoadForecast> gbLoadForecast) {
        this.gbLoadForecast = gbLoadForecast;
    }

...

// GbLoadForecast class

	@ManyToOne(cascade = {CascadeType.REFRESH}, fetch = FetchType.LAZY)
	private GbCapacityEntity gbCapacityEntity;
	/**
	 * @return
	 */
    public GbCapacityEntity getGbCapacityEntity() {
        return gbCapacityEntity;
    }
    /**
     * @param gbLoadForecast
     */
    public void setGbCapacityEntity(GbCapacityEntity gbCapacityEntity) {
        this.gbCapacityEntity = gbCapacityEntity;
    }
...

// Запрос

	    String hql = "FROM com.intellex.marksist.hbn.model.GbLoadForecast E " +
		 			 "WHERE E.orgId = :id1 AND E.cargoGroup = :id2";
	    
		Session session = HibernateUtil.getMarksistSessionFactory().openSession();
		session.beginTransaction();
		
		Query query = session.createQuery(hql);
		query.setParameter("id1", orgId);
		query.setParameter("id2", gcId);
		List results = query.list();
		session.close();
...

...
	@ManyToOne(cascade = {CascadeType.REFRESH}, fetch = FetchType.LAZY)
	@JoinTable(name="MARKSIST.GB_CAPACITY",joinColumns={@JoinColumn(name="ORG_ID")})
	private GbCapacityEntity gbCapacityEntity;

...

...
	    String hql = "FROM com.intellex.marksist.hbn.model.GbLoadForecast G " +
		 			 "WHERE G.orgId = :id1 AND G.cargoGroup = :id2";

...

...
     [java] Hibernate: 
     [java]     select
     [java]         gbloadfore0_.ORG_ID as ORG1_4_,
     [java]         gbloadfore0_.GRUP_GRUZ as GRUP2_4_,
     [java]         gbloadfore0_.CHANGER_ID as CHANGER3_4_,
     [java]         gbloadfore0_.FST_2012 as FST4_4_,
     [java]         gbloadfore0_.FST_2013 as FST5_4_,
     [java]         gbloadfore0_.FST_2014 as FST6_4_,
     [java]         gbloadfore0_.FST_2015 as FST7_4_,
     [java]         gbloadfore0_.RW_ID as RW8_4_,
     [java]         gbloadfore0_.SENDER_ID as SENDER9_4_,
     [java]         gbloadfore0_.ST_ID as ST10_4_,
     [java]         gbloadfore0_1_.gbCapacityEntity_ORG_ID as gbCapac10_3_ 
     [java]     from
     [java]         MARKSIST.GB_LOAD_FORECAST gbloadfore0_,
     [java]         MARKSIST.GB_CAPACITY gbloadfore0_1_ 
     [java]     where
     [java]         gbloadfore0_.ORG_ID=gbloadfore0_1_.ORG_ID(+) 
     [java]         and gbloadfore0_.ORG_ID=? 
     [java]         and gbloadfore0_.GRUP_GRUZ=?
...

select
  gbloadfore0_.ORG_ID as ORG1_4_,
  gbloadfore0_.GRUP_GRUZ as GRUP2_4_,
  gbloadfore0_.CHANGER_ID as CHANGER3_4_,
  gbloadfore0_.FST_2012 as FST4_4_,
  gbloadfore0_.FST_2013 as FST5_4_,
  gbloadfore0_.FST_2014 as FST6_4_,
  gbloadfore0_.FST_2015 as FST7_4_,
  gbloadfore0_.RW_ID as RW8_4_,
  gbloadfore0_.SENDER_ID as SENDER9_4_,
  gbloadfore0_.ST_ID as ST10_4_,
  gbloadfore0_1_.gbCapacityEntity_ORG_ID as gbCapac10_3_ 

from
  MARKSIST.GB_LOAD_FORECAST gbloadfore0_,
  MARKSIST.GB_CAPACITY gbloadfore0_1_ 

where
  gbloadfore0_.ORG_ID=gbloadfore0_1_.ORG_ID(+) and 
  gbloadfore0_.ORG_ID=310961 and 
  gbloadfore0_.GRUP_GRUZ=13

...
/*,
  gbloadfore0_1_.gbCapacityEntity_ORG_ID as gbCapac10_3_ */
...

select dbms_metadata.get_ddl('TABLE', 'GB_CAPACITY', 'MARKSIST') from dual;

  CREATE TABLE "MARKSIST"."GB_CAPACITY" 
   (	"ORG_ID" NUMBER NOT NULL ENABLE, 
	"GRUPGRUZ" NUMBER, 
	"CAP_2012" NUMBER, 
	"CAP_2013" NUMBER, 
	"CAP_2015" NUMBER, 
	"CAP_2020" NUMBER, 
	"CAP_2030" NUMBER, 
	"CHANGER_ID" NUMBER NOT NULL ENABLE, 
	"RW_ID" NUMBER NOT NULL ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_SDE" 
 
select dbms_metadata.get_ddl('TABLE', 'GB_LOAD_FORECAST', 'MARKSIST') from dual;

  CREATE TABLE "MARKSIST"."GB_LOAD_FORECAST" 
   (	"ORG_ID" NUMBER NOT NULL ENABLE, 
	"SENDER_ID" NUMBER, 
	"ST_ID" NUMBER NOT NULL ENABLE, 
	"GRUP_GRUZ" NUMBER, 
	"FST_2012" NUMBER, 
	"FST_2013" NUMBER, 
	"FST_2014" NUMBER, 
	"FST_2015" NUMBER, 
	"CHANGER_ID" NUMBER NOT NULL ENABLE, 
	"RW_ID" NUMBER NOT NULL ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_SDE" 
 

 @Column(name = "ORG_ID") 

@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_LOAD_FORECAST")
public class GbLoadForecast {
	@Id	
	private Integer orgId;
...

@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_LOAD_FORECAST")
public class GbLoadForecast {
	@Id	
	@Column(name = "FST_ORG_ID")
	private Integer fstOrgId;
...
	@ManyToOne(cascade = {CascadeType.REFRESH}, fetch = FetchType.LAZY)
	@JoinTable(name="MARKSIST.GB_CAPACITY",joinColumns={@JoinColumn(name="CAP_ORG_ID")})
	private GbCapacityEntity gbCapacityEntity;
...


@Entity
@Cache(usage = org.hibernate.annotations.CacheConcurrencyStrategy.NONE)
@Table(name = "MARKSIST.GB_CAPACITY")
public class GbCapacityEntity {
	@Id
	@Column(name = "CAP_ORG_ID")
	private Integer capOrgId;
...
	@OneToMany(cascade = CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="gbCapacityEntity")
	private List<GbLoadForecast> gbLoadForecast;
...