[geGIS] Fout bij het tonen van Punten

Eric Smets eric.smets op fks.be
Do Nov 8 08:47:37 CET 2007 

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
>>
>>   
>
>

Meer informatie over de List maillijst