J'essaye d'ouvrir Tutti sur l'ensemble des données CGFS, mais j'obtiens une erreur.
Je voudrais vérifier sur le jeu de données ce qui coince.
D'après le message je pense que c'est l'un des select dans le select qui ramène plus d'une donnée, mais je ne peux pas vérifier car je ne connais pas la valeur des pmfm_fk utilisées dans ces requêtes.
Il y aurait moyen de savoir ça avec les logs ?
Je peux trouver ça où sinon ?
Merci
Christian
Single value expected in statement [select fishingope0_.ID as col_0_0_, fishingope0_.NAME as col_1_0_, fishingope0_.START_DATE_TIME as col_2_0_, (select vesselusem4_.ALPHANUMERICAL_VALUE from VESSEL_USE_MEASUREMENT vesselusem4_ where vesselusem4_.VESSEL_USE_FEATURES_FK=vesselusef3_.ID and vesselusem4_.PMFM_FK=?) as col_3_0_, (select gearusemea5_.ALPHANUMERICAL_VALUE from GEAR_USE_MEASUREMENT gearusemea5_ where gearusemea5_.GEAR_USE_FEATURES_FK=gearusefea1_.ID and gearusemea5_.PMFM_FK=?) as col_4_0_ from OPERATION fishingope0_ left outer join GEAR_USE_FEATURES gearusefea1_ on fishingope0_.ID=gearusefea1_.OPERATION_FK left outer join GEAR gearimpl2_ on gearusefea1_.GEAR_FK=gearimpl2_.ID left outer join VESSEL_USE_FEATURES vesselusef3_ on fishingope0_.ID=vesselusef3_.OPERATION_FK cross join FISHING_TRIP fishingtri6_ where fishingope0_.IS_FISHING_OPERATION=1 and fishingope0_.FISHING_TRIP_FK=fishingtri6_.ID and fishingtri6_.SCIENTIFIC_CRUISE_FK=? order by fishingope0_.START_DATE_TIME]
Message d'erreur :
Erreur
Message:
org.hibernate.exception.DataException: could not execute query using iterate
Level:
SEVERE
Stack Trace:
could not execute query using iterate
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:507)
org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:407)
org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:248)
org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1339)
org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
fr.ifremer.tutti.persistence.service.AbstractPersistenceService.queryList(AbstractPersistenceService.java:118)
fr.ifremer.tutti.persistence.service.FishingOperationPersistenceServiceImpl.getAllFishingOperation(FishingOperationPersistenceServiceImpl.java:195)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy31.getAllFishingOperation(Unknown Source)
fr.ifremer.tutti.persistence.TuttiPersistenceImpl.getAllFishingOperation(TuttiPersistenceImpl.java:694)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy35.getAllFishingOperation(Unknown Source)
fr.ifremer.tutti.service.PersistenceService.getAllFishingOperation(PersistenceService.java:1047)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUIHandler.beforeInit(FishingOperationsUIHandler.java:104)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUI.$initialize(FishingOperationsUI.java:568)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUI.<init>(FishingOperationsUI.java:131)
fr.ifremer.tutti.ui.swing.content.MainUIHandler.setScreen(MainUIHandler.java:440)
fr.ifremer.tutti.ui.swing.content.MainUIHandler$1.propertyChange(MainUIHandler.java:141)
java.beans.PropertyChangeSupport.fire(Unknown Source)
java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
org.jdesktop.beans.AbstractBean.firePropertyChange(AbstractBean.java:303)
fr.ifremer.tutti.ui.swing.TuttiUIContext.setScreen(TuttiUIContext.java:837)
fr.ifremer.tutti.ui.swing.action.AbstractChangeScreenAction.doAction(AbstractChangeScreenAction.java:107)
fr.ifremer.tutti.ui.swing.action.EditCatchesAction.doAction(EditCatchesAction.java:57)
fr.ifremer.shared.application.swing.action.ApplicationActionSwingWorker.doInBackground(ApplicationActionSwingWorker.java:89)
fr.ifremer.shared.application.swing.action.ApplicationActionSwingWorker.doInBackground(ApplicationActionSwingWorker.java:43)
javax.swing.SwingWorker$1.call(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
javax.swing.SwingWorker.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)
Single value expected in statement [select fishingope0_.ID as col_0_0_, fishingope0_.NAME as col_1_0_, fishingope0_.START_DATE_TIME as col_2_0_, (select vesselusem4_.ALPHANUMERICAL_VALUE from VESSEL_USE_MEASUREMENT vesselusem4_ where vesselusem4_.VESSEL_USE_FEATURES_FK=vesselusef3_.ID and vesselusem4_.PMFM_FK=?) as col_3_0_, (select gearusemea5_.ALPHANUMERICAL_VALUE from GEAR_USE_MEASUREMENT gearusemea5_ where gearusemea5_.GEAR_USE_FEATURES_FK=gearusefea1_.ID and gearusemea5_.PMFM_FK=?) as col_4_0_ from OPERATION fishingope0_ left outer join GEAR_USE_FEATURES gearusefea1_ on fishingope0_.ID=gearusefea1_.OPERATION_FK left outer join GEAR gearimpl2_ on gearusefea1_.GEAR_FK=gearimpl2_.ID left outer join VESSEL_USE_FEATURES vesselusef3_ on fishingope0_.ID=vesselusef3_.OPERATION_FK cross join FISHING_TRIP fishingtri6_ where fishingope0_.IS_FISHING_OPERATION=1 and fishingope0_.FISHING_TRIP_FK=fishingtri6_.ID and fishingtri6_.SCIENTIFIC_CRUISE_FK=? order by fishingope0_.START_DATE_TIME]
org.hsqldb.jdbc.Util.throwError(Unknown Source)
org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:483)
org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:407)
org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:248)
org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1339)
org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
fr.ifremer.tutti.persistence.service.AbstractPersistenceService.queryList(AbstractPersistenceService.java:118)
fr.ifremer.tutti.persistence.service.FishingOperationPersistenceServiceImpl.getAllFishingOperation(FishingOperationPersistenceServiceImpl.java:195)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy31.getAllFishingOperation(Unknown Source)
fr.ifremer.tutti.persistence.TuttiPersistenceImpl.getAllFishingOperation(TuttiPersistenceImpl.java:694)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy35.getAllFishingOperation(Unknown Source)
fr.ifremer.tutti.service.PersistenceService.getAllFishingOperation(PersistenceService.java:1047)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUIHandler.beforeInit(FishingOperationsUIHandler.java:104)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUI.$initialize(FishingOperationsUI.java:568)
fr.ifremer.tutti.ui.swing.content.operation.FishingOperationsUI.<init>(FishingOperationsUI.java:131)
fr.ifremer.tutti.ui.swing.content.MainUIHandler.setScreen(MainUIHandler.java:440)
fr.ifremer.tutti.ui.swing.content.MainUIHandler$1.propertyChange(MainUIHandler.java:141)
java.beans.PropertyChangeSupport.fire(Unknown Source)
java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
org.jdesktop.beans.AbstractBean.firePropertyChange(AbstractBean.java:303)
fr.ifremer.tutti.ui.swing.TuttiUIContext.setScreen(TuttiUIContext.java:837)
fr.ifremer.tutti.ui.swing.action.AbstractChangeScreenAction.doAction(AbstractChangeScreenAction.java:107)
fr.ifremer.tutti.ui.swing.action.EditCatchesAction.doAction(EditCatchesAction.java:57)
fr.ifremer.shared.application.swing.action.ApplicationActionSwingWorker.doInBackground(ApplicationActionSwingWorker.java:89)
fr.ifremer.shared.application.swing.action.ApplicationActionSwingWorker.doInBackground(ApplicationActionSwingWorker.java:43)
javax.swing.SwingWorker$1.call(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
javax.swing.SwingWorker.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)
--
| |
||
| Christian BONNET |
Centre de Brest ZI de la pointe du diable CS 10070 - 29280 Plouzané |
|
| Département Infrastructures Marines
et Numériques (IMN) Unité Informatique et Données Marines (IDM) Service Ingénierie des Systèmes d'Information (ISI) |
||
| christian.bonnet@ifremer.fr www.ifremer.fr |
Tel : +33 (0)2.98.22.46.16 Fax : +33 (0)2.98.22.46.44 |
|