Hi all,
5) Exceptions before ( sorry I missed those, seems that the clue is in there ) )
When I try out the query "select extent(geom) from tileosm_1" it succeeds .... but the funtion st_extent does not exist anymore ( we have version 8.3 )
SEVERE: ERROR: function st_extent(geometry) does not exist
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader <init>
SEVERE: ERROR: function st_extent(geometry) does not exist
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat getReader
WARNING: ERROR: function st_extent(geometry) does not exist
java.io.IOException: ERROR: function st_extent(geometry) does not exist
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.<init>(ImageMosaicJDBCReader.java:173)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:204)
at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:479)
at org.vfny.geoserver.global.CoverageStoreInfo.getReader(CoverageStoreInfo.java:339)
at org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:95)
at org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
......
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.JDBCAccessBase calculateExtentsFromDB
INFO: Calculate extent for Coverage: osm:tileosm_0:tileosm_0
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.JDBCAccessBase initialize
SEVERE: ERROR: function st_extent(geometry) does not exist
org.postgresql.util.PSQLException: ERROR: function st_extent(geometry) does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1591)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1340)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.geotools.gce.imagemosaic.jdbc.JDBCAccessPostGis.getExtent(JDBCAccessPostGis.java:113)
at org.geotools.gce.imagemosaic.jdbc.JDBCAccessBase.calculateExtentsFromDB(JDBCAccessBase.java:384)
at org.geotools.gce.imagemosaic.jdbc.JDBCAccessBase.initialize(JDBCAccessBase.java:128)
at org.geotools.gce.imagemosaic.jdbc.JDBCAccessFactory.getJDBCAcess(JDBCAccessFactory.java:70)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.<init>(ImageMosaicJDBCReader.java:170)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:204)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:152)
at org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:98)
at org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
..........
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.JDBCAccessBase initialize
SEVERE: ERROR: function st_extent(geometry) does not exist
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader <init>
SEVERE: ERROR: function st_extent(geometry) does not exist
Jun 27, 2009 12:38:03 PM org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat getReader
WARNING: ERROR: function st_extent(geometry) does not exist
java.io.IOException: ERROR: function st_extent(geometry) does not exist
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.<init>(ImageMosaicJDBCReader.java:173)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:204)
at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:152)
at org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:98)
at org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
......
________________________________________
Van: Christian Müller [christian.mueller@anonymised.com]
Verzonden: vrijdag 26 juni 2009 13:03
Aan: Kempenaers Stephen
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: imagemosaic-jdbc plugin
1)
If your reach the "Coverage Data Set Editor" then the imagemoasicjdbc jar
file is in the classpath, must be ok
2)
I assume you created the sql ddl files with the tools. I further assume you
imported the tiles with the tool.
If this is the case, your config should be ok.
3) The configuration error occurs if the imagemosaicjdbc jars are not on the
class path, this is not the case.
A second possibility is that that you have a typing error in your
osm.postgis.xml. Check if you find the String
"coverageName" in the xml file.
A third possibility is that the URL "file:coverages/osm.postgis.xml" could
not be found. If you look at the log, geoserver reports the location of the
GEOSERVER_DATA_DIR. The correct location of the config file is
GEOSERVER_DATA_DIR/coverages/osm.postgis.xml
4) There should be some lines in the log before the stack trace of the
exception. If the problem persists, configure geoserver to log into a file
(loglevel WARNING or better INFO) and send me the whole log file. If it is
to big for the mailing list, send it direct to my mail address.
Kempenaers Stephen writes:
Hi,
1,2) I have both in my webapps/geoserver/WEB-INF/lib/
here's a list of the concrete jars that are in that directory:
....
gt-imagemosaic-jdbc-2.5.5.jar
postgis-driver-1.0.jar
postgresql-8.1-407.jdbc3.jar
....
3) So here's the exception:
GeoServer - Exception
The following exception was thrown:
* class org.vfny.geoserver.global.ConfigurationException: Could not obtain a reader for the CoverageDataSet. Please check the CoverageDataSet configuration!
Details:
org.vfny.geoserver.global.ConfigurationException: Could not obtain a reader for the CoverageDataSet. Please check the CoverageDataSet configuration!
at org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:102)
at org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:163)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
________________________________________
Van: Christian Müller [christian.mueller@anonymised.com]
Verzonden: donderdag 25 juni 2009 17:09
Aan: Kempenaers Stephen
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: imagemosaic-jdbc plugin
I will check why the zip file contains only readme and license file.
1) Did you copy the imagemosaicjdbc jar file in the zip file to WEB-INF/lib
?
2) Is the postgis driver jar on your classpath, it should be in WEB-INF/lib
if you rely on the web application class loader or in JAVA_HOME/jre/lib/ext
if you prefer letting the extension class loader making the job
3) If nothing helps, can you send me a full stack trace from the log file or
console window.
Kempenaers Stephen writes:
Hi all,
I'm trying to use the imagemosaic-jdbc plugin for my raster data, I'm trying to follow the tutorial on "http://docs.geoserver.org/1.7.x/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html"
But I keep on getting the exception "Could not obtain a reader for the CoverageDataSet"
All goes well until I try to add the layer in geoserver ( 1.7.4 ) with the form 'Coverage Data Set Editor", then I get that exception.
I have checked the content of the PostGis Database, checked the geometries, checked the file permissions etc, but I can't get it running ....
I started out with 1.7.5, but the link for the imagemosaic-jdbc extension points to an empty zip file, that's why I switched to version 1.7.4
Regards,
Stephen
---
This e-mail, any attachments and the information it contains are confidential and meant only for the use of the addressee(s) only. Access to this e-mail by anyone other than the addressee(s) is unauthorized. If you are not the intended addressee (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message and notify the sender immediately. If you have received this e-mail in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer.
All reasonable precautions have been taken to ensure no viruses are present in this e-mail and its attachments. As our company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use.
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users