Hello! I'm trying to add an ImageMosaicJDBC data store to my Geoserver 2.8.0 instance, but am receiving this error:
Error: could not list layers for this store, an error occurred retrieving them: Failed to create reader from …. and hints null. I've spent some time searching for solutions, but thus far have been stumped. A little background about the process: -Followed this link as tutorial/Mastering Geoserver book: http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html -local Geoserver version (2.8.0) matches ImageMosaicJDBC Plugin version (gt-imagemosaic-jdbc-14.0), which is the 2.8.0 extension jar -able to create ImagePyramid in local data directory using same dataset, able to preview layer created from ImagePyramid *Dataset:* 3 inch imagery from USGS covering small section of Maryland *Preprocessing:* -ImagePyramid processed using gdal_retile -ImageMosaicJDBC imported to Postgres using raster2pgsql -populated public schema with md_3inch, o_2_md_3inch, o_4_md_3inch, o_8_md_3inch, o_16_md_3inch *Metadata table:* `CREATE TABLE watersuite_raster_metadata ( coverage_name character varying(254) NOT NULL, tiletable character varying(254) NOT NULL, minx double precision, miny double precision, maxx double precision, maxy double precision, resx double precision, resy double precision, CONSTRAINT watersuite_raster_metadata_pkey PRIMARY KEY (coverage_name, tiletable)` -Metadata table populated with record for each table. *XML Configuration files:* connect.pgraster.xml.inc <connect> <dstype value="DBCP" /> <username value="####" /> <password value="####" /> <jdbcUrl value="jdbc:postgresql://localhost:5432/Test" /> <driverClassName value="org.postgresql.Driver" /> <maxActive value="10" /> <maxIdle value="0" /> </connect> mapping.pgraster.xml.inc <spatialExtension name="pgraster"/> <mapping> <masterTable name="watersuite_raster_metadata" > <coverageNameAttribute name="coverage_name" /> <maxXAttribute name="maxx" /> <maxYAttribute name="maxy" /> <minXAttribute name="minx" /> <minYAttribute name="miny" /> <resXAttribute name="resx" /> <resYAttribute name="resy" /> <tileTableNameAttribute name="tiletable" /> </masterTable> <tileTable> <blobAttributeName name="rast" /> </tileTable> </mapping> md3inch.pgraster.xml <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE ImageMosaicJDBCConfig [ <!ENTITY mapping PUBLIC "mapping" "mapping.pgraster.xml.inc"> <!ENTITY connect PUBLIC "connect" "connect.pgraster.xml.inc">]> <config version="1.0"> <coverageName name="md_3inch"/> <coordsys name="EPSG:4326"/> <!-- interpolation 1 = nearest neighbor, 2 = bipolar, 3 = bicubic --> <scaleop interpolation="1"/> <axisOrder ignore ="false"/> &mapping; &connect; </config> Any help would be greatly appreciated! -- Ty Swavely GIS Analyst Corona Environmental Consulting
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
