String rejected_offer_query = "SELECT b.job_instance_id, b.start_time, count (*) " +
        "FROM SygaOfferRejected s , BatchJobExecution b, BatchJobInstance bi "+
        "where s.heure_debut = b.start_time " +
        "and s.heure_fin = b.end_time " +
        "and b.job_execution_id = bi.job_instance_id " +
        "and bi.job_name = :batchName "+
        "and b.status = :batchStatus " +
        "group by b.job_instance_id";

SELECT b.job_instance_id, b.start_time, count (*) " +
        "FROM SygaOffer s , BatchJobExecution b, BatchJobInstance bi "+
        "where s.heure_debut = b.start_time " +
        "and s.heure_fin = b.end_time " +
        "and b.job_execution_id = bi.job_instance_id " +
        "and bi.job_name = :batchName "+
        "and b.status = :batchStatus " +
        "group by b.job_instance_id"

@Entity
@Inheritance
@Table(name = "bob_syga_off")
public class SygaOffer {
  @Id
  private long id_offre;
  private String acteur;
  private String heure_debut;
  private String heure_fin;

private String reference_offre;
private int retry;
}

------------------------------------------

@Entity
@Table(name ="bob_syga_offr_rejected")
public class SygaOfferRejected extends SygaOffer{

 }