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 *[email protected]*
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, <[email protected]> wrote:
> Quoting Harikumar Reddy <[email protected]>:
>
> 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, <[email protected]> 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 <[email protected]>:
>>>
>>> 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"/>
>>>> <!-- interpolation 1 = nearest neighbour, 2 = bipolar, 3 = bicubic
>>>> -->
>>>> <scaleop interpolation="1"/>
>>>> <spatialExtension name="georaster"/>
>>>> <mapping>
>>>> <masterTable name="GEOR_SAT1" >
>>>> <geoRasterAttribute name="GEORASTER"/>
>>>> <coverageNameAttribute name="ID"/>
>>>> </masterTable>
>>>> </mapping>
>>>> <connect>
>>>> <!-- value DBCP or JNDI -->
>>>> <dstype value="DBCP"/>
>>>> <!-- <jndiReferenceName value=""/> -->
>>>>
>>>> <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.
>
>
>
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
