Hi Kevin
Did you change the value of the xml element "spatialExtension" to "PGRASTER"
On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweis...@harris.com> wrote:
> Christian,****
>
> I have followed the PostGIS raster tutorial and seemed to have ended up in
> the same situation as before. When I try to add the ImageMosaic-JDBC store
> I receive the dreaded “Could not list layers for this store, an error
> occurred retrieving them: Argument "value" should not be null.” error. **
> **
>
> Here are the steps I took.****
>
> ** **
>
> I loaded the raster into the DB:****
>
> raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql**
> **
>
> psql –U xxxx –d xxxx –h xxxx –f pgraster.sql****
>
> ** **
>
> Then I created the mosaic table using the sql in the tutorial and added a
> row for my previously loaded raster:****
>
> insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);***
> *
>
> ** **
>
> Then I created the mapping, connect and coverage xml files as described in
> the tutorial only modifying the DB connection info and the coverageName
> value in the coverage xml file to match the value in the mosaic table.****
>
> ** **
>
> One thing I’ve noticed is that despite my coverageName specifying
> ‘satellite’ all lower case, I get an error stating “No level available for
> Satellite” in the GeoServer logs. When I update the name in the mosaic
> table to ‘Satellite’ then I get a NullPointerException in
> ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize
> my coverage name as all the references I’ve made are lower case.****
>
> ** **
>
> *Kevin M. Weiss*****
>
> ** **
>
> *From:* Christian Mueller [mailto:christian.muel...@os-solutions.at]
> *Sent:* Tuesday, August 06, 2013 9:04 AM
> *To:* Weiss, Kevin
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues****
>
> ** **
>
> The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and
> lacks temporal support. ****
>
> ** **
>
> The tutorial link in your previous mail is a good starting point.****
>
> ** **
>
> Cheers****
>
> Christian****
>
> ** **
>
> On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweis...@harris.com> wrote:*
> ***
>
> Hello Christian,****
>
> ****
>
> Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an
> example using the time & elevation tutorial (link below) a while back and
> just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic
> plugin and would support time-series as well.
>
> http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries
> ****
>
> ****
>
> Is this the best tutorial for configuring GeoServer with PostGIS Raster?
> Even if it doesn’t support the time parameter, I’d at least like to get a
> prototype running.
> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html**
> **
>
> ****
>
> Thanks,****
>
> ****
>
> *Kevin M. Weiss*****
>
> ****
>
> *From:* Christian Mueller [mailto:christian.muel...@os-solutions.at]
> *Sent:* Tuesday, August 06, 2013 7:42 AM****
>
>
> *To:* Weiss, Kevin
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues****
>
> ****
>
> Hi Kevin****
>
> ****
>
> I would use PostGis raster columns. ****
>
> ****
>
> Using pastebin.com for stack traces is ok, will have a look at it later.**
> **
>
> ****
>
> About temporal queries. Do you want to use the "time" parameter in WMS
> requests ? I never used it and the imagemosiac-JDBC module has no temporal
> support !!!****
>
> ****
>
> Cheers****
>
> Christian****
>
> ****
>
> ****
>
> ****
>
> On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweis...@harris.com> wrote:*
> ***
>
> Hello Christian,****
>
> For the purpose of the exercise I was using the Blobs for image data
> storage. With regards to my end goal, I’m not sold on one approach over
> the other. I’m just looking to prototype a solution that allows me to
> programmatically store spatial imagery in the database from a java
> application and have it available for display via GeoServer while allowing
> temporal queries. Along the lines of looping weather radar imagery.****
>
> ****
>
> Any help you could provide in either direction would be great.****
>
> ****
>
> Is there a preferred location for providing stack traces and such? I
> didn’t want to attach the files and spam the whole mailing list.****
>
> ****
>
> Thanks,****
>
> ****
>
> *Kevin M. Weiss*****
>
> ****
>
> *From:* Christian Mueller [mailto:christian.muel...@os-solutions.at]
> *Sent:* Tuesday, August 06, 2013 5:16 AM
> *To:* Weiss, Kevin
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues****
>
> ****
>
> Hi Kevin****
>
> ****
>
> A question, do you want to use PostGis Raster columns as described here **
> **
>
> http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>
> ****
>
> ****
>
> or do you want to use Blobs for your image data.****
>
> ****
>
> At the moment, I have no access to pastebin.com due to firewall rules of
> my customer.****
>
> ****
>
> Cheers****
>
> Christian****
>
> ****
>
> ****
>
> ****
>
> ****
>
> On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweis...@harris.com> wrote:
> ****
>
> I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (
> http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>)
> and keep getting the following error "Could not list layers for this store,
> an error occurred retrieving them: Argument "value" should not be null."
>
> I've searched through the mailing list and have seen similar threads, but
> can't find a solution to the problem. If anyone can help me out I'd
> appreciate it. I'll attach pastebin links for the typically requested
> files.
>
> The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added.
> Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0
> database.
>
> As a side note, my end goal is to construct a Raster Catalog containing
> temporal imagery which can be retrieved and looped via GeoServer with the
> rasters being persisted in postgres/postgis. If anyone has accomplished
> something similar and is willing to give me some help or tips I would
> greatly appreciate it.
>
> Here is the relevant stacktrace from geoserver.log
> http://pastebin.com/trL6zpmX
>
> osm.postgis.xml
> http://pastebin.com/x0KaJB0n
>
> mapping.postgis.xml.inc
> http://pastebin.com/KLpFDmtK
>
> connect.postgis.xml.inc
> http://pastebin.com/P8FwtcKS
>
> Thanks,
>
> Kevin M. Weiss
>
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent
> caught up. So what steps can you take to put your SQL databases under
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users****
>
>
>
> ****
>
> ****
>
> -- ****
>
> DI Christian Mueller MSc (GIS), MSc (IT-Security)****
>
> OSS Open Source Solutions GmbH****
>
> ****
>
>
>
> ****
>
> ****
>
> -- ****
>
> DI Christian Mueller MSc (GIS), MSc (IT-Security)****
>
> OSS Open Source Solutions GmbH****
>
> ****
>
>
>
> ****
>
> ** **
>
> -- ****
>
> DI Christian Mueller MSc (GIS), MSc (IT-Security)****
>
> OSS Open Source Solutions GmbH****
>
> ** **
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
