Hi, I am the developer. To clarify the situation. You have a sql table called RASTER. This table has 2 Attributes NAME and IMAGE. The table has exactly one row. The value of NAME is CIP_ORTHOS The value of IMAGE is the georaster object.
Is this correct ? Quoting bryanhall <[email protected]>: > > Using GeoServer 2.0, I am having a problem adding a data store for georaster > using the ImageMosaicJDBC plugin. I have a working set of orthos loaded into > Oracle 11gR2 (loaded and viewed with FME). To keep first test simple, I > followed the documentation and used a tablename of RASTER with a NAME and > IMAGE column. > > I then added the extension jar and GeoServer found the plugin no problem. > > I edited and copied this config file (per the documentation and links), and > placed it in the coverages directory: > > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <config version="1.0"> > <coverageName name="CIP_ORTHOS"/> > <coordsys name="EPSG:4326"/> > <!-- interpolation 1 = nearest neighbour, 2 = bipolar, 3 = bicubic --> > <scaleop interpolation="1"/> > <spatialExtension name="georaster"/> > <mapping> > <masterTable name="RASTER" > > <geoRasterAttribute name="IMAGE"/> > <coverageNameAttribute name="NAME"/> > </masterTable> > </mapping> > <connect> > <!-- value DBCP or JNDI --> > <dstype value="DBCP"/> > <!-- <jndiReferenceName value=""/> --> > > <username value="cvc_raster" /> > <password value="password" /> > > <jdbcUrl value="jdbc:oracle:thin:@servername:port:instancename" > /> > <driverClassName value="oracle.jdbc.OracleDriver"/> > <maxActive value="10"/> > <maxIdle value="0"/> > </connect> > </config> > > (of course the jdbcUrl is obfuscated here). The connection does test fine > BTW. > > I then opened the "Add Raster Data Store" page and put in the following > values: > > Workspace: CIP (same as working vector data) > Data Source Name: cvc_raster > Connection Parameters: file:/coverages/GeoServer_Raster_Config.xml > > The config file is found, but it doesn't like something. I would bet on the > Data Source Name. I tried many things there (cvc_raster, CIP_ORTHOS, etc.), > but always get this error: > > Could not list layers for this store, an error occurred retrieving them: > Unable to acquire a reader for this coverage with format: ImageMosaicJDBC > > At this point I added a JDBC data source also called cvc_raster (thinking > that is what it needed). No luck. Restarted the Java Server, no luck. > > Ideas? > > Thanks in advance... > -- > View this message in context: > http://old.nabble.com/ImageMosaic-JDBC-setup-for-Oracle-GeoRaster---How--tp30366634p30366634.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > What happens now with your Lotus Notes apps - do you make another costly > upgrade, or settle for being marooned without product support? Time to move > off Lotus Notes and onto the cloud with Force.com, apps are easier to build, > use, and manage than apps on traditional platforms. Sign up for the Lotus > Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
