GeoServer Sql view setup error?

[المشرف العام]

The problem goes like this: I am trying to route osm data with the help of this tutorial (http://workshop.pgrouting.org) but in the step where I create the sql view and add the parameteres it fails to create the layer boundries.

This is the error I get: java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds for pgrouting at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:540).....aused by: java.io.IOException: Error occured calculating bounds for pgrouting at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1309) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:533) ... 116 moreCaused by: org.postgresql.util.PSQLException: ERROR: Support for id,source,target columns only of type: integer. Support for Cost: double precision Where: PL/pgSQL function pgr_dijkstra(text,bigint,bigint,boolean,boolean) line 6 at assignmentPL/pgSQL function pgr_fromatob(character varying,double precision,double precision,double precision,double precision) line 35 at FOR over EXECUTE statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)

Does anyone have a clue?

Thanks!



أكثر...