[Geoserver-users] GeoServer + PostGIS + Raster...

Hi everyone!

I've been having some problems trying to publish some rasters through GeoServer. Yes, I know about ImageMosaic-JDBC but that still doesn't do the trick. Thing is, the data I'm storing as a raster I have to store it "manually" since it's given to me in text format. So far I've had no problem storing this information in PostGIS as raster. I've even tried OpenJUMP out to see if data was stored as it should be, and so it is. The problem comes when publishing it via Geoserver. I added the ImageMosaic-JDBC plugin to geoserver and I also found this:

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

But I can't find the corresponding jar file in the geotools download. I'm not sure if it's just included in the ImageMosaic-JDBC but I tried configuring it for "pgraster" and I get a

"java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: sourceXSubsampling <= 0!"

error. I have configured my postgis database to match the configuration. Here is my config xml file:

<config version="1.0">
    <coverageName name="oek"/>
    <coordsys name="EPSG:4326"/>
    <!-- interpolation 1 = nearest neighbour, 2 = bilinear, 3 = bicubic -->
    <scaleop interpolation="1"/>
<!--
    <verify cardinality="false"/>
-->
    <!-- possible values: universal,postgis,db2,mysql,oracle -->
  <spatialExtension name="pgraster"/>
  <mapping>
    <masterTable name="mosaic" >
    <coverageNameAttribute name="name"/>
    <maxXAttribute name="maxx"/>
    <maxYAttribute name="maxy"/>
    <minXAttribute name="minx"/>
    <minYAttribute name="miny"/>
    <resXAttribute name="resx"/>
    <resYAttribute name="resy"/>
    <tileTableNameAtribute name="tiletable" />
    </masterTable>
    <tileTable>
        <blobAttributeName name="rast" />
    </tileTable>
  </mapping>
    <connect>
    <!-- value DBCP or JNDI -->
    <dstype value="DBCP"/>
    <!-- <jndiReferenceName value=""/> -->
    <username value="postgis" />
    <password value="ih8java00" />
    <jdbcUrl value="jdbc:postgresql://localhost:5432/geosDB" />
    <driverClassName value="org.postgresql.Driver"/>
    <maxActive value="10"/>
    <maxIdle value="0"/>
    </connect>
</config>

So, Am I missing the jar? If so, where can I download it? (i've looked over and over in the geotools download zip, but it's nowhere to be seen)

--

Mikel Gonzalez Gainza,
Software garatzaile bekaduna CENER-en // Becario desarrollador de software en CENER
www.cener.com