[geGIS] Fout bij het tonen van Punten

Eric Smets eric.smets op fks.be
Do Nov 8 11:13:59 CET 2007 

Jan,

Het klopt inderdaad dat er een "primary" key op de tabel diende aanwezig 
te zijn.
Dank je wel om mij op weg te helpen.

mvg,

Eric

---

Jan De Moerloose wrote:
> 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
>>>>
>>>>   
>>>
>>>
>>
>>
>>
>>
>
>

Meer informatie over de List maillijst