3

There is another question about raster data for GeoServer. Conditions: - PostGIS 2.0.3 and PostgreSQl 9.2. - I followed: http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html step by step.

I got an error:

    java -jar "c:\..\gt-imagemosaic-jdbc-11.2.jar" import  - config c:\..\osm.postgis.xml -spatialTNPrefix
tileosm -tileTNPrefix tileosm -dir c:\..\tiles\ -ext png
java.io.IOException: select srid from geometry_columns where f_table_schema=? an
d f_table_name=? and f_geometry_column=?  has no result for public,tileosm_0,geo
m
        at org.geotools.gce.imagemosaic.jdbc.Import.calculateSRS(Import.java:600
)
        at org.geotools.gce.imagemosaic.jdbc.Import.<init>(Import.java:203)
        at org.geotools.gce.imagemosaic.jdbc.Import.start(Import.java:400)
        at org.geotools.gce.imagemosaic.jdbc.Toolbox.main(Toolbox.java:46)

The reference system and geometry were added by

psql -U postgres -d gis  -f "c:\Program Files\PostgreSQL\9.3\share\contrib\postgis-2.1\spatial_ref_sys.sql"

psql -U postgres -d gis -f "c:\Program Files\PostgreSQL\9.3\share\contrib\postgis-2.1\postgis.sql"

Has anybody have an idea what is the problem? I had the same with the real database not only in this tutorial.

  • Can you include a link to the other "question about raster data for GeoServer", please? – PolyGeo Nov 26 '15 at 11:58
-1

Check your database connection.

Had the same error caused by a typo in the connect.xml file.

So the java utility couldn't write in the database.

  • That is unlikely to be the reason. – John Powell Nov 26 '15 at 12:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.