[geGIS] Fout bij het tonen van Punten

[Eric Smets]

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

-- 
Eric Smets                                    eric.smets op fks.be
FKS bvba - Formal and Knowledge Systems       http://www.fks.be/
Stationsstraat 108                            Tel:  ++32-(0)11-21 49 11
B-3570 Alken                                  Fax:  ++32-(0)11-22 04 19