1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
|
19:49:33,860 DEBUG SessionImpl:1828 - Dont need to execute flush
19:49:33,860 DEBUG QueryTranslator:207 - HQL: select from ca.croixbleue.qc.model.base.BaseAvinfoge as base where base.noDossier = ?
19:49:33,860 DEBUG QueryTranslator:208 - SQL: select baseavinfo0_.noGroupe as noGroupe, baseavinfo0_.noCertificat as noCertif2_, baseavinfo0_.dtEvenement as dtEvenem3_, baseavinfo0_.noDossier as noDossier, baseavinfo0_.IG_ID_DOUBLE_ASS as IG_ID_DO5_, baseavinfo0_.IG_DT_EVENEMENT as IG_DT_EV6_, baseavinfo0_.IG_GROUPE_CLIENT as IG_GROUP7_, baseavinfo0_.IG_NO_DOSSIER as IG_NO_DO8_, baseavinfo0_.IG_NO_CERTIFICAT_SAM as IG_NO_CE9_, baseavinfo0_.IG_NO_CERTIFICAT as IG_NO_C10_, baseavinfo0_.IG_NO_GROUPE as IG_NO_G11_, baseavinfo0_.IG_ID_USER as IG_ID_USER, baseavinfo0_.IG_DT_MODIF as IG_DT_M13_, baseavinfo0_.IG_ID_ACCIDENT as IG_ID_A14_ from AVINFOGE baseavinfo0_ where (baseavinfo0_.IG_NO_DOSSIER=? )
19:49:33,875 DEBUG BatcherImpl:204 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:33,875 DEBUG SQL:230 - select baseavinfo0_.noGroupe as noGroupe, baseavinfo0_.noCertificat as noCertif2_, baseavinfo0_.dtEvenement as dtEvenem3_, baseavinfo0_.noDossier as noDossier, baseavinfo0_.IG_ID_DOUBLE_ASS as IG_ID_DO5_, baseavinfo0_.IG_DT_EVENEMENT as IG_DT_EV6_, baseavinfo0_.IG_GROUPE_CLIENT as IG_GROUP7_, baseavinfo0_.IG_NO_DOSSIER as IG_NO_DO8_, baseavinfo0_.IG_NO_CERTIFICAT_SAM as IG_NO_CE9_, baseavinfo0_.IG_NO_CERTIFICAT as IG_NO_C10_, baseavinfo0_.IG_NO_GROUPE as IG_NO_G11_, baseavinfo0_.IG_ID_USER as IG_ID_USER, baseavinfo0_.IG_DT_MODIF as IG_DT_M13_, baseavinfo0_.IG_ID_ACCIDENT as IG_ID_A14_ from AVINFOGE baseavinfo0_ where (baseavinfo0_.IG_NO_DOSSIER=? )
19:49:33,875 DEBUG BatcherImpl:253 - preparing statement
19:49:33,969 DEBUG StringType:46 - binding '420517' to parameter: 1
19:49:34,000 DEBUG JDBCExceptionReporter:49 - SQL Exception
java.sql.SQLException: ORA-00904: "BASEAVINFO0_"."NODOSSIER": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at ca.croixbleue.qc.model.base.BaseAvinfogeDAO.find(BaseAvinfogeDAO.java:169)
at ca.croixbleue.qc.model.base.BaseAvinfoge.estDansLaBase(BaseAvinfoge.java:189)
at ca.croixbleue.qc.service.ServicePersistance.estDansLaBase(ServicePersistance.java:23)
at ca.croixbleue.qc.batch.MettreJourInfogene.creerInfogene(MettreJourInfogene.java:231)
at ca.croixbleue.qc.batch.MettreJourInfogene.iniFichier(MettreJourInfogene.java:216)
at ca.croixbleue.qc.batch.MettreJourInfogene.traiter(MettreJourInfogene.java:170)
at ca.croixbleue.qc.batch.MettreJourInfogene.<init>(MettreJourInfogene.java:130)
at ca.croixbleue.qc.batch.MettreJourInfogene.main(MettreJourInfogene.java:731)
19:49:34,000 WARN JDBCExceptionReporter:57 - SQL Error: 904, SQLState: 42000
19:49:34,000 ERROR JDBCExceptionReporter:58 - ORA-00904: "BASEAVINFO0_"."NODOSSIER": invalid identifier
19:49:34,000 DEBUG BatcherImpl:211 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:34,000 DEBUG BatcherImpl:275 - closing statement
19:49:34,000 DEBUG JDBCExceptionReporter:49 - Could not execute query
java.sql.SQLException: ORA-00904: "BASEAVINFO0_"."NODOSSIER": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at ca.croixbleue.qc.model.base.BaseAvinfogeDAO.find(BaseAvinfogeDAO.java:169)
at ca.croixbleue.qc.model.base.BaseAvinfoge.estDansLaBase(BaseAvinfoge.java:189)
at ca.croixbleue.qc.service.ServicePersistance.estDansLaBase(ServicePersistance.java:23)
at ca.croixbleue.qc.batch.MettreJourInfogene.creerInfogene(MettreJourInfogene.java:231)
at ca.croixbleue.qc.batch.MettreJourInfogene.iniFichier(MettreJourInfogene.java:216)
at ca.croixbleue.qc.batch.MettreJourInfogene.traiter(MettreJourInfogene.java:170)
at ca.croixbleue.qc.batch.MettreJourInfogene.<init>(MettreJourInfogene.java:130)
at ca.croixbleue.qc.batch.MettreJourInfogene.main(MettreJourInfogene.java:731)
19:49:34,000 WARN JDBCExceptionReporter:57 - SQL Error: 904, SQLState: 42000
19:49:34,000 ERROR JDBCExceptionReporter:58 - ORA-00904: "BASEAVINFO0_"."NODOSSIER": invalid identifier
19:49:37,423 DEBUG SessionImpl:578 - closing session
19:49:37,423 DEBUG SessionImpl:3383 - disconnecting session
19:49:37,423 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
net.sf.hibernate.exception.SQLGrammarException: Could not execute query
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at ca.croixbleue.qc.model.base.BaseAvinfogeDAO.find(BaseAvinfogeDAO.java:169)
at ca.croixbleue.qc.model.base.BaseAvinfoge.estDansLaBase(BaseAvinfoge.java:189)
at ca.croixbleue.qc.service.ServicePersistance.estDansLaBase(ServicePersistance.java:23)
at ca.croixbleue.qc.batch.MettreJourInfogene.creerInfogene(MettreJourInfogene.java:231)
at ca.croixbleue.qc.batch.MettreJourInfogene.iniFichier(MettreJourInfogene.java:216)
at ca.croixbleue.qc.batch.MettreJourInfogene.traiter(MettreJourInfogene.java:170)
at ca.croixbleue.qc.batch.MettreJourInfogene.<init>(MettreJourInfogene.java:130)
at ca.croixbleue.qc.batch.MettreJourInfogene.main(MettreJourInfogene.java:731)
Caused by: java.sql.SQLException: ORA-00904: "BASEAVINFO0_"."NODOSSIER": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
... 9 more |
Partager