Hello,
I have a question about how you specify the location of the metadata table
when connecting a PostGIS raster dataset, using the JDBC plugin.
I have sucessfully created a JDBC data store using rasters found in other
schemas.
name | tiletable |
------------------+--------------------------------+
globcover_mosaic | raster_pyramids.globcover |
globcover_mosaic | raster_pyramids.o_16_globcover |
globcover_mosaic | raster_pyramids.o_2_globcover |
globcover_mosaic | raster_pyramids.o_32_globcover |
globcover_mosaic | raster_pyramids.o_4_globcover |
globcover_mosaic | raster_pyramids.o_8_globcover |
I want to take this one step further and have the meta data table
globcover_mosaic be in a nonpublic schema. Here are some options I have
considered
1. Change the coverage name to schema.table
<coverageName name="raster_pyramids.globcover_schema_mosaic"/>
2. Change the connection parameter of the xml to reference the schema
<jdbcUrl value="jdbc:postgresql://
dre.cla.umn.edu:5432/terrapop_v1_staging_dahaynes_ii?currentSchema=raster_pyramids
"/>
These changes only return the error that can list layers error
This is the trace back.
Caused by: java.io.IOException: No level available for
raster_pyramids.globcover_mosaic
at
org.geotools.gce.imagemosaic.jdbc.custom.JDBCAccessPGRaster.initialize(JDBCAccessPGRaster.java:147)
at
org.geotools.gce.imagemosaic.jdbc.JDBCAccessFactory.getJDBCAcess(JDBCAccessFactory.java:91)
at
org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.<init>(ImageMosaicJDBCReader.java:160)
--
David Haynes, Ph.D.
Research Associate Terra Populus
Minnesota Population Center
www.terrapop.org
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
