Do you have a record in you table called IMAGE ? The id attribute of the table must hold the coverage name, in your case this is "IMAGE". The image attribute must hold the georaster object.
You need exactly one record for each georaster object. Cheers Quoting Aakerø Snorre <[email protected]>: > Hi. > Im trying to create a WCS service in Geoserver using georaster from > Oracle. I have installed the > geoserver-2.1-beta3-imagemosaic-jdbc-plugin. > ImageMosaicJDBC is available in Add raster data source, but I always > get this error: "Unable to acquire a reader for this coverage with > format ImageMosaicJDBC" when I try to save and create the data > source. The error seems to occur "independent" of the content of my > config xml file. > Any hints or sample of how this is done? > > My xml file (with Connection Parameters) looks like: > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <config version="1.0"> > <coverageName name="IMAGE"/> > <coordsys name="EPSG:32632"/> > <!-- interpolation 1 = nearest neighbour, 2 = > bipolar, 3 = bicubic --> > <scaleop interpolation="1"/> > <spatialExtension name="georaster"/> > <!-- <mapping> > <masterTable name="IMAGE" > > <geoRasterAttribute name="IMAGE"/> > <coverageNameAttribute name="IMAGE"/> > </masterTable> > </mapping> --> > <connect> > <!-- value DBCP or JNDI --> > <dstype value="DBCP"/> > <!-- <jndiReferenceName value=""/> > --> > > <username value="username" /> > <password value="password" /> > > <jdbcUrl value="jdbc:oracle:thin:@myipadress:1521:data3d" /> > <driverClassName > value="oracle.jdbc.OracleDriver"/> > <maxActive value="10"/> > <maxIdle value="0"/> > </connect> > </config> > > > My software versions are: > > - Geoserver: > > o Version 2.1-beta3 > o Subversion Revision 15191 > o Build Date 17-Dec-2010 15:44 > o GeoTools Version 2.7-SNAPSHOT (rev 36402) > > - Oracle 11g r2 > > - WebLogic Server Version: 10.3.3.0 > > Raster image tables in Oracle georaster: > > SQL> desc image > Name Null? Type > ----------------------------------------- -------- > ---------------------------- > ID NUMBER > IMAGE MDSYS.SDO_GEORASTER > > SQL> desc image2 > Name Null? Type > ----------------------------------------- -------- > ---------------------------- > RASTERID NOT NULL NUMBER > PYRAMIDLEVEL NOT NULL NUMBER > BANDBLOCKNUMBER NOT NULL NUMBER > ROWBLOCKNUMBER NOT NULL NUMBER > COLUMNBLOCKNUMBER NOT NULL NUMBER > BLOCKMBR MDSYS.SDO_GEOMETRY > RASTERBLOCK BLOB > > > Best regards > Snorre T. Aakerø > Senior systemkonsulent > Dir: +47 73 20 46 67 | Mob: +47 454 04 667 > > Norconsult Informasjonssystemer AS > Ingvald Ystgaardsv. 3A, 7047 Trondheim > Tel: +47 40 62 40 00 | Fax: +47 67 54 45 76 > www.nois.no > > CONFIDENTIALITY AND DISCLAIMER NOTICE: This message is for the sole > use of the intended recipients and may contain confidential > information. If you are not an intended recipient, you are requested > to notify the sender by reply e-mail and destroy all copies of the > original message. Any unauthorized review, use, disclosure or > distribution is prohibited. While the sender has taken reasonable > precautions to minimize the risk of viruses, we cannot warrant the > absence of, or accept liability for, any such viruses in this > message or any attachment. > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
