[Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Harikumar_Reddy · May 25, 2011, 8:26am

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but for georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are occupying bulk disk size…and possibility to access with openlayers api or any other api (or anyone is using oracle mapviewer and using any oracle map api’s for only georaster). ImagemosaicJDBC is giving problems and no consistent solutions to resolve this issues. one of the main problem i am facing now is given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver 2.0.2 version. We have successfully installed and working on test server environment, but when tried to do the same implementation in the deployment environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK, ImagemosaicJDBC plugin has to be more consistent like vector layers configarations in GS. This error i have encountered before also and with help of GS users tech forum and checking one by one jar files, successfully configured (copying 2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC version is also taken correct version)

can anyone explain the parameters Normally this value is filled in the ID coloumn record (please correct me if i am wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================

<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================

The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for saved store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC
at org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage reader ‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing coverage reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

Christian_Mueller · May 25, 2011, 9:31am

Hi, I am the developer.
Your config file looks good and yes, the coverageName goes into the id column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file, please zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are occupying
bulk disk size...and possibility to access with openlayers api or any other
api (or anyone is using oracle mapviewer and using any oracle map api's for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing now is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver 2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK, ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured (copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC version
is also taken correct version)

can anyone explain the parameters <coverageName name="SAT"/> Normally this
value is filled in the ID coloumn record (please correct me if i am wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
     <coverageName name="SAT"/>
     <coordsys name="EPSG:4326"/>
     
     <scaleop interpolation="1"/>
     <spatialExtension name="georaster"/>
     <mapping>
         <masterTable name="GEOR_SAT1" >
             <geoRasterAttribute name="GEORASTER"/>
             <coverageNameAttribute name="ID"/>
         </masterTable>
     </mapping>
     <connect>
         
         <dstype value="DBCP"/>


         <username value="mytestcon" />
         <password value="mytestcon" />

         <jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
           <driverClassName value="oracle.jdbc.OracleDriver"/>
        <maxActive value="10"/>
         <maxIdle value="0"/>
     </connect>
</config>

*The error log is also pasted below.*

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an error
occurred retrieving them: Unable to acquire a reader for this coverage with
format: ImageMosaicJDBC

    at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
    at
org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
    at
org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
    at
org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
    at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
    at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
    at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.<init>(GeoServerTablePanel.java:442)
    at
org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:188)
    at
org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:82)
    at
org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:95)
    at
org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:92)
    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:94)
    at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
    at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
    at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
    at
org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
    at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
    at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
    at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
    at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
    at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
    at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
    at
org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
    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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
    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:275)
    at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    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:73)
    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:47)
    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:298)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this coverage
with format: ImageMosaicJDBC
    at
org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
    at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
    ... 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage reader
'sri1'
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing coverage
reader 'sri1'

Any suggestions on how to resolve this issue...

Many thanks in advance,
Hari.

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

Harikumar_Reddy · May 25, 2011, 2:04pm

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster with geoserver and succeeded (problem is i am thinking of consistency). But i didn’t expect that again i will struggle for the same problem…

I have made chages to the Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your advise. i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check the jdbc driver classpath on linux, as i am into pure gis domain with windows os and dont have much linux knowledge.

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.
Your config file looks good and yes, the coverageName goes into the id column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file, please zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are occupying
bulk disk size…and possibility to access with openlayers api or any other
api (or anyone is using oracle mapviewer and using any oracle map api’s for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing now is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver 2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK, ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured (copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC version
is also taken correct version)

can anyone explain the parameters Normally this
value is filled in the ID coloumn record (please correct me if i am wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an error
occurred retrieving them: Unable to acquire a reader for this coverage with
format: ImageMosaicJDBC

at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at
org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at
org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at
org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at
org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at
org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this coverage
with format: ImageMosaicJDBC
at
org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

Christian_Mueller · May 25, 2011, 3:05pm

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency). But
i didn't expect that again i will struggle for the same problem...

I have made chages to the
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties as per your advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check the
jdbc driver classpath on linux, as i am into pure gis domain with windows os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option -verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.
Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file, please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size...and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api's
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver 2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured (copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC version
is also taken correct version)

can anyone explain the parameters <coverageName name="SAT"/> Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
    <coverageName name="SAT"/>
    <coordsys name="EPSG:4326"/>
    
    <scaleop interpolation="1"/>
    <spatialExtension name="georaster"/>
    <mapping>
        <masterTable name="GEOR_SAT1" >
            <geoRasterAttribute name="GEORASTER"/>
            <coverageNameAttribute name="ID"/>
        </masterTable>
    </mapping>
    <connect>
        
        <dstype value="DBCP"/>


        <username value="mytestcon" />
        <password value="mytestcon" />

        <jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
          <driverClassName value="oracle.jdbc.OracleDriver"/>
       <maxActive value="10"/>
        <maxIdle value="0"/>
    </connect>
</config>

*The error log is also pasted below.*

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

   at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
   at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
   at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
   at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
   at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
   at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
   at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.<init>(GeoServerTablePanel.java:442)
   at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:188)
   at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:82)
   at
org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:95)
   at
org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:92)
   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:94)
   at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
   at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
   at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
   at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
   at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
   at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
   at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
   at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
   at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
   at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
   at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
   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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
   at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
   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:275)
   at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
   at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
   at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
   at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
   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:73)
   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:47)
   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:298)
   at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
   at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
   at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
   at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
   at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
   ... 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage reader
'sri1'
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader 'sri1'

Any suggestions on how to resolve this issue...

Many thanks in advance,
Hari.

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

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

Harikumar_Reddy · May 26, 2011, 8:00am

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s a BIG success as one of the best web map servers today.

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder and downloaded and copied again. Restarted our server. It worked. There was no change in the jar files version from already implemented system and the current new implementation system.

java path & other configurations verified and looks ok. Last time it was solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) & other jar files of oracle jdbc (you have specified yesterday too, there is an additional ojdbc14_g.jar also copied). It was same implementation we were already having and working fine.

I found one imteresting document for ImagemosaicJDBC and a team is working (CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC version developed by your team. You can find the details in the given url. They have described that the latest jar may be checked in soon on geoserver repository soon, once they will complete all the tests. The contact email-id is dbaskar@anonymised.com

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency). But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check the
jdbc driver classpath on linux, as i am into pure gis domain with windows os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option -verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.
Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file, please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver 2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured (copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format: ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

Christian_Mueller · May 26, 2011, 10:16am

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver's
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is *dbaskar@anonymised.com*

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn't expect that again i will struggle for the same problem...

I have made chages to the
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size...and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api's
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters <coverageName name="SAT"/> Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
   <coverageName name="SAT"/>
   <coordsys name="EPSG:4326"/>
   
   <scaleop interpolation="1"/>
   <spatialExtension name="georaster"/>
   <mapping>
       <masterTable name="GEOR_SAT1" >
           <geoRasterAttribute name="GEORASTER"/>
           <coverageNameAttribute name="ID"/>
       </masterTable>
   </mapping>
   <connect>
       
       <dstype value="DBCP"/>


       <username value="mytestcon" />
       <password value="mytestcon" />

       <jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
         <driverClassName value="oracle.jdbc.OracleDriver"/>
      <maxActive value="10"/>
       <maxIdle value="0"/>
   </connect>
</config>

*The error log is also pasted below.*

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

  at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
  at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
  at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
  at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
  at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
  at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
  at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.<init>(GeoServerTablePanel.java:442)
  at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:188)
  at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:82)
  at
org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:95)
  at
org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:92)
  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:94)
  at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
  at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
  at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
  at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
  at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
  at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
  at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
  at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
  at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
  at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
  at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
  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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
  at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
  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:275)
  at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
  at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
  at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  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:73)
  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:47)
  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:298)
  at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
  at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
  at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
  at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
  at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
  at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
  at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
  ... 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
'sri1'
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader 'sri1'

Any suggestions on how to resolve this issue...

Many thanks in advance,
Hari.

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

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

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

Harikumar_Reddy · May 26, 2011, 11:19am

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar using maven. We are starting this process today/tomorrow. He has sent a document and listed your name (Geotools support) under Acknowledgements section in the document.

The results of georaster plugin (they named it as georaster plugin) includes the given below advantages as per document (as per my understanding).

users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)
It has less number of configuration parameters when compared with existing georaster XML config file.
It will automatically mosaic surrounding georasters.
The plugin doesn’t have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com…>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is dbaskar@anonymised.com…

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

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

Steve_Way · May 26, 2011, 11:34am

Hi Hari,

I have to warn you there are quite a few issues with this plugin.

I started work on improving this but had to scrap as came across too many issues, noteably:

If you run a soak test of requests against raster layers, eventually TEMP tablespace will be full and no more requests can happen until server restart
Does not support 1 bit images
Several bugs where also noted – connections / resultsets and statements being left open etc.
Performance is also an issue

I have worked with Christian also on Oracle Georaster, and we took another approach, one where you can use native SQL to export the image, but this will have a limitation on 64mb per tile, or you can use the native oracle libraries which does not have a limit per tile and also has great performance.

This works with your use case of retrieving tiles from the DB and mosaicking them within the imagemosaic-jdbc module. It has been tested with Oracle 10g, not 11g however.

Contact me if you want any further information.

Christian – Did you manage to catch up with Simone regarding how we progress with this?

Regards,

Steve

···

users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)
It has less number of configuration parameters when compared with existing georaster XML config file.
It will automatically mosaic surrounding georasters.
The plugin doesn’t have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@…1968…> wrote:

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is dbaskar@…3217…

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@…1968…> wrote:

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@…1968…> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

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

Christian_Mueller · May 26, 2011, 11:45am

Baskar uses this feature, anybody can write his access logic for special db layouts and plug it in

http://docs.geotools.org/latest/userguide/library/coverage/jdbc/customized.html

Let me know about your results

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar
using maven. We are starting this process today/tomorrow. He has sent a
document and listed your name (Geotools support) under Acknowledgements
section in the document.

The results of georaster plugin (they named it as georaster plugin) includes
the given below advantages as per document (as per my understanding).

   1. users can configure more than one georasters in a single XML file
   (more than one means, it can be 100 or more also)
   2. It has less number of configuration parameters when compared with
   existing georaster XML config file.
   3. It will automatically mosaic surrounding georasters.
   4. The plugin doesn't have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it
can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind
Geoserver's
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib
folder
and downloaded and copied again. Restarted our server. It worked. There
was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we
were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license
issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on
geoserver
repository soon, once they will complete all the tests. The contact
email-id
is *dbaskar@anonymised.com*

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special

module. They do not use the tiling feature of Oracle GeoRaster and split
the image into multiple records. Not sure if this works for any kind of
image.

Cheers
Christian

Regards,

Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure
goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn't expect that again i will struggle for the same problem...

I have made chages to the
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with
windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log
file.

Cheers

Thanks,

Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size...and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map
api's
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users
tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this
idea.

Could not list layers for this store, an error occurred retrieving
them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters <coverageName name="SAT"/>
Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
  <coverageName name="SAT"/>
  <coordsys name="EPSG:4326"/>
  
  <scaleop interpolation="1"/>
  <spatialExtension name="georaster"/>
  <mapping>
      <masterTable name="GEOR_SAT1" >
          <geoRasterAttribute name="GEORASTER"/>
          <coverageNameAttribute name="ID"/>
      </masterTable>
  </mapping>
  <connect>
      
      <dstype value="DBCP"/>


      <username value="mytestcon" />
      <password value="mytestcon" />

      <jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb"
/>
        <driverClassName value="oracle.jdbc.OracleDriver"/>
     <maxActive value="10"/>
      <maxIdle value="0"/>
  </connect>
</config>

*The error log is also pasted below.*

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.<init>(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:82)
at

org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
... 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
'sri1'
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader 'sri1'

Any suggestions on how to resolve this issue...

Many thanks in advance,
Hari.

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

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

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

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

Christian_Mueller · May 26, 2011, 11:52am

Simone and me agreed on the following. I will have a deeper look at Simones work in the weekend. I hope to find a path to merge the jdbc stuff into Simones module without breaking deployed installations.

My motivation is the following:
First, I want to reduce my job as a "tile fetcher" from various db systems. Simone and Danielle have by far more skills in image processing. Second, I want you to maintain the Georaster stuff since I have no customer working with it.

Cheers
Christian

Quoting Steve Way <Steve.Way@anonymised.com>:

Hi Hari,

I have to warn you there are quite a few issues with this plugin.

I started work on improving this but had to scrap as came across too many issues, noteably:

1) If you run a soak test of requests against raster layers, eventually TEMP tablespace will be full and no more requests can happen until server restart

2) Does not support 1 bit images

3) Several bugs where also noted – connections / resultsets and statements being left open etc.

4) Performance is also an issue

I have worked with Christian also on Oracle Georaster, and we took another approach, one where you can use native SQL to export the image, but this will have a limitation on 64mb per tile, or you can use the native oracle libraries which does not have a limit per tile and also has great performance.

This works with your use case of retrieving tiles from the DB and mosaicking them within the imagemosaic-jdbc module. It has been tested with Oracle 10g, not 11g however.

Contact me if you want any further information.

Christian – Did you manage to catch up with Simone regarding how we progress with this?

Regards,
Steve

From: Harikumar Reddy [mailto:harik.gis@anonymised.com]
Sent: 26 May 2011 12:19
To: christian.mueller@anonymised.com
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar using maven. We are starting this process today/tomorrow. He has sent a document and listed your name (Geotools support) under Acknowledgements section in the document.

The results of georaster plugin (they named it as georaster plugin) includes the given below advantages as per document (as per my understanding).

1. users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)
2. It has less number of configuration parameters when compared with existing georaster XML config file.
3. It will automatically mosaic surrounding georasters.
4. The plugin doesn't have any dependency on other licensed jars.
We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>> wrote:
Quoting Harikumar Reddy <harik.gis@anonymised.com<mailto:harik.gis@anonymised.com>>:
Hi Christian,
Thankyou for immediate support, may be this is the reason behind Geoserver's
a BIG success as one of the best web map servers today.
Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is *dbaskar@anonymised.com<mailto:dbaskar@anonymised.com>*

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja
Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>> wrote:
Quoting Harikumar Reddy <harik.gis@anonymised.com<mailto:harik.gis@anonymised.com>>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn't expect that again i will struggle for the same problem...

I have made chages to the
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>> wrote:

Hi, I am the developer.
Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global-->GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com<mailto:harik.gis@anonymised.com>>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size...and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api's
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters <coverageName name="SAT"/> Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<config version="1.0">
  <coverageName name="SAT"/>
  <coordsys name="EPSG:4326"/>
  
  <scaleop interpolation="1"/>
  <spatialExtension name="georaster"/>
  <mapping>
      <masterTable name="GEOR_SAT1" >
          <geoRasterAttribute name="GEORASTER"/>
          <coverageNameAttribute name="ID"/>
      </masterTable>
  </mapping>
  <connect>
      
      <dstype value="DBCP"/>


      <username value="mytestcon" />
      <password value="mytestcon" />

      <jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
        <driverClassName value="oracle.jdbc.OracleDriver"/>
     <maxActive value="10"/>
      <maxIdle value="0"/>
  </connect>
</config>

*The error log is also pasted below.*

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.<init>(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.<init>(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.<init>(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
... 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
'sri1'
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader 'sri1'

Any suggestions on how to resolve this issue...

Many thanks in advance,
Hari.

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

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

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

________________________________
DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@anonymised.com and delete the original message.

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

Harikumar_Reddy · May 26, 2011, 3:07pm

Hi Steve,

Thanks for information update.

I have experienced the problems except 1 bit image support, with existing Georaster plugin. Mainly problem with temp table space full and server restart problem gets high priority. We are restarting geoserver most of the times (at least once in two days).

I will keep in mind this issues and proceed while configuring georasters. Any improvements are planned for this ImageMosaicJDBC plugin?

Regards,
Hari.

On Thu, May 26, 2011 at 5:04 PM, Steve Way <Steve.Way@anonymised.com> wrote:

Hi Hari,

I have to warn you there are quite a few issues with this plugin.

I started work on improving this but had to scrap as came across too many issues, noteably:

If you run a soak test of requests against raster layers, eventually TEMP tablespace will be full and no more requests can happen until server restart

Does not support 1 bit images

Several bugs where also noted – connections / resultsets and statements being left open etc.

Performance is also an issue

I have worked with Christian also on Oracle Georaster, and we took another approach, one where you can use native SQL to export the image, but this will have a limitation on 64mb per tile, or you can use the native oracle libraries which does not have a limit per tile and also has great performance.

This works with your use case of retrieving tiles from the DB and mosaicking them within the imagemosaic-jdbc module. It has been tested with Oracle 10g, not 11g however.

Contact me if you want any further information.

Christian – Did you manage to catch up with Simone regarding how we progress with this?

Regards,

Steve

From: Harikumar Reddy [mailto:harik.gis@anonymised.com]
Sent: 26 May 2011 12:19
To: christian.mueller@anonymised.com
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar using maven. We are starting this process today/tomorrow. He has sent a document and listed your name (Geotools support) under Acknowledgements section in the document.

The results of georaster plugin (they named it as georaster plugin) includes the given below advantages as per document (as per my understanding).

users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)

It has less number of configuration parameters when compared with existing georaster XML config file.

It will automatically mosaic surrounding georasters.

The plugin doesn’t have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@anonymised.com8…> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com.84…>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is dbaskar@anonymised.com…

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

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

DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@anonymised.com and delete the original message.

Steve_Way · May 26, 2011, 3:13pm

Yeah sure – I have a plugin which is pretty much ready to go but Christian and Simone have some integration work to do before we release it.

I can send it to you on an informal basis and you can let me know how you get on?

From: Harikumar Reddy [mailto:harik.gis@…84…]
Sent: 26 May 2011 16:07
To: Steve Way
Cc: christian.mueller@…1968…; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Steve,

Thanks for information update.

I have experienced the problems except 1 bit image support, with existing Georaster plugin. Mainly problem with temp table space full and server restart problem gets high priority. We are restarting geoserver most of the times (at least once in two days).

I will keep in mind this issues and proceed while configuring georasters. Any improvements are planned for this ImageMosaicJDBC plugin?

Regards,
Hari.

On Thu, May 26, 2011 at 5:04 PM, Steve Way <Steve.Way@…3551…> wrote:

Hi Hari,

I have to warn you there are quite a few issues with this plugin.

I started work on improving this but had to scrap as came across too many issues, noteably:

If you run a soak test of requests against raster layers, eventually TEMP tablespace will be full and no more requests can happen until server restart
Does not support 1 bit images
Several bugs where also noted – connections / resultsets and statements being left open etc.
Performance is also an issue

I have worked with Christian also on Oracle Georaster, and we took another approach, one where you can use native SQL to export the image, but this will have a limitation on 64mb per tile, or you can use the native oracle libraries which does not have a limit per tile and also has great performance.

This works with your use case of retrieving tiles from the DB and mosaicking them within the imagemosaic-jdbc module. It has been tested with Oracle 10g, not 11g however.

Contact me if you want any further information.

Christian – Did you manage to catch up with Simone regarding how we progress with this?

Regards,

Steve

From: Harikumar Reddy [mailto:harik.gis@…84…]
Sent: 26 May 2011 12:19
To: christian.mueller@…1968…
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar using maven. We are starting this process today/tomorrow. He has sent a document and listed your name (Geotools support) under Acknowledgements section in the document.

The results of georaster plugin (they named it as georaster plugin) includes the given below advantages as per document (as per my understanding).

users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)
It has less number of configuration parameters when compared with existing georaster XML config file.
It will automatically mosaic surrounding georasters.
The plugin doesn’t have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@…1968…> wrote:

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is dbaskar@…3217…

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@…1968…> wrote:

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@…1968…> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@…84…>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

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

DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@…3551… and delete the original message.

Harikumar_Reddy · May 27, 2011, 2:59am

Hi Steve,

Please send me if an improved plugin is available and no licensing issues (AFAIK, Internet map servers in raster configuration & interactions side, there is uncertainty, but technology is evolving with great speed).

I will also test and provide my feedback.

Thanks,
Hari.

On Thu, May 26, 2011 at 8:43 PM, Steve Way <Steve.Way@anonymised.com> wrote:

Yeah sure – I have a plugin which is pretty much ready to go but Christian and Simone have some integration work to do before we release it.

I can send it to you on an informal basis and you can let me know how you get on?

From: Harikumar Reddy [mailto:harik.gis@anonymised.com]
Sent: 26 May 2011 16:07
To: Steve Way
Cc: christian.mueller@anonymised.com; geoserver-users@lists.sourceforge.net

Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Steve,

Thanks for information update.

I have experienced the problems except 1 bit image support, with existing Georaster plugin. Mainly problem with temp table space full and server restart problem gets high priority. We are restarting geoserver most of the times (at least once in two days).

I will keep in mind this issues and proceed while configuring georasters. Any improvements are planned for this ImageMosaicJDBC plugin?

Regards,
Hari.

On Thu, May 26, 2011 at 5:04 PM, Steve Way <Steve.Way@anonymised.com> wrote:

Hi Hari,

I have to warn you there are quite a few issues with this plugin.

I started work on improving this but had to scrap as came across too many issues, noteably:

If you run a soak test of requests against raster layers, eventually TEMP tablespace will be full and no more requests can happen until server restart

Does not support 1 bit images

Several bugs where also noted – connections / resultsets and statements being left open etc.

Performance is also an issue

I have worked with Christian also on Oracle Georaster, and we took another approach, one where you can use native SQL to export the image, but this will have a limitation on 64mb per tile, or you can use the native oracle libraries which does not have a limit per tile and also has great performance.

This works with your use case of retrieving tiles from the DB and mosaicking them within the imagemosaic-jdbc module. It has been tested with Oracle 10g, not 11g however.

Contact me if you want any further information.

Christian – Did you manage to catch up with Simone regarding how we progress with this?

Regards,

Steve

From: Harikumar Reddy [mailto:harik.gis@anonymised.com]
Sent: 26 May 2011 12:19
To: christian.mueller@anonymised.com
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Georaster & ImagemosaicJDBC jars problem

Hi Christian,

Baskar has sent java code files, which have to be build and converted to jar using maven. We are starting this process today/tomorrow. He has sent a document and listed your name (Geotools support) under Acknowledgements section in the document.

The results of georaster plugin (they named it as georaster plugin) includes the given below advantages as per document (as per my understanding).

users can configure more than one georasters in a single XML file (more than one means, it can be 100 or more also)

It has less number of configuration parameters when compared with existing georaster XML config file.

It will automatically mosaic surrounding georasters.

The plugin doesn’t have any dependency on other licensed jars.

We will also check and update feedback to Baskar about this plugin, so it can be useful to the GS community.

Regards,
Hari.

On Thu, May 26, 2011 at 3:46 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thankyou for immediate support, may be this is the reason behind Geoserver’s
a BIG success as one of the best web map servers today.

Thanks

I have removed the imagemosaicjdbc jar from the geoserver WEB-INF/lib folder
and downloaded and copied again. Restarted our server. It worked. There was
no change in the jar files version from already implemented system and the
current new implementation system.

Just wondering, no idea what could be happened.

java path & other configurations verified and looks ok. Last time it was
solved due to copy of previous version imagemosaicjdbc (2.0.1 & 2.0.3) &
other jar files of oracle jdbc (you have specified yesterday too, there is
an additional ojdbc14_g.jar also copied). It was same implementation we were
already having and working fine.

The oracle jar files have to be installed manually, this is due to license issues.

I found one imteresting document for ImagemosaicJDBC and a team is working
(CoreLogic, Banglore, India) on extending the existing ImagemosaicJDBC
version developed by your team. You can find the details in the given url.
They have described that the latest jar may be checked in soon on geoserver
repository soon, once they will complete all the tests. The contact email-id
is dbaskar@anonymised.com

http://www.google.co.in/url?sa=t&source=web&cd=10&ved=0CFcQFjAJ&url=http%3A%2F%2Fwww.geospatialworldforum.org%2F2011%2Fproceeding%2Fpdf%2FBaskar.pps&rct=j&q=geoserver%20configuration%20of%20oracle%20georaster&ei=B3PbTbHYCIntrQe55tnoDg&usg=AFQjCNHN96C65xDsFxGwvn8ViCz2czDEoQ&cad=rja

Ahh, Baskar, I can remember I supported him to develop his special module. They do not use the tiling feature of Oracle GeoRaster and split the image into multiple records. Not sure if this works for any kind of image.

Cheers
Christian

Regards,
Hari.

On Wed, May 25, 2011 at 8:35 PM, <christian.mueller@anonymised.com> wrote:

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi Christian,

Thanks for reply. I got help from you before also, to configure goeraster
with geoserver and succeeded (problem is i am thinking of consistency).
But
i didn’t expect that again i will struggle for the same problem…

I have made chages to the
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties as per your
advise.
i will send the required log of geotools asap after admin is available.

Can you please give little guidance or suitable URL on how to set/check
the
jdbc driver classpath on linux, as i am into pure gis domain with windows
os
and dont have much linux knowledge.

The oracle jar file has to be in
GEOSERVER_INSTALLATION_DER/WEB-INF/lib

Another possibility is to put the jar in
lib/ext of your Java installation.

echo $JAVA_HOME

will show you the directory.

At least, you start your java virtual machine with the option
-verbose:class , you will see the class loading sequence in the log file.

Cheers

Thanks,
Hari.

On Wed, May 25, 2011 at 3:01 PM, <christian.mueller@anonymised.com> wrote:

Hi, I am the developer.

Your config file looks good and yes, the coverageName goes into the id
column of your record.
Unfortunately, the stack trace does not show the original exception.

To be sure, the jdbc Driver is in your class path ?

You can configure the log level in geoserver GUI.
Settings->Global–>GEOTOOLS_DEVELOPER_LOGGING.properties

After a restart, you should see a lot more messages in the log file,
please
zip and send to me.

Quoting Harikumar Reddy <harik.gis@anonymised.com>:

Hi GS users,

I am verymuch happy with Geoserver performance for vector layers., but
for
georaster it is really a problematic configaration.

Is there any possibility to configure oracle georasters which are
occupying
bulk disk size…and possibility to access with openlayers api or any
other
api (or anyone is using oracle mapviewer and using any oracle map api’s
for
only georaster). ImagemosaicJDBC is giving problems and no consistent
solutions to resolve this issues. one of the main problem i am facing
now
is
given below.

Can anyone faced similar problem with ImagemosaicJDBC for Geoserver
2.0.2
version. We have successfully installed and working on test server
environment, but when tried to do the same implementation in the
deployment
environment., ImagemosaicJDBC is giving errors as given below.

are they really format errors or jar mismatch errors. AFAIK,
ImagemosaicJDBC
plugin has to be more consistent like vector layers configarations in
GS.
This error i have encountered before also and with help of GS users tech
forum and checking one by one jar files, successfully configured
(copying
2.0.1 & 2.0.3 imagemosaicjdbc jar files in 2.0.2 version has solved my
problems). This time, tried very much, but not succeeded with this idea.

Could not list layers for this store, an error occurred retrieving them:
Unable to acquire a reader for this coverage with format:
ImageMosaicJDBC

The os used is linux centos, with Geoserver 2.0.2 (imagemosaicJDBC
version
is also taken correct version)

can anyone explain the parameters Normally
this
value is filled in the ID coloumn record (please correct me if i am
wrong).

Both environments are same when compared. Why it is giving problem.

The configaration file parameters i am giving below for reference.

===================================================
<?xml version="1.0" encoding="UTF-8" standalone="no"?> =======================================================
The error log is also pasted below.

25 May 00:53:32 INFO [geoserver.web] - Getting list of coverages for
saved
store file:coverages/geortest/sri1.xml
java.lang.RuntimeException: Could not list layers for this store, an
error
occurred retrieving them: Unable to acquire a reader for this coverage
with
format: ImageMosaicJDBC

at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:92)
at

org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:162)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:108)
at

org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:177)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.first(GeoServerTablePanel.java:477)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.updateMatched(GeoServerTablePanel.java:467)
at

org.geoserver.web.wicket.GeoServerTablePanel$Pager.(GeoServerTablePanel.java:442)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:188)
at

org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:82)
at
org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:95)
at
org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:92)
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:94)
at

org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128)
at

org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
at

org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
at

org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
at

org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at

org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at

org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
at

org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
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.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
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:73)
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:47)
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:298)
at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:409)
at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unable to acquire a reader for this
coverage
with format: ImageMosaicJDBC
at

org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:577)
at

org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:72)
… 83 more

25 May 00:53:32 INFO [geoserver.catalog] - Disposing grid coverage
reader
‘sri1’
25 May 00:53:32 WARN [geoserver.catalog] - Error occured disposing
coverage
reader ‘sri1’

Any suggestions on how to resolve this issue…

Many thanks in advance,
Hari.

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

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

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

DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@anonymised.com and delete the original message.

[Geoserver-users] Georaster & ImagemosaicJDBC jars problem

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
           <driverClassName value="oracle.jdbc.OracleDriver"/>
        <maxActive value="10"/>
         <maxIdle value="0"/>
     </connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
          <driverClassName value="oracle.jdbc.OracleDriver"/>
       <maxActive value="10"/>
        <maxIdle value="0"/>
    </connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
         <driverClassName value="oracle.jdbc.OracleDriver"/>
      <maxActive value="10"/>
       <maxIdle value="0"/>
   </connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb"
/>
        <driverClassName value="oracle.jdbc.OracleDriver"/>
     <maxActive value="10"/>
      <maxIdle value="0"/>
  </connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
        <driverClassName value="oracle.jdbc.OracleDriver"/>
     <maxActive value="10"/>
      <maxIdle value="0"/>
  </connect>
</config>

[Geoserver-users] Georaster & ImagemosaicJDBC jars problem

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" /> <driverClassName value="oracle.jdbc.OracleDriver"/> <maxActive value="10"/> <maxIdle value="0"/> </connect> </config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" /> <driverClassName value="oracle.jdbc.OracleDriver"/> <maxActive value="10"/> <maxIdle value="0"/> </connect> </config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" /> <driverClassName value="oracle.jdbc.OracleDriver"/> <maxActive value="10"/> <maxIdle value="0"/> </connect> </config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" /> <driverClassName value="oracle.jdbc.OracleDriver"/> <maxActive value="10"/> <maxIdle value="0"/> </connect> </config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" /> <driverClassName value="oracle.jdbc.OracleDriver"/> <maxActive value="10"/> <maxIdle value="0"/> </connect> </config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
<driverClassName value="oracle.jdbc.OracleDriver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
<driverClassName value="oracle.jdbc.OracleDriver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
<driverClassName value="oracle.jdbc.OracleDriver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb"
/>
<driverClassName value="oracle.jdbc.OracleDriver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>
</config>

<jdbcUrl value="jdbc:oracle:thin:@10.0.0.1:1521:test.localdb" />
<driverClassName value="oracle.jdbc.OracleDriver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>
</config>