Hello
j'ai tenté d'utiliser le script de Anh "TraiterZonePopShapefile" (en
piece jointe) pour importer des zones pop depuis un dossier contenant
des shape files pour la base en pj (isis 4.4.7.5). J'ai modifié le
script PTAtoolbox (en pj) au préalable. Cependant j'obtiens les erreurs
suivantes a l'evaluation de PTAtoolbox et de traiterzone... J'ai
l'impression que c'est un bete nom de zone ? mais il est bon pourtant...
D'autre part isis est assez lent...
Merci !!
=====================================================================
PTA :
java.lang.NoSuchMethodException:
scripts.PTAtoolbox.main([Ljava.lang.String;)
at java.base/java.lang.Class.getMethod(Class.java:2227)
at
fr.ifremer.isisfish.ui.script.ScriptHandler.evaluateScript(ScriptHandler.java:832)
at
fr.ifremer.isisfish.ui.script.ScriptUI.doActionPerformed__on__buttonScriptEval(ScriptUI.java:375)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at jaxx.runtime.JAXXUtil$1.invoke(JAXXUtil.java:253)
at jdk.proxy1/jdk.proxy1.$Proxy20.actionPerformed(Unknown Source)
at
java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
at
java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
at
java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at
java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at
java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
at
java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297)
at
java.desktop/java.awt.Component.processMouseEvent(Component.java:6626)
at
java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389)
at java.desktop/java.awt.Component.processEvent(Component.java:6391)
at java.desktop/java.awt.Container.processEvent(Container.java:2266)
at
java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001)
at
java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at
java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
at
java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
at
java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
at
java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at
java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743)
at
java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at
java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at
java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at
java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
=====================================================================
traiterzone
java.lang.reflect.InvocationTargetException
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at
fr.ifremer.isisfish.ui.script.ScriptHandler.evaluateScript(ScriptHandler.java:834)
at
fr.ifremer.isisfish.ui.script.ScriptUI.doActionPerformed__on__buttonScriptEval(ScriptUI.java:375)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at jaxx.runtime.JAXXUtil$1.invoke(JAXXUtil.java:253)
at jdk.proxy1/jdk.proxy1.$Proxy20.actionPerformed(Unknown Source)
at
java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
at
java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
at
java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at
java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at
java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
at
java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297)
at
java.desktop/java.awt.Component.processMouseEvent(Component.java:6626)
at
java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389)
at java.desktop/java.awt.Component.processEvent(Component.java:6391)
at java.desktop/java.awt.Container.processEvent(Container.java:2266)
at
java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001)
at
java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at
java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
at
java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
at
java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
at
java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at
java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743)
at
java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at
java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at
java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at
java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not prepare statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
at
org.nuiton.topia.framework.TopiaContextImpl.find(TopiaContextImpl.java:988)
at org.nuiton.topia.framework.TopiaQuery.execute(TopiaQuery.java:1385)
at
org.nuiton.topia.framework.TopiaQuery.executeToEntityList(TopiaQuery.java:1408)
at
org.nuiton.topia.framework.TopiaQuery.executeToEntity(TopiaQuery.java:1510)
at
org.nuiton.topia.persistence.TopiaDAOImpl.findByQuery(TopiaDAOImpl.java:435)
at
org.nuiton.topia.persistence.TopiaDAOImpl.findByProperties(TopiaDAOImpl.java:429)
at
org.nuiton.topia.persistence.TopiaDAOImpl.findByProperty(TopiaDAOImpl.java:412)
at
fr.ifremer.isisfish.entities.FisheryRegionDAOAbstract.findByName(FisheryRegionDAOAbstract.java:25)
at
scripts.TraiterZonePopShapefile.<init>(TraiterZonePopShapefile.java:30)
at
scripts.TraiterZonePopShapefile.main(TraiterZonePopShapefile.java:39)
... 48 more
Caused by: org.hibernate.exception.SQLGrammarException: could not
prepare statement
at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2122)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2059)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037)
at org.hibernate.loader.Loader.doQuery(Loader.java:956)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
at org.hibernate.loader.Loader.doList(Loader.java:2868)
at org.hibernate.loader.Loader.doList(Loader.java:2850)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
at org.hibernate.loader.Loader.list(Loader.java:2677)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
at
org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
at
org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1454)
at
org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
... 58 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table
"FISHERYREGION" non trouvée
Table "FISHERYREGION" not found; SQL statement:
select fisheryreg0_.topiaId as topiaid1_5_, fisheryreg0_.topiaVersion as
topiaver2_5_, fisheryreg0_.topiaCreateDate as topiacre3_5_,
fisheryreg0_.name as name4_5_, fisheryreg0_.minLongitude as
minlongi5_5_, fisheryreg0_.maxLongitude as maxlongi6_5_,
fisheryreg0_.minLatitude as minlatit7_5_, fisheryreg0_.maxLatitude as
maxlatit8_5_, fisheryreg0_.cellLengthLongitude as cellleng9_5_,
fisheryreg0_.cellLengthLatitude as celllen10_5_, fisheryreg0_.mapFiles
as mapfile11_5_, fisheryreg0_.comment as comment12_5_ from fisheryRegion
fisheryreg0_ where fisheryreg0_.name=? limit ? [42102-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:451)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7146)
at org.h2.command.Parser.readTableFilter(Parser.java:1895)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641)
at org.h2.command.Parser.parseSelectSimple(Parser.java:2788)
at org.h2.command.Parser.parseSelectSub(Parser.java:2636)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2469)
at org.h2.command.Parser.parseSelect(Parser.java:2440)
at org.h2.command.Parser.parsePrepared(Parser.java:814)
at org.h2.command.Parser.parse(Parser.java:788)
at org.h2.command.Parser.parse(Parser.java:760)
at org.h2.command.Parser.prepareCommand(Parser.java:683)
at org.h2.engine.Session.prepareLocal(Session.java:627)
at org.h2.engine.Session.prepareCommand(Session.java:565)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349)
at
com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:311)
at
com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
... 74 more
--
Sigrid LEHUTA
~ ><> ~
Fisheries modeller
IFREMER unit HALGO, Ecology and modeling for fisheries science lab (EMH)
Member of the Mixed Research Unit DECOD: Dynamics and sustainability of ecosystems: from source to sea
Member of l'Association Française d'Halieutique
IFREMER, Centre Atlantique
Rue de l'Ile d'Yeu - BP 21105
44311 Nantes Cedex 03, France
Tél : 02 40 37 42 38 (N° interne : 8238)
https://halgo.ifremer.fr/en
https://www.umr-decod.fr/en
https://www.association-francaise-halieutique.fr/
_______________________________________________
Isis-fish-users mailing list
Isis-fish-users@list.isis-fish.org
https://list.isis-fish.org/cgi-bin/mailman/listinfo/isis-fish-users
Archives et moteur de recherche: http://list.isis-fish.org/pipermail/isis-fish-users/