Re: [Geoserver-users] problem with Oracle Georaster via Imagemosaic JDBC

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi, can you cross check your table

GEORASTER50

There must be a record with COVTYPE="ortofoto2011" and a valid raster  
in GEORASTER.

It looks to me if there is no record found. Unfortunately, I do not  
see the original exception in the stack trace.

Christian

Zitat von Balázs Bámer <bam...@gm...>:

> Hi All,
>
> I use Geoserver
>     Version 2.1.2
>     Subversion Revision -1
>     Build Date 06-ott-2011 11:09
>     GeoTools Version 2.7.3 (rev -1)
>
> I have a problem connecting to an Oracle database via Imagemosaic JDBC
> to create a Georaster layer. For experiments, I've created a normal
> table with a sdo_geometry column to check if the database connection
> is wrong. I can create a layer either with Oracle NG, or Oracle NG
> JNDI store (using JNDI reference name java:comp/env/jdbc/raster ), the
> layer can be published.
> However, if I try to create an Imagemosaic JDBC store using a suitable
> table in the database, I get error message. I've filled the Add Raster
> Data Source as here:
>
> Workspace: ortofoto2011
> Data Source Name: ortofoto2011
> Description: dsfdfg
> Enabled: true
> URL: file:data/ortofoto2011.xml
>
> Could not list layers for this store, an error occurred retrieving
> them: Unable to acquire a reader for this coverage with format:
> ImageMosaicJDBC
>
> The configuration file contains:
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <config version="1.0">
> 	<coverageName name="ortofoto2011"/>
> 	<coordsys name="EPSG:23700"/>
> <!-- interpolation 1 = nearest neighbour, 2 = bipolar, 3 = bicubic -->
> 	<scaleop interpolation="1"/>
> 	<spatialExtension name="georaster"/>
> 	<mapping>
> 		<masterTable name="GEORASTER50" >
> 			<geoRasterAttribute name="GEORASTER"/>
> 			<coverageNameAttribute name="COVTYPE"/>
> 		</masterTable>
> 	</mapping>
> 	<connect>
> <!-- value DBCP or JNDI -->
> 		<dstype value="JNDI"/>
> <jndiReferenceName value="java:comp/env/jdbc/raster"/>
> 	</connect>
> </config>
>
> I've tried with DBCP and the appropriate options, same results.
>
> What cen be the problem?
> thank you in advance, best regards: Balázs Bámer
>
> On the console I get
>
> 22 febr. 14:42:45 WARN [imagemosaic.jdbc] - java.sql.SQLException:
> Exhausted Resultset
> java.io.IOException: java.sql.SQLException: Exhausted Resultset
>         at   
> org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.<init>(ImageMosaicJDBCReader.java:163)
>         at   
> org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:209)
>         at   
> org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:66)
>         at   
> org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:977)
>         at   
> org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:766)
>         at   
> org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:82)
>         at   
> org.geoserver.web.wicket.GeoServerDataProvider.fullSize(GeoServerDataProvider.java:225)
>         at   
> org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.updateMatched(GeoServerTablePanel.java:509)
>         at   
> org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.<init>(GeoServerTablePanel.java:502)
>         at   
> org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:200)
>         at   
> org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:91)
>         at   
> org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:107)
>         at   
> org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:104)
>         at   
> org.geoserver.web.data.store.CoverageStoreNewPage.onSave(CoverageStoreNewPage.java:71)
>         at   
> org.geoserver.web.data.store.AbstractCoverageStorePage$1.onSubmit(AbstractCoverageStorePage.java:114)
>         at   
> org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:68)
>         at   
> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:143)
>         at   
> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177)
>         at   
> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300)
>         at   
> org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)
>         at   
> org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)
>         at   
> org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250)
>         at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329)
>         at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436)
>         at org.apache.wicket.RequestCycle.request(RequestCycle.java:545)
>         at   
> org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)
>         at   
> org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:160)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>         at   
> org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158)
>         at   
> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
>         at   
> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
>         at   
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
>         at   
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
>         at   
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
>         at   
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
>         at   
> org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
>         at   
> org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
>         at   
> org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
>         at   
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
>         at   
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
>         at   
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
>         at   
> org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>         at   
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at   
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at   
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at   
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>         at   
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>         at   
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         at   
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>         at   
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
>         at   
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
>         at   
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
>         at java.lang.Thread.run(Thread.java:722)
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Geoserver-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.