[Geoserver-users] Issue with Geoserver 2.5 and Oracle SQL View layers

GeoServer GeoServer User
1

Dear all,

I’ve been working on SQL View layers based on Oracle NG datastore.

I’m currently testing similar layers with a Geoserver 2.5 instance, and i’m facing several issues (tests with Geoserver layer preview):

  • some features are not rendered in WMS for some zooming levels (i clarify that i’m using the default polygon style without any SLD zoom scale rule)
  • some features disappear by moving the map
  • GetFeatureInfo does not seem to work (empty output)

In the past, i was using Geoserver 2.2 for which it was working perfectly.

I’m wondering if;

  • any user is experimenting the same kind of problem with Oracle NG or other of DB datastore?
  • some hints could be provided to better track the source of this problem?
  • or if possibly a bug has been yet identified by developers?

Many thanks in advance for your help,

Emmanuel

btn_in_20x15.png

···

–
Emmanuel Blondel
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile

2

Hi Emmanuel,
the issue is overall new to me. Just to be sure, are you using 2.5.0 or 2.5.1?
It would be best if you tried the latter

Cheers
Andrea

btn_in_20x15.png

···

On Wed, Jun 11, 2014 at 6:04 PM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com> wrote:

Dear all,

I’ve been working on SQL View layers based on Oracle NG datastore.

I’m currently testing similar layers with a Geoserver 2.5 instance, and i’m facing several issues (tests with Geoserver layer preview):

  • some features are not rendered in WMS for some zooming levels (i clarify that i’m using the default polygon style without any SLD zoom scale rule)
  • some features disappear by moving the map
  • GetFeatureInfo does not seem to work (empty output)

In the past, i was using Geoserver 2.2 for which it was working perfectly.

I’m wondering if;

  • any user is experimenting the same kind of problem with Oracle NG or other of DB datastore?
  • some hints could be provided to better track the source of this problem?
  • or if possibly a bug has been yet identified by developers?

Many thanks in advance for your help,

Emmanuel

–
Emmanuel Blondel
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile

HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

==

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

3

I think I’ve seen this before using Oracle. I fixed it, but I can’t remember what did the trick! It might be something to do with the Loose BBOX setting - do you have this enabled?

btn_in_20x15.png

···

On Wed, Jun 11, 2014 at 9:04 AM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com> wrote:

Dear all,

I’ve been working on SQL View layers based on Oracle NG datastore.

I’m currently testing similar layers with a Geoserver 2.5 instance, and i’m facing several issues (tests with Geoserver layer preview):

  • some features are not rendered in WMS for some zooming levels (i clarify that i’m using the default polygon style without any SLD zoom scale rule)
  • some features disappear by moving the map
  • GetFeatureInfo does not seem to work (empty output)

In the past, i was using Geoserver 2.2 for which it was working perfectly.

I’m wondering if;

  • any user is experimenting the same kind of problem with Oracle NG or other of DB datastore?
  • some hints could be provided to better track the source of this problem?
  • or if possibly a bug has been yet identified by developers?

Many thanks in advance for your help,

Emmanuel

–
Emmanuel Blondel
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile

HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

4

It seems 2.5.0

Exact information is:

  * Version 2.5
  * Révision Git 8cf3edcf5f61db010f7ad3fcb4613e7c0eabeaff
  * Build Date 18-Mar-2014 16:08
  * Version de GeoTools 11.0 (rev fb9a2d3f88315d076523788cb8196ec89bb253f9)
  * Version GeoWebCache 1.5.1 (rev
    1.5.x/64246c20a4ada1c954b17d23b9447408d1c5432f)

Le 11/06/2014 18:20, Andrea Aime a écrit :

Hi Emmanuel,
the issue is overall new to me. Just to be sure, are you using 2.5.0 or 2.5.1?
It would be best if you tried the latter

Cheers
Andrea

On Wed, Jun 11, 2014 at 6:04 PM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com <mailto:emmanuel.blondel1@anonymised.com>> wrote:

    Dear all,

    I've been working on SQL View layers based on Oracle NG datastore.

    I'm currently testing similar layers with a Geoserver 2.5
    instance, and i'm facing several issues (tests with Geoserver
    layer preview):
    - some features are not rendered in WMS for some zooming levels (i
    clarify that i'm using the default polygon style without any SLD
    zoom scale rule)
    - some features disappear by moving the map
    - GetFeatureInfo does not seem to work (empty output)

    In the past, i was using Geoserver 2.2 for which it was working
    perfectly.

    I'm wondering if;
    - any user is experimenting the same kind of problem with Oracle
    NG or other of DB datastore?
    - some hints could be provided to better track the source of this
    problem?
    - or if possibly a bug has been yet identified by developers?

    Many thanks in advance for your help,

    Emmanuel

    -- *Emmanuel Blondel*
    GIS Consultant
    Engineer in Agronomy & Environment

    Geographic Information Systems
    in Agronomy - Environment - Fisheries
    Email: emmanuel.blondel1@anonymised.com
    <mailto:emmanuel.blondel1@anonymised.com> - Emmanuel.Blondel@anonymised.com
    <mailto:Emmanuel.Blondel@anonymised.com>
    View my LinkedIn profileView my LinkedIn profile
    <http://fr.linkedin.com/in/emmanuelblondel1&gt;

    ------------------------------------------------------------------------------
    HPCC Systems Open Source Big Data Platform from LexisNexis Risk
    Solutions
    Find What Matters Most in Your Big Data with HPCC Systems
    Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
    Leverages Graph Analysis for Fast Processing & Easy Data Exploration
    http://p.sf.net/sfu/hpccsystems
    _______________________________________________
    Geoserver-users mailing list
    Geoserver-users@lists.sourceforge.net
    <mailto:Geoserver-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geoserver-users

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

5

Andrea,

Maybe the information below can help?
I have enabled geotools logging in Geoserver, and after doing a layer preview wms request, this is what i get in the log:

2014-06-11 18:48:28,479 DEBUG [org.geotools.jdbc] - Failed to unwrap connection using java 6 facilities
java.lang.AbstractMethodError: org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.isWrapperFor(Ljava/lang/Class;)Z
     at org.geotools.data.oracle.OracleDialect.unwrapConnection(OracleDialect.java:557)
     at org.geotools.data.oracle.OracleDialect.readGeometry(OracleDialect.java:502)
     at org.geotools.data.oracle.OracleDialect.readGeometry(OracleDialect.java:492)
     at org.geotools.data.oracle.OracleDialect.decodeGeometryValue(OracleDialect.java:455)
     at org.geotools.jdbc.JDBCFeatureReader.next(JDBCFeatureReader.java:314)
     at org.geotools.jdbc.JDBCFeatureReader.next(JDBCFeatureReader.java:74)
     at org.geotools.data.store.ContentFeatureCollection$WrappingFeatureIterator.next(ContentFeatureCollection.java:145)
     at org.geotools.data.store.ContentFeatureCollection$WrappingFeatureIterator.next(ContentFeatureCollection.java:125)
     at org.geotools.feature.collection.BridgeIterator.next(BridgeIterator.java:31)
     at org.geotools.feature.collection.BridgeIterator.next(BridgeIterator.java:18)
     at org.geotools.renderer.lite.StreamingRenderer.drawPlain(StreamingRenderer.java:2516)
     at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:2066)
     at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:837)
     at org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:483)
     at org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:251)
     at org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:123)
     at org.geoserver.wms.GetMap.executeInternal(GetMap.java:509)
     at org.geoserver.wms.GetMap.run(GetMap.java:253)
     at org.geoserver.wms.GetMap.run(GetMap.java:124)
     at org.geoserver.wms.DefaultWebMapService.getMap(DefaultWebMapService.java:328)
     at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:483)
     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
     at org.geoserver.kml.WebMapServiceKmlInterceptor.invoke(WebMapServiceKmlInterceptor.java:34)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
     at org.geoserver.gwc.wms.CacheSeedingWebMapService.invoke(CacheSeedingWebMapService.java:61)
     at org.geoserver.gwc.wms.CacheSeedingWebMapService.invoke(CacheSeedingWebMapService.java:35)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
     at org.geoserver.gwc.wms.CachingWebMapService.invoke(CachingWebMapService.java:73)
     at org.geoserver.gwc.wms.CachingWebMapService.invoke(CachingWebMapService.java:54)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
     at org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:54)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
     at com.sun.proxy.$Proxy26.getMap(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:483)
     at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:774)
     at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:272)
     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.doGet(FrameworkServlet.java:778)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:301)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
     at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:70)
     at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:70)
     at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     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.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
     at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
     at org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:82)
     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.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:52)
     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:134)
     at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
     at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:43)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:74)
     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)
     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1017)
     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:652)
     at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1575)
     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1533)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)

Same log is mentioned in http://comments.gmane.org/gmane.comp.gis.geoserver.user/41561
Could this be related to the issues i've reported?

Another important note: the geoserver in question is deployed on Tomcat 8 / JDK 8. Any advice either if it is suitable for a geoserver 2.5.0 / 2.5.1?

(Many) Thanks in advance
Emmanuel

Le 11/06/2014 18:39, Emmanuel Blondel a écrit :

It seems 2.5.0

Exact information is:

  * Version 2.5
  * Révision Git 8cf3edcf5f61db010f7ad3fcb4613e7c0eabeaff
  * Build Date 18-Mar-2014 16:08
  * Version de GeoTools 11.0 (rev
    fb9a2d3f88315d076523788cb8196ec89bb253f9)
  * Version GeoWebCache 1.5.1 (rev
    1.5.x/64246c20a4ada1c954b17d23b9447408d1c5432f)

Le 11/06/2014 18:20, Andrea Aime a écrit :

Hi Emmanuel,
the issue is overall new to me. Just to be sure, are you using 2.5.0 or 2.5.1?
It would be best if you tried the latter

Cheers
Andrea

On Wed, Jun 11, 2014 at 6:04 PM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com <mailto:emmanuel.blondel1@anonymised.com>> wrote:

    Dear all,

    I've been working on SQL View layers based on Oracle NG datastore.

    I'm currently testing similar layers with a Geoserver 2.5
    instance, and i'm facing several issues (tests with Geoserver
    layer preview):
    - some features are not rendered in WMS for some zooming levels
    (i clarify that i'm using the default polygon style without any
    SLD zoom scale rule)
    - some features disappear by moving the map
    - GetFeatureInfo does not seem to work (empty output)

    In the past, i was using Geoserver 2.2 for which it was working
    perfectly.

    I'm wondering if;
    - any user is experimenting the same kind of problem with Oracle
    NG or other of DB datastore?
    - some hints could be provided to better track the source of this
    problem?
    - or if possibly a bug has been yet identified by developers?

    Many thanks in advance for your help,

    Emmanuel

    -- *Emmanuel Blondel*
    GIS Consultant
    Engineer in Agronomy & Environment

    Geographic Information Systems
    in Agronomy - Environment - Fisheries
    Email: emmanuel.blondel1@anonymised.com
    <mailto:emmanuel.blondel1@anonymised.com> - Emmanuel.Blondel@anonymised.com
    <mailto:Emmanuel.Blondel@anonymised.com>
    View my LinkedIn profileView my LinkedIn profile
    <http://fr.linkedin.com/in/emmanuelblondel1&gt;

    ------------------------------------------------------------------------------
    HPCC Systems Open Source Big Data Platform from LexisNexis Risk
    Solutions
    Find What Matters Most in Your Big Data with HPCC Systems
    Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
    Leverages Graph Analysis for Fast Processing & Easy Data Exploration
    http://p.sf.net/sfu/hpccsystems
    _______________________________________________
    Geoserver-users mailing list
    Geoserver-users@lists.sourceforge.net
    <mailto:Geoserver-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geoserver-users

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

--
*Emmanuel Blondel*
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile <http://fr.linkedin.com/in/emmanuelblondel1&gt;

btn_in_20x15.png

6

On Wed, Jun 11, 2014 at 6:59 PM, Emmanuel Blondel <
emmanuel.blondel1@anonymised.com> wrote:

Andrea,

Maybe the information below can help?
I have enabled geotools logging in Geoserver, and after doing a layer
preview wms request, this is what i get in the log:

2014-06-11 18:48:28,479 DEBUG [org.geotools.jdbc] - Failed to unwrap
connection using java 6 facilities

Normally this happens if you have the oracle driver both in GeoServer
web-inf/lib, and in the web container
shared libs (e.g., tomcat/lib).
Make sure you have it in a single place

Same log is mentioned in

http://comments.gmane.org/gmane.comp.gis.geoserver.user/41561
Could this be related to the issues i've reported?

Another important note: the geoserver in question is deployed on Tomcat 8
/ JDK 8. Any advice either if it is suitable for a geoserver 2.5.0 / 2.5.1?

You are totally on your own I'm afraid, JDK 8 is not supported, we just
moved to support JDK 7 on the
GeoServer dev series (will become 2.7.x in September). May work, may not.

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

7

Thanks for your prompt and valuable remarks,

I will liaise with colleagues that were recently in charge of deploying this new instance of geoserver:
- to make up your valuable comments about JDK support.
- to check the location of the oracle driver

Thanks again for your support

Cheers
Emmanuel

Le 11/06/2014 19:08, Andrea Aime a écrit :

On Wed, Jun 11, 2014 at 6:59 PM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com <mailto:emmanuel.blondel1@anonymised.com>> wrote:

    Andrea,

    Maybe the information below can help?
    I have enabled geotools logging in Geoserver, and after doing a
    layer preview wms request, this is what i get in the log:

    2014-06-11 18:48:28,479 DEBUG [org.geotools.jdbc] - Failed to
    unwrap connection using java 6 facilities

Normally this happens if you have the oracle driver both in GeoServer web-inf/lib, and in the web container
shared libs (e.g., tomcat/lib).
Make sure you have it in a single place

    Same log is mentioned in
    http://comments.gmane.org/gmane.comp.gis.geoserver.user/41561
    Could this be related to the issues i've reported?

    Another important note: the geoserver in question is deployed on
    Tomcat 8 / JDK 8. Any advice either if it is suitable for a
    geoserver 2.5.0 / 2.5.1?

You are totally on your own I'm afraid, JDK 8 is not supported, we just moved to support JDK 7 on the
GeoServer dev series (will become 2.7.x in September). May work, may not.

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

--
*Emmanuel Blondel*
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile <http://fr.linkedin.com/in/emmanuelblondel1&gt;

btn_in_20x15.png

8

Dear Andrea,

I come back to you on this issue, doing some local tests:
- I've set-up a geoserver 2.5.0 with Oracle datastore, based on JDK6 --> The rendering issues i've initially reported disappeared. However i've still the GetFeatureInfo not working.
- then, on your advices, i've moved to 2.5.1 --> the GetFeatureInfo now works perfectly

In conclusion, tests were successfull with the following Tomcat 6 / JDK 6 / Geoserver 2.5.1.
A last question: if existing, could you point me to a JIRA ticket about the GetFeatureInfo issue? Before moving 2.5.1, i've noticed that i had the same issue as reported here http://osgeo-org.1560.x6.nabble.com/Geoserver-puts-wrong-srid-to-the-spatial-filter-query-td5107048.html

Thanks in advance
Emmanuel

Le 11/06/2014 19:21, Emmanuel Blondel a écrit :

Thanks for your prompt and valuable remarks,

I will liaise with colleagues that were recently in charge of deploying this new instance of geoserver:
- to make up your valuable comments about JDK support.
- to check the location of the oracle driver

Thanks again for your support

Cheers
Emmanuel

Le 11/06/2014 19:08, Andrea Aime a écrit :

On Wed, Jun 11, 2014 at 6:59 PM, Emmanuel Blondel <emmanuel.blondel1@anonymised.com <mailto:emmanuel.blondel1@anonymised.com>> wrote:

    Andrea,

    Maybe the information below can help?
    I have enabled geotools logging in Geoserver, and after doing a
    layer preview wms request, this is what i get in the log:

    2014-06-11 18:48:28,479 DEBUG [org.geotools.jdbc] - Failed to
    unwrap connection using java 6 facilities

Normally this happens if you have the oracle driver both in GeoServer web-inf/lib, and in the web container
shared libs (e.g., tomcat/lib).
Make sure you have it in a single place

    Same log is mentioned in
    http://comments.gmane.org/gmane.comp.gis.geoserver.user/41561
    Could this be related to the issues i've reported?

    Another important note: the geoserver in question is deployed on
    Tomcat 8 / JDK 8. Any advice either if it is suitable for a
    geoserver 2.5.0 / 2.5.1?

You are totally on your own I'm afraid, JDK 8 is not supported, we just moved to support JDK 7 on the
GeoServer dev series (will become 2.7.x in September). May work, may not.

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

--
*Emmanuel Blondel*
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile <http://fr.linkedin.com/in/emmanuelblondel1&gt;

--
*Emmanuel Blondel*
GIS Consultant
Engineer in Agronomy & Environment

Geographic Information Systems
in Agronomy - Environment - Fisheries
Email: emmanuel.blondel1@anonymised.com - Emmanuel.Blondel@anonymised.com
View my LinkedIn profileView my LinkedIn profile <http://fr.linkedin.com/in/emmanuelblondel1&gt;

btn_in_20x15.png

9

On Thu, Jun 12, 2014 at 10:20 AM, Emmanuel Blondel <
emmanuel.blondel1@anonymised.com> wrote:

Dear Andrea,

I come back to you on this issue, doing some local tests:
- I've set-up a geoserver 2.5.0 with Oracle datastore, based on JDK6 -->
The rendering issues i've initially reported disappeared. However i've
still the GetFeatureInfo not working.
- then, on your advices, i've moved to 2.5.1 --> the GetFeatureInfo now
works perfectly

In conclusion, tests were successfull with the following Tomcat 6 / JDK 6
/ Geoserver 2.5.1.
A last question: if existing, could you point me to a JIRA ticket about
the GetFeatureInfo issue? Before moving 2.5.1, i've noticed that i had the
same issue as reported here
http://osgeo-org.1560.x6.nabble.com/Geoserver-puts-wrong-srid-to-the-spatial-filter-query-td5107048.html

Eh, I don't see a specific issue for that unfortunately, so the change be a
by-product of some other fix
Btw, Java 7 is safe to use on 2.5.x, we have several deployments of 2.5.x
and 2.4.x on that JDK, haven't found specific issues with it.

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------