[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] criteriaquery : fetch not working
|
Hi Yannick,
When you run a query, EclipseLink will get not only the object you are
looking for and the items that are fetch joined, but also any EAGERly fetched
relationships from any of the entities that are retrieved. That is likely the
reason you are seeing additional queries.
You should take a look at our attribute group feature. It may help:
http://wiki.eclipse.org/EclipseLink/Examples/JPA/AttributeGroup
-Tom
Yannick Majoros wrote:
Hi,
We have a big object model, which triggers lots of queries on some
occasions. I tried to rewrite some queries to use fetch joins. One of
them still gives me headaches:
CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<EtdOffEtd> query =
builder.createQuery(EtdOffEtd.class);
Root<EtdOffEtd> root = query.from(EtdOffEtd.class);
Path<Long> numOffrePath =
root.get(EtdOffEtd_.epcOffre).get(EpcOffre_.numOffre);
Path<Integer> anacPath = root.get(EtdOffEtd_.anac);
Path<String> nomaPath = root.get(EtdOffEtd_.noma);
Predicate exprNumOffre = builder.equal(numOffrePath, numOffre);
Predicate exprAnac = builder.equal(anacPath, anac);
Predicate exprNoma = builder.equal(nomaPath, noma);
query.where(exprNumOffre, exprAnac, exprNoma).distinct(true);
root.fetch(EtdOffEtd_.etdInscCoursCollection, JoinType.LEFT);
root.fetch(EtdOffEtd_.etdOffEtdSesCollection, JoinType.LEFT);
root.join(EtdOffEtd_.etdInscCoursCollection,
JoinType.LEFT).fetch(EtdInscCours_.epcEle, JoinType.LEFT);
root.fetch(EtdOffEtd_.epcOffre);
root.join(EtdOffEtd_.epcOffre).fetch(EpcOffre_.epcOffreEleCollection,
JoinType.LEFT);
TypedQuery<EtdOffEtd> typedQuery =
entityManager.createQuery(query);
EtdOffEtd etdOffEtd = typedQuery.getSingleResult();
Should just run 1 sql query, from my understanding.
In fact, I'm seeing lots of them (see below, just by running last line).
Relevant summary of object model:
- EtdOffEtd has 1 EpcOffre
- EpcOffre has a list of EpcOffreEle
- EpcOffreEle has 1 EpcOffre and 1 EpcOffreEle
We are trying to get all EpcOffreEle in above query.
It seems it succeeded on something similar but I don't see any difference.
Regards,
Yannick Majoros
Précis: SELECT DISTINCT t1.NOMA, t1.ANAC, t1.ANAC_COND_ACCES,
t1.ANAC_ETAL, t1.ANAC_REF_PRG, t1.CODE_TARIF_FORCE, t1.CODE_TIER_PAYANT,
t1.COND_ACCES, t1.CONVENTION, t1.COURS, t1.DATE_ETAT, t1.DATE_FINAN,
t1.DATE_GRD_FINAL, t1.DATE_MODIF_INSCR_COURS, t1.DEBUT,
t1.DEBUT_ECHANGE, t1.DEMANDE_INSCR_COURS, t1.DIPL_ACC_PART,
t1.DIX_POURC, t1.DPT_ECHANGE, t1.ECHANGE, t1.ECOLE_DOCT, t1.ETAT_INSCR,
t1.FAC_ECHANGE, t1.FIN_ECHANGE, t1.FINANCABLE, t1.GRADE_FINAL,
t1.INSCR_COURS, t1.LEGALISATION, t1.NBR_COURS, t1.NBR_ILV_PAYANT,
t1.NBR_MODULES, t1.NOM_CONVENT, t1.NUM_FACULTAIRE, t1.NUM_OFFRE,
t1.ORDRE_POURC, t1.PAIE_DROIT, t1.PCT_FINAL, t1.PRG_NORMAL,
t1.PRINC_SEC, t1.PRINC_SEC_FORCE, t1.SECTION, t1.SIGLE_SECU, t1.STATUT,
t1.SW_COMPTA, t1.SW_FINAN, t1.SW_MAJ_ANC, t1.TOT_MODULES, t1.TYPE_DUREE,
t1.TYPE_ECHANGE, t1.UNIV_ECHANGE, t1.VISA, t0.NUM_OFFRE, t0.VALIDITE,
t0.ACADEMIQUE, t0.ACTIF, t0.ADULTE, t0.ANACCRE, t0.ANCIEN_CODE,
t0.AUTRES_FAC, t0.CATEG, t0.CATEG_UCL, t0.CERTIFICAT_UNIV, t0.CODACCES,
t0.CODETARIF, t0.COMMENTAIRE, t0.CYCLE, t0.DATE_CONSEIL,
t0.DATE_DER_EVALUATION, t0.DATE_DIFF_COURS, t0.DATE_DIFF_NOTE1,
t0.DATE_DIFF_NOTE2, t0.DATE_DIFF_NOTE3, t0.DATE_EVALUATION,
t0.DATE_MODIF, t0.DATE_NOTE1, t0.DATE_NOTE2, t0.DATE_NOTE3,
t0.DEBUT_INSCR_COURS, t0.DEBUT_INSCR_EXAM1, t0.DEBUT_INSCR_EXAM2,
t0.DEBUT_INSCR_EXAM3, t0.DEBUT_ORG, t0.DELIBE1, t0.DELIBE2, t0.DELIBE3,
t0.DEPARTDPL, t0.DEPOT_MEM1, t0.DEPOT_MEM2, t0.DEPOT_MEM3, t0.DIPLOME,
t0.DOMDECR, t0.DOMETUCH, t0.DOMETULT, t0.DPL_CONJOINT, t0.DPLCOURS,
t0.DURCAPITAL, t0.DUREE, t0.ETAT_PROPOSITION, t0.FIN_INSCR_COURS,
t0.FIN_INSCR_EXAM1, t0.FIN_INSCR_EXAM2, t0.FIN_INSCR_EXAM3, t0.FIN_ORG,
t0.FINAN_CUD, t0.FINANCEMENT, t0.FONDUNIF, t0.FORMULE_CALC_CYCLE,
t0.GESTDEC, t0.GRADE, t0.GRADE_FINAL, t0.HEURE_DIFF_NOTE1,
t0.HEURE_DIFF_NOTE2, t0.HEURE_DIFF_NOTE3, t0.HEURE_NOTE1,
t0.HEURE_NOTE2, t0.HEURE_NOTE3, t0.HPARTICULIER, t0.INAMI,
t0.INSTITUTION, t0.INTER_UNIF_BLG, t0.INTER_UNIF_CF,
t0.INTER_UNIF_ETRANGER, t0.INTER_X, t0.INTIT_ABREGE, t0.INTIT_COMP_ANGL,
t0.INTIT_COMPLET, t0.INTIT_DIPLOME, t0.INTIT_ORIENT_ANGL,
t0.INTIT_ORIENTATION, t0.INTRA_ACAD, t0.LEGALSC, t0.LEP_LHP,
t0.LETTRES_FINALES, t0.LHPIDENT, t0.LOCALISATION, t0.MEMOIRE,
t0.MOINS300, t0.NBR_EPREUVE, t0.NBRMAX, t0.NIVEAU, t0.NOMPRES,
t0.NOMSECR, t0.NOMSIGN, t0.NOUVEAU, t0.NOUVEAU_CODE, t0.NUM_CONSEIL,
t0.NUM_DOS, t0.OFFRE_ID, t0.ORIENT, t0.ORIENT_FINAN_CUD, t0.ORIENTATION,
t0.ORIENTDPL, t0.PERSTAGE, t0.PONDERATION, t0.PREREQUIS, t0.PRESENT,
t0.QUALIFICATION, t0.QUALSIGN, t0.SECSIGLE, t0.SECURITE, t0.SEQCOURS,
t0.SIGLE_ADMIN, t0.SIGLE_DOS, t0.SIGLE_GESTION, t0.SIGLE_OFFRE, t0.SNU,
t0.STAGES, t0.SW_NIVEAU, t0.SW_QUALIFICATION, t0.TOT_OBLIG,
t0.TOT_RECOM, t0.TYPDUREE, t0.TYPE_DIPLOME, t0.TYPE_OFFRE,
t0.TYPE_PROPOSITION, t0.UTIL_MODIF, t0.VOL_OBLIG, t0.VOL_OPTION,
t0.VOL_RECOM, t0.LOCALISATION_ID, t0.OFFRE_UCLOUVAIN_ID, t0.SITE_ID,
t2.NUM_SESS, t2.ANAC, t2.AUTOR_POURSUITE, t2.CLASSEMENT, t2.COMMENTAIRE,
t2.CREDITS_ACQUIS, t2.DATE_DELIBE, t2.DATE_DIFF_NOTE, t2.DATE_INSCR,
t2.EPM, t2.EXAEQUO, t2.HEURE_DIFF_NOTE, t2.INSCR_EXAM, t2.NOMA,
t2.NUM_OFFRE, t2.PERIODE, t2.POURC_INITIAL, t2.POURCENTAGE, t2.RESULTAT,
t2.SUIVI, t2.TOT_POND, t2.U_VERSION, t3.ANAC, t3.ANAC_REF_ELE,
t3.APPREC_1, t3.APPREC_2, t3.APPREC_3, t3.APPREC_4, t3.APPREC_5,
t3.CREDIT_1, t3.CREDIT_2, t3.CREDIT_3, t3.CREDIT_4, t3.CREDIT_5,
t3.ETAT_COURS, t3.ETAT_EVALUATION, t3.ETAT_EXAM_1, t3.ETAT_EXAM_2,
t3.ETAT_EXAM_3, t3.ETAT_EXAM_4, t3.ETAT_EXAM_5, t3.MENTION_1,
t3.MENTION_2, t3.MENTION_3, t3.MENTION_4, t3.MENTION_5, t3.NOMA,
t3.NOTE_1, t3.NOTE_2, t3.NOTE_3, t3.NOTE_4, t3.NOTE_5, t3.NUM_ELE,
t3.NUM_ELE_RGR, t3.NUM_ENR_NOTE_1, t3.NUM_ENR_NOTE_2, t3.NUM_ENR_NOTE_3,
t3.NUM_ENR_NOTE_4, t3.NUM_ENR_NOTE_5, t3.NUM_OFFRE, t3.NUM_ORDRE,
t3.NUM_SERIE, t3.SECTION, t3.SIGLE_SECU, t3.U_VERSION,
t3.VALIDITE_SERIE_TH, t3.REF_SERIE_TH FROM ETD_OFF_ETD t1 LEFT OUTER
JOIN ETD_OFF_ETD_SES t2 ON ((t2.ANAC = t1.ANAC) AND ((t2.NOMA = t1.NOMA)
AND (t2.NUM_OFFRE = t1.NUM_OFFRE))) LEFT OUTER JOIN ETD_INSC_COURS t3 ON
((t3.ANAC = t1.ANAC) AND ((t3.NOMA = t1.NOMA) AND (t3.NUM_OFFRE =
t1.NUM_OFFRE))), EPC_OFFRE t0 WHERE ((((t1.NUM_OFFRE = ?) AND (t1.ANAC =
?)) AND (t1.NOMA = ?)) AND ((t0.VALIDITE = t1.ANAC_REF_PRG) AND
(t0.NUM_OFFRE = t1.NUM_OFFRE)))
bind => [12646, 2010, 40140600]
Précis: SELECT LOCALISATION_ID, LOCALISATION, SERVICE_INSCRIPTION,
SIGLE_LOCALISATION FROM EPC_LOCALISATION WHERE (LOCALISATION_ID = ?)
bind => [3]
Précis: SELECT OFFRE_UCLOUVAIN_ID, ACADEMIQUE, ADULTE, ANACCRE,
ANNEE_DER_EVAL_AEQES, ANNEE_PRC_EVAL_AEQES, AUTRES_FAC, CATEG,
CATEG_UCL, CERTIFICAT_UNIV, CODACCES, CODETARIF, DATE_CONSEIL,
DATE_MODIF, DEPARTDPL, DIPLOME, DOMDECR, DOMETUCH, DOMETULT,
DPL_CONJOINT, DPLCOURS, DURCAPITAL, DUREE, ETAT_PROPOSITION, FINAN_CUD,
FINANCEMENT, FONDUNIF, GESTDEC, GRADE, GRADE_FINAL, HPARTICULIER, INAMI,
INSCRIPTIBLE, INTER_X, INTIT_ABREGE, INTIT_COMP_ANGL, INTIT_COMPLET,
INTIT_DIPLOME, INTIT_ORIENT_ANGL, INTIT_ORIENTATION, INTRA_ACAD,
LEGALSC, LEP_LHP, LHPIDENT, MOINS300, NBR_EPREUVE, NBRMAX, NOUVEAU,
NUM_CONSEIL, NUM_DOS, ORIENT, ORIENT_FINAN_CUD, ORIENTDPL, PERSTAGE,
PREREQUIS, PRESENT, QUALIFICATION, SECURITE, SEQCOURS, SIGLE_DOS, SNU,
SW_NIVEAU, SW_QUALIFICATION, TOT_OBLIG, TOT_RECOM, TYPDUREE,
TYPE_DIPLOME, TYPE_OFFRE, TYPE_PROPOSITION, UTIL_MODIF, VALIDITE,
VOL_OBLIG, VOL_OPTION, VOL_RECOM, OFFRE_SIGLE_ID FROM
EPC_OFFRE_UCLOUVAIN WHERE (OFFRE_UCLOUVAIN_ID = ?)
bind => [2528251]
Précis: SELECT OFFRE_SIGLE_ID, LETTRES_FINALES, NIVEAU, OCYCLE,
ORIENTATION, SIGLE, OFFRE_SIGLE_SUIVI_ID FROM EPC_OFFRE_SIGLE WHERE
(OFFRE_SIGLE_ID = ?)
bind => [201601]
Précis: SELECT OFFRE_SIGLE_SUIVI_ID, DESCRIPTION FROM
EPC_OFFRE_SIGLE_SUIVI WHERE (OFFRE_SIGLE_SUIVI_ID = ?)
bind => [193401]
Précis: SELECT OFFRE_SUPPL_ID, AUTRE_ETAB, COND_ACCES, INFO_DPL,
LANGUES, NOTATION, TITRE_PROF, OFFRE_UCLOUVAIN_ID FROM EPC_OFFRE_SUPPL
WHERE (OFFRE_UCLOUVAIN_ID = ?)
bind => [2528251]
Précis: SELECT SITE_ID, CODE_SITE, COORGANISATEUR, LETTRE_SITE,
NOM_SITE, ORGANISATEUR, SIGLE_SITE FROM EPC_SITE WHERE (SITE_ID = ?)
bind => [1]
Précis: SELECT ANAC, ANAC_ACCESS, CODE_ACCESS, LIB_ACCESS, MODIF_LIB,
NOMA, NUM_OFFRE, ORIGINE, PRG_ACCESS, U_VERSION FROM ETD_DPL_ACC WHERE
(((NOMA = ?) AND (ANAC = ?)) AND (NUM_OFFRE = ?))
bind => [40140600, 2010, 12646]
Précis: SELECT ANAC, B1, B2, B3, CLAFA, CODE_ACCES, COND_INSCR,
DATE_ENTERIN, FAC, LEGAL, LHP_IDENT, LOB1, LOB2, LOB3, LOCAL, MAN1,
MAN2, MAN3, MODETAL, NOMA, NUM_OFFRE, PRESENT, SANS_SUIVRE, TYPE_ENREG,
U_VERSION FROM ETD_OFF_ETD_ANC WHERE (((NUM_OFFRE = ?) AND (ANAC = ?))
AND (NOMA = ?))
bind => [12646, 2010, 40140600]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [37966, 2010]
Précis: SELECT CAMPUS_ID, LETTRE, NOM, SITE_ID FROM EPC_CAMPUS WHERE
(CAMPUS_ID = ?)
bind => [1]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38565, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38569, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38571, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38572, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [43471, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [54730, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [54732, 2010]
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users