[geGIS] Fout bij het tonen van Punten
Jan De Moerloose
jan op dfc.be
Do Nov 8 09:01:55 CET 2007
Eric,
we vermoeden dat de feature ids in het commando gegenereerd zijn door
geotools (bvb vesselposition.7a230d95:1161ba1ad51:-7f74) ipv de
databank, klopt dit?
In dat geval is er waarschijnlijk iets mis met de tabel (geen primary
key?). Kan je eventueel het schema eens doorsturen?
Groeten,
Jan
Eric Smets schreef:
> Hallo,
>
> Hierbij de log (ook in copie) naar de mailinglijst. De fout kan ik ook
> in andere omstandigheden
> reproduceren (andere dataset) als het punten zijn.
>
> mvg,
>
> Eric
>
> 2007-11-08 08:41:33,280 INFO [DataStoreProvider] - getFeatures() :
> vesselposition
> 2007-11-08 08:41:33,290 INFO [DefaultLayerModel] - getElements() :
> returning reader
> 2007-11-08 08:41:33,290 INFO [RetrieveVectorDataCommand] - execute() :
> returning 3 features for
> [Lcom.cadrie.majas.command.jsondata.MapExtent;@1ce56f8
> 2007-11-08 08:41:33,290 INFO [GGISJSONServlet] - send:
> {"id":4,"result":{"errorMessages":{"javaClass":"java.util.ArrayList","list":[]},"features":{"javaClass":"java.util.ArrayList","list":[{"labelProperty":{"propertyName":"vesselname","javaClass":"com.cadrie.majas.command.jsondata.Property","oldValue":"","currentValue":"ANNI
> STUHFF"},"focusPoint":{"javaClass":"com.cadrie.majas.command.jsondata.Point","y":215421.9014452584,"x":266392.9025529509},"svg":{"map":{"xlink:href":"#pointAsCircleGreen","y":"215421.9","x":"266392.9"},"javaClass":"java.util.HashMap"},"javaClass":"com.cadrie.majas.command.jsondata.VectorFeature","featureID":"vesselposition.7a230d95:1161ba1ad51:-7f6b","gridCellId":"2110311000","urlProperty":{"propertyName":"url","javaClass":"com.cadrie.majas.command.jsondata.Property","oldValue":"","currentValue":"url"},"oldSVG":{"map":{},"javaClass":"java.util.HashMap"},"layerId":2,"styleDef":1},{"labelProperty":{"propertyName":"vesselname","javaClass":"com.cadrie.majas.command.jsondata.Property","oldValue":"","currentValue":"ANTON"},
>
> 2007-11-08 08:41:33,290 INFO [GGISJSONServlet] - Command execution
> time: 20 ms
> 2007-11-08 08:41:33,290 INFO [GGISJSONServlet] - SESSION:
> FCE47520E9FB321A0B9780167DE17929
> 2007-11-08 08:41:33,350 INFO [GGISJSONServlet] - Incoming JSON message
> 2007-11-08 08:41:33,350 INFO [GGISJSONServlet] - service() :
> FCE47520E9FB321A0B9780167DE17929
> 2007-11-08 08:41:33,350 INFO [GGISJSONServlet] - service() : reading
> 469 bytes
> 2007-11-08 08:41:33,350 INFO [GGISJSONServlet] - service() : content
> read, missing 0 bytes
> 2007-11-08 08:41:33,350 INFO [GGISJSONServlet] - service() : recieve:
> {"params":[{"scale":0.0020501002004008014,"mapExtent":{"x":1000,"y":101613.39198435973,"width":499000,"height":148773.21603128055,"upperRightCorner":{"x":500000,"y":250386.6080156403},"lowerLeftCorner":{"x":1000,"y":101613.39198435973},"ratio":3.3540983606557377,"viewBoxArray":[1000,101613.39198435973,499000,148773.21603128055],"gridCellId":null},"version":"1.0","javaClass":"be.gegis.command.GetGoogleImagesCommand"}],"method":"ApplicationController.execute","id":5}
>
> 2007-11-08 08:41:33,360 INFO [GetGoogleImagesCommand] - center
> =250500.0,325000.0
> 2007-11-08 08:41:33,360 INFO [GetGoogleImagesCommand] - zoomLevel=8
> 2007-11-08 08:41:33,360 INFO [GetGoogleImagesCommand] -
> result=i=[129,135],j=[83,86]
> ,p=com.cadrie.majas.command.jsondata.Point op 1e0bf98[x=-61581.36639197939,y=47216.40468230721]z=8w=99004.96900442586
>
> 2007-11-08 08:41:33,360 INFO [GGISJSONServlet] - send:
> {"id":5,"result":{"ymin":83,"errorMessages":{"javaClass":"java.util.ArrayList","list":[]},"ymax":86,"width":99004.96900442586,"lowerLeft":{"javaClass":"com.cadrie.majas.command.jsondata.Point","y":47216.40468230721,"x":-61581.36639197939},"javaClass":"be.gegis.command.GetGoogleImagesResult","zoomLevel":8,"xmin":129,"xmax":135}}
>
> 2007-11-08 08:41:33,360 INFO [GGISJSONServlet] - Command execution
> time: 10 ms
> 2007-11-08 08:41:33,360 INFO [GGISJSONServlet] - SESSION:
> FCE47520E9FB321A0B9780167DE17929
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - Incoming JSON message
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - service() :
> FCE47520E9FB321A0B9780167DE17929
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - service() : reading
> 866 bytes
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - service() : content
> read, missing 0 bytes
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - service() : recieve:
> {"params":[{"javaClass":"com.cadrie.majas.command.RetrievePropertiesCommand","features":["vesselposition.7a230d95:1161ba1ad51:-7f74","vesselposition.7a230d95:1161ba1ad51:-7f70","vesselposition.7a230d95:1161ba1ad51:-7f77","vesselposition.7a230d95:1161ba1ad51:-7f76","vesselposition.7a230d95:1161ba1ad51:-7f72","vesselposition.7a230d95:1161ba1ad51:-7f6c","vesselposition.7a230d95:1161ba1ad51:-7f73","vesselposition.7a230d95:1161ba1ad51:-7f75","vesselposition.7a230d95:1161ba1ad51:-7f6e","vesselposition.7a230d95:1161ba1ad51:-7f6f","vesselposition.7a230d95:1161ba1ad51:-7f6a","vesselposition.7a230d95:1161ba1ad51:-7f6d","vesselposition.7a230d95:1161ba1ad51:-7f71","vesselposition.7a230d95:1161ba1ad51:-7f69","vesselposition.7a230d95:1161ba1ad51:-7f6b"],"layer":"2","requestedPropertyNames":["vesselid"],"version":"1.2"}],"method":"ApplicationController.execute","id":6}
>
> 2007-11-08 08:41:44,466 INFO [DefaultLayerModel] - getElements() :
> getting reader for postgis:vesselposition (filtered)
> 2007-11-08 08:41:44,466 INFO [DataStoreProvider] - getFeatures() :
> vesselposition
> 43286683 [SEVERE] org.geotools.data.jdbc.JDBC1DataStore - Error
> Performing SQL query: SELECT "id", "vesselidtype",
> "portofdestination", "portofdeparture", "vesselid", "passagepoint",
> "vesselname", "signalling", "atd", "airdraught", "draught", "length",
> "width", AsText(force_2d("geom")) FROM "public"."vesselposition" WHERE
> () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR ()
> OR () OR () OR ()
> 2007-11-08 08:41:44,466 INFO [DefaultLayerModel] - getElements() :
> returning reader
> 2007-11-08 08:41:44,466 ERROR [RetrievePropertiesCommand] - execute() :
> java.util.NoSuchElementException: Could not aquire
> feature:org.geotools.data.DataSourceException: Error Performing SQL
> query: SELECT "id", "vesselidtype", "portofdestination",
> "portofdeparture", "vesselid", "passagepoint", "vesselname",
> "signalling", "atd", "airdraught", "draught", "length", "width",
> AsText(force_2d("geom")) FROM "public"."vesselposition" WHERE () OR ()
> OR () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR
> () OR ()
> at
> org.geotools.data.store.NoContentIterator.next(NoContentIterator.java:53)
> at
> com.cadrie.majas.persistence.provider.DataStoreProvider$CollectionReader.next(DataStoreProvider.java:321)
>
> at
> com.cadrie.majas.command.RetrievePropertiesCommand.execute(RetrievePropertiesCommand.java:111)
>
> at
> com.cadrie.majas.command.ApplicationController.execute(ApplicationController.java:89)
>
> at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at com.metaparadigm.jsonrpc.JSONRPCBridge.call(JSONRPCBridge.java:960)
> at
> com.cadrie.majas.core.global.GGISJSONServlet.service(GGISJSONServlet.java:252)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>
> at
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
>
> at
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
>
> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
> at java.lang.Thread.run(Unknown Source)
> Caused by: org.geotools.data.DataSourceException: Error Performing SQL
> query: SELECT "id", "vesselidtype", "portofdestination",
> "portofdeparture", "vesselid", "passagepoint", "vesselname",
> "signalling", "atd", "airdraught", "draught", "length", "width",
> AsText(force_2d("geom")) FROM "public"."vesselposition" WHERE () OR ()
> OR () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR () OR
> () OR ()
> at
> org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:937)
>
> at
> org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:669)
>
> at
> org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
>
> at
> org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:224)
>
> at
> org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:200)
>
> at
> com.cadrie.majas.persistence.provider.DataStoreProvider$CollectionReader.<init>(DataStoreProvider.java:312)
>
> at
> com.cadrie.majas.persistence.provider.DataStoreProvider.colToReader(DataStoreProvider.java:220)
>
> at
> com.cadrie.majas.persistence.provider.DataStoreProvider.getFeatures(DataStoreProvider.java:169)
>
> at
> com.cadrie.majas.core.application.DefaultLayerModel.getElements(DefaultLayerModel.java:208)
>
> at
> com.cadrie.majas.command.RetrievePropertiesCommand.execute(RetrievePropertiesCommand.java:107)
>
> ... 23 more
> Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at
> or near ")"
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
>
> at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
>
> at $Proxy1.executeQuery(Unknown Source)
> at
> org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:926)
>
> ... 32 more
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - send:
> {"id":6,"result":{"errorMessages":{"javaClass":"java.util.ArrayList","list":["Kon
> bepaalde elementen niet
> terugvinden."]},"retrievedPropertyNames":{"javaClass":"java.util.ArrayList","list":[]},"javaClass":"com.cadrie.majas.command.RetrievePropertiesResult","properties":{"javaClass":"java.util.ArrayList","list":[]}}}
>
> 2007-11-08 08:41:44,466 INFO [GGISJSONServlet] - Command execution
> time: 0 ms
> 2007-11-08 08:41:44,476 INFO [GGISJSONServlet] - SESSION:
> FCE47520E9FB321A0B9780167DE17929
>
>
>
> Jan De Moerloose wrote:
>> Eric,
>>
>> blijkbaar is er iets mis met het filter in de query, kan je misschien
>> het binnenkomende commando eens tonen? (zou moeten gelogd worden)
>>
>> Groeten,
>> Jan
>>
>>
>> Eric Smets schreef:
>>> Hallo,
>>>
>>> Ik probeer gegis te gebruiken om een aantal objecten te tonen op een
>>> kaart van het type point.
>>>
>>> Bij het gebruik van udig geeft het tonen geen probleem, bij het
>>> proberen te tonen in gegis
>>> komt er de volgende fouten melding.
>>>
>>> Heeft er iemand een idee op welke wijze er hier verder gezocht kan
>>> worden om de fout op
>>> te lossen. Een analoge fout kan gereproduceerd worden met andere
>>> gegevens.
>>>
>>> Met vriendelijke groeten,
>>>
>>> Eric Smets
>>>
>>> ---
>>> 5-Nov-2007 13:10:08 com.cadrie.majas.command.ApplicationController
>>> execute
>>> INFO: Executing command:
>>> com.cadrie.majas.command.RetrievePropertiesCommand op b0f24a
>>> 05-Nov-2007 13:10:08 org.geotools.data.jdbc.JDBC1DataStore executeQuery
>>> SEVERE: Error Performing SQL query: SELECT "id", "vesselidtype",
>>> "portofdestination", "portofdeparture", "vesselid", "passagepoint",
>>> "vesselname", "signalling", "atd", "airdraught", "draught",
>>> "length", "width", AsText(force_2d("geom")) FROM
>>> "public"."vesselposition" WHERE () OR () OR () OR () OR () OR () OR
>>> () OR () OR () OR () OR ()
>>> org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>>>
>>> at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>>>
>>> at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
>>>
>>> at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
>>>
>>> at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>> at
>>> org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
>>>
>>> at $Proxy1.executeQuery(Unknown Source)
>>> at
>>> org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:926)
>>>
>>> at
>>> org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:669)
>>>
>>> at
>>> org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
>>>
>>> at
>>> org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:224)
>>>
>>> at
>>> org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:200)
>>>
>>> at
>>> com.cadrie.majas.persistence.provider.DataStoreProvider$CollectionReader.<init>(DataStoreProvider.java:312)
>>>
>>> at
>>> com.cadrie.majas.persistence.provider.DataStoreProvider.colToReader(DataStoreProvider.java:220)
>>>
>>> at
>>> com.cadrie.majas.persistence.provider.DataStoreProvider.getFeatures(DataStoreProvider.java:169)
>>>
>>> at
>>> com.cadrie.majas.core.application.DefaultLayerModel.getElements(DefaultLayerModel.java:208)
>>>
>>> at
>>> com.cadrie.majas.command.RetrievePropertiesCommand.execute(RetrievePropertiesCommand.java:107)
>>>
>>> at
>>> com.cadrie.majas.command.ApplicationController.execute(ApplicationController.java:89)
>>>
>>> at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>> at
>>> com.metaparadigm.jsonrpc.JSONRPCBridge.call(JSONRPCBridge.java:960)
>>> at
>>> com.cadrie.majas.core.global.GGISJSONServlet.service(GGISJSONServlet.java:252)
>>>
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>>>
>>> at
>>> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>>>
>>> at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>>>
>>> at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>>>
>>> at
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>>>
>>> at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>>>
>>> at
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>>>
>>> at
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>>>
>>> at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>>>
>>> at
>>> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
>>>
>>> at
>>> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
>>>
>>> at
>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
>>>
>>> at java.lang.Thread.run(Unknown Source)
>>> 05-Nov-2007 13:10:08 com.metaparadigm.jsonrpc.BeanSerializer
>>> analyzeBean
>>> INFO: analyzing com.cadrie.majas.command.RetrievePropertiesResult
>>> 05-Nov-2007 13:10:18 com.metaparadigm.jsonrpc.BeanSerializer
>>> analyzeBean
>>>
>>>
>>
>>
>
>
>
>
--
Jan De Moerloose
DFC Software Engineering
Brugsesteenweg 587
B-9030 Gent
Belgium
T: +32 9 236.61.96
F: +32 9 236.54.12
E: jan op dfc.be
W: www.dfc.be
Meer informatie over de List
maillijst