Hi Christian,

 

I have found the problem by stepping though the source in eclipse. A simple 
problem only: the name in the config xml did not match the row in the database.

 

The table in the database is

CREATE TABLE test (image_id NUMBER PRIMARY KEY, image_description 
VARCHAR2(50),image SDO_GEORASTER);

 

My sample row in the database had

 

SQL> select * from test;

  IMAGE_ID IMAGE_DESCRIPTION
---------- --------------------------------------------------
IMAGE(RASTERTYPE, SPATIALEXTENT(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELE

--------------------------------------------------------------------------------

         1 TIFF
SDO_GEORASTER(21001, NULL, 'TEST_RDT', 5, XMLTYPE(<georasterMetadata 
xmlns="http://xmlns.oracle.com/spatial/georaster";>  <objectI))


SQL>

 

The config file had 

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
    <coverageName name="terrametrics"/>
    <coordsys name="EPSG:4326"/>

    <!-- interpolation 1 = nearest neighbour, 2 = bipolar, 3 = bicubic -->
    <scaleop  interpolation="1"/>
    <spatialExtension name="georaster"/>        
    <mapping>        
        <masterTable name="TEST" >
            <geoRasterAttribute name="IMAGE"/>
            <coverageNameAttribute name="IMAGE_DESCRIPTION"/>
        </masterTable>
    </mapping>

:

:

 

 

So, "terrametrics" did not match "TIFF". Once I updated the database 
IMAGE_DESCRIPTION to 'terrametrics' it all worked fine.

 

 

When debugging, I did notice I was stepping over a lot of useful log messages 
that hadn't been appearing in the geoserver.log file, even when I put ALL on. 
Not sure what happened there.

 

Thanks for all your help.

 

Regards, Paul


                                          
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to