Menu
▾
▴
Re: [Geoserver-users] Geoserver-users Digest, Vol 79, Issue 80
|
From: Subodh P. <sub...@pr...> - 2012-12-27 12:00:03
|
Hi I am from Bangalore, India. I am relatively new to Geoserver. I want o know, how can I develop my own customized Tools Kind Regards, Subodh Murari Patrikar GIS Software Engineer T: +91 80 4245 5555/23192209 (Ext - 514) F:+91 80 4245 5556/23192210 E: sub...@pr... www.prdcinfotech.com -----Original Message----- From: geo...@li... [mailto:geo...@li...] Sent: Thursday, December 27, 2012 17:03 To: geo...@li... Subject: Geoserver-users Digest, Vol 79, Issue 80 Send Geoserver-users mailing list submissions to geo...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/geoserver-users or, via email, send a message with subject or body 'help' to geo...@li... You can reach the person managing the list at geo...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of Geoserver-users digest..." Today's Topics: 1. Re: Oracle Doesn't work (Andrea Aime) 2. Re: Oracle Doesn't work (Jonathan Moules) ---------------------------------------------------------------------- Message: 1 Date: Thu, 27 Dec 2012 12:17:01 +0100 From: Andrea Aime <and...@ge...> Subject: Re: [Geoserver-users] Oracle Doesn't work To: Jonathan Moules <jon...@wa...> Cc: geo...@li... Message-ID: <CA+nxMTt1Vz4UdQ9b5hroD9sEh9w64BzNYTy=tud...@ma...> Content-Type: text/plain; charset="iso-8859-1" On Thu, Dec 27, 2012 at 12:13 PM, Jonathan Moules < jon...@wa...> wrote: > Hi Andrea, > I hadn't set a schema. I guess this means I'll need to add a new layer for > each schema, even though its the same user reading it. > This does resolve the reading issue, however the MBR issue ( > http://jira.codehaus.org/browse/GEOS-5517) is still evident even after > specifying a schema (note: there are only about 50,000 features in this > particular dataset). > Eh, I've never seen that error despite having worked with GeoServer and Oracle several times, so I can only make some guess... maybe your table in Oracle does not have a spatial index? That is required for any spatial operation to work, which I guess including computing the BBOX If you switch the logging level to "GeoTools developer logging" the log will become quite verbose, but it will also include the SQL staments that GeoServer is sending to the database. Cheers Andrea -- == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Thu, 27 Dec 2012 11:32:25 +0000 From: Jonathan Moules <jon...@wa...> Subject: Re: [Geoserver-users] Oracle Doesn't work To: Andrea Aime <and...@ge...> Cc: geo...@li... Message-ID: <CAA-xNcX+qbZ=Mia...@ma...> Content-Type: text/plain; charset="iso-8859-1" Definitely have a Spatial Index. I'd know it if I didn't. ;-) (but have just double checked - its there). This issue seems to be a little more nuanced than I previously thought. Now when I click "Compute from data" Geoserver web interface doesn't appear to respond at all. Not even the error. I get a little flower-loading icon in the top right and that's it. After a minute or two the new bounding co-ordinates are loaded, but for all intents and purposes it actually appears that GeoServer has crashed during that period. The console is still showing the permissions error, but also that the query worked: 27 Dec 11:20:15 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 27 Dec 11:20:15 WARN [org.geotools.jdbc] - Failed to use SDO_TUNE.EXTENT_OF, falling back on envelope aggregation java.sql.SQLException: ORA-00942: table or view does not exist ORA-06512: at "MDSYS.SDO_TUNE", line 817 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.geotools.data.oracle.OracleDialect.getOptimizedBounds(OracleDialect.java:732) at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1128) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:426) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:363) at org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatureSource.java:591) at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:555) at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:537) at org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResourceConfig.java:115) at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:68) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:143) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436) at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484) at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:160) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:159) 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:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093) at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74) at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:53) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:97) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) 27 Dec 11:20:15 DEBUG [org.geotools.jdbc] - SELECT SDO_AGGR_MBR(SDO_GEOMETRY) FROM OSMM.OS_MM2_CONWY_TOPOGRAPHIC_AREA 27 Dec 11:21:38 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION I ran the same query in Oracle SQL Developer and it took 2 minutes! That's a very long time to get an MBR for just 50,000 features. I dread to think what'll happen when I point it at my ~15million feature table! I think GeoServer should use the MDSYS.USER_SDO_GEOM_METADATA entry by default - that's what its there for after all. Cheers, Jonathan On 27 December 2012 11:17, Andrea Aime <and...@ge...> wrote: > On Thu, Dec 27, 2012 at 12:13 PM, Jonathan Moules < > jon...@wa...> wrote: > >> Hi Andrea, >> I hadn't set a schema. I guess this means I'll need to add a new layer >> for each schema, even though its the same user reading it. >> This does resolve the reading issue, however the MBR issue ( >> http://jira.codehaus.org/browse/GEOS-5517) is still evident even after >> specifying a schema (note: there are only about 50,000 features in this >> particular dataset). >> > > Eh, I've never seen that error despite having worked with GeoServer and > Oracle several times, so I can only make some guess... > maybe your table in Oracle does not have a spatial index? > That is required for any spatial operation to work, which I guess > including computing the BBOX > > If you switch the logging level to "GeoTools developer logging" the log > will become quite verbose, but it will > also include the SQL staments that GeoServer is sending to the database. > > Cheers > Andrea > > -- > == > Our support, Your Success! Visit http://opensdi.geo-solutions.it for more > information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 339 8844549 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > ------------------------------------------------------- > This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 ------------------------------ _______________________________________________ Geoserver-users mailing list Geo...@li... https://lists.sourceforge.net/lists/listinfo/geoserver-users End of Geoserver-users Digest, Vol 79, Issue 80 *********************************************** ****************************************************************************************************************** Please consider the environment before printing this email. Do it only if it is absolutely necessary. DISCLAIMER: The contents of this email including attachment(s), if any, are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you have received this mail in error, please notify the sender immediately and destroy all copies of this message and any attachment(s).Computer viruses or other malware can be transmitted by email. Therefore, please check this email and any attachment(s) for the presence of viruses, malware, etc. The PRDC accepts no liability whatsoever for any damage - whether direct or consequential - caused by any virus, malware, etc. transmitted by this email. ****************************************************************************************************************** ****************************************************************************************************************** Please consider the environment before printing this email. Do it only if it is absolutely necessary. DISCLAIMER: The contents of this email including attachment(s), if any, are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you have received this mail in error, please notify the sender immediately and destroy all copies of this message and any attachment(s).Computer viruses or other malware can be transmitted by email. Therefore, please check this email and any attachment(s) for the presence of viruses, malware, etc. The PRDC accepts no liability whatsoever for any damage - whether direct or consequential - caused by any virus, malware, etc. transmitted by this email. ****************************************************************************************************************** |