[geGIS] Fout bij het tonen van Punten

[Jan De Moerloose]

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