llevague
commented
11 years ago L'édition de validation des avis fonctionne en 2.0.0-beta4-pre23. Je clos.
Closed yoannlecuyer closed 11 years ago
llevague
commented
11 years ago L'édition de validation des avis fonctionne en 2.0.0-beta4-pre23. Je clos.
Dans Gestion des commissions / Edition des avis
Lorsque je lance l'édition de validation des avis, j'ai l'erreur
javax.el.ELException: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select distinct individu0_.id_usr as id11, individu01.lang as lang1_, individu01.lib_nom_pat_usr as lib31, individu01.lib_nom_usu_usr as lib41, individu01.lib_pr1_usr as lib51, individu01.lib_pr2_usr as lib61, individu01.lib_mail_usr as lib71, individu01.date_crea_enr_usr as date81, individu01.date_modif_enr_usr as date91, individu01.cod_user_to_create_usr as cod101, individu01.cod_user_to_update_usr as cod111, individu01.tem_en_sve_usr as tem121, individu0_.cod_etu as cod22, individu0_.cod_ind as cod32, individu0_.num_dos_opi as num42, individu0_.cod_pay_nat as cod52, individu0_.cod_dep_nai as cod62, individu0_.cod_pay_nai as cod72, individu0_.dat_nai_ind as dat82, individu0_.ville_nai_ind as ville92, individu0_.cod_nne_ind as cod102, individu0_.cle_nne_ind as cle112, individu0_.num_por_ind as num122, individu0_.cod_sex as cod132, individu0_.mail_annuaire as mail142, individu0_.state_ind as state152 from individu individu0_ inner join opi_user individu01 on individu0_.id_usr=individu01.id_usr left outer join indvoeu voeux1 on individu0_.idusr=voeux1.idusr and ( voeux1.tem_en_sve_voeu='Y'), link_trt_cmicamp linktrtcmi2, nomenclature campagne6 where voeux1.idlink=linktrtcmi2.idlink and linktrtcmi2.idnom=campagne6.id_nom and individu01.tem_en_sveusr='Y' and (linktrtcmi2.id_trtcmi in (select traitement4.id_trtcmi from commission commission3 inner join trt_cmivet traitement4 on commission3_.idcmi=traitement4.idcmi where commission3.idcmi=?)) and (campagne6.cod_rinom in (0)) and (voeux1.id_indvoeu in (select avis7.id_indvoeu from avis avis7, indvoeu indvoeu8 where avis7_.id_indvoeu=indvoeu8.id_indvoeu and avis7.validation='N' and avis7_.tem_en_sve_avis='Y'))]; nested exception is java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
viewId=/stylesheets/gestionnaire/opinion/printOpinions.xhtml location=/data/webapps/candidatures-recette.univ-rennes1.fr-2.0.0-alpha2/application/stylesheets/gestionnaire/opinion/printOpinions.xhtml phaseId=INVOKE_APPLICATION(5)
Caused by: java.sql.SQLException - ORA-00932: inconsistent datatypes: expected NUMBER got BINARY at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
/stylesheets/gestionnaire/opinion/printOpinions.xhtml at line 28 and column 122 action="#{printOpinionController.seeCandidats}"