I'm getting a strange error when trying to connect to an Oracle DB using
JNDI inside a JBOSS-EAP server.
2013-11-25 13:33:54,046 DEBUG [org.geotools.factory] - Factory
implementations for category UnWrapper:
org.geoserver.data.jdbc.SpringUnWrapper
org.geotools.data.jdbc.datasource.DBCPUnWrapper
org.geotools.jdbc.LifecycleConnectionUnWrapper
2013-11-25 13:33:54,054 WARN [org.geotools.jdbc] - Failed to use
SDO_TUNE.EXTENT_OF, falling back on envelope aggregation
java.sql.SQLException: Could not obtain native oracle connection for class
org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
at
org.geotools.data.oracle.OracleDialect.unwrapConnection(OracleDialect.java:565)
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.getOptimizedBounds(OracleDialect.java:754)
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1141)
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)
at
org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:189)
The rest of the log is attached.
Interestingly the connection works fine if I use the normal Oracle
Datastore (with the same jar - which is an updated version for 11.2 rather
than the one that ships with GeoServer).
Has anyone seen anything similar or got any hints as to how I can go about
debugging further?
cheers
Ian
--
Ian Turton
2013-11-25 13:33:40,139 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2013-11-25 13:33:40,258 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-25 13:33:43,785 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2013-11-25 13:33:43,902 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-25 13:33:43,902 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2013-11-25 13:33:43,905 DEBUG [org.geotools.jdbc] - Getting information about
primary keys of ALL_SCOTLAND
2013-11-25 13:33:43,911 DEBUG [org.geotools.jdbc] - Getting information about
unique indexes of ALL_SCOTLAND
2013-11-25 13:33:43,959 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata:
SELECT OBJECTID FROM OSMMTEST.ALL_SCOTLAND WHERE 0=1
2013-11-25 13:33:43,963 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-25 13:33:43,964 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2013-11-25 13:33:43,982 DEBUG [org.geotools.jdbc] - Check user can access user
metadata views: SELECT * FROM MDSYS.USER_SDO_INDEX_METADATA WHERE ROWNUM < 2
2013-11-25 13:33:43,985 DEBUG [org.geotools.jdbc] - Check user can access user
metadata views: SELECT * FROM MDSYS.USER_SDO_GEOM_METADATA WHERE ROWNUM < 2
2013-11-25 13:33:43,985 DEBUG [org.geotools.jdbc] - SELECT * FROM
MDSYS.USER_SDO_GEOM_METADATA WHERE ROWNUM < 2
2013-11-25 13:33:43,986 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT
META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'ALL_SCOTLAND'
AND REPLACE(meta.sdo_column_name, '"') = 'GEOM'
AND INFO.TABLE_OWNER = 'OSMMTEST'
2013-11-25 13:33:43,988 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT
META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'ALL_SCOTLAND'
AND REPLACE(meta.sdo_column_name, '"') = 'GEOM'
AND INFO.TABLE_OWNER = 'OSMMTEST' AND META.SDO_INDEX_OWNER = 'OSMMTEST'
2013-11-25 13:33:43,991 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID
FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='ALL_SCOTLAND' AND
COLUMN_NAME='GEOM'
2013-11-25 13:33:43,994 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-25 13:33:48,552 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2013-11-25 13:33:48,556 DEBUG [org.geotools.jdbc] - Getting the full extent of
the table using optimized search: select
SDO_TUNE.EXTENT_OF('OSMMTEST.ALL_SCOTLAND', 'GEOM') FROM DUAL
2013-11-25 13:33:54,046 DEBUG [org.geotools.factory] - Factory implementations
for category UnWrapper:
org.geoserver.data.jdbc.SpringUnWrapper
org.geotools.data.jdbc.datasource.DBCPUnWrapper
org.geotools.jdbc.LifecycleConnectionUnWrapper
2013-11-25 13:33:54,054 WARN [org.geotools.jdbc] - Failed to use
SDO_TUNE.EXTENT_OF, falling back on envelope aggregation
java.sql.SQLException: Could not obtain native oracle connection for class
org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
at
org.geotools.data.oracle.OracleDialect.unwrapConnection(OracleDialect.java:565)
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.getOptimizedBounds(OracleDialect.java:754)
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1141)
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)
at
org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:189)
at
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:427)
at
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:364)
at
org.geotools.data.SimpleFeatureSourceBridge.getBounds(SimpleFeatureSourceBridge.java:49)
at
org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatureSource.java:591)
at
org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:561)
at
org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:543)
at
org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResourceConfig.java:118)
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:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
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:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
at
org.geoserver.flow.controller.IpBlacklistFilter.doFilter(IpBlacklistFilter.java:87)
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:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
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.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
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.GeoServerUserNamePasswordAuthenticationFilter.doFilter(GeoServerUserNamePasswordAuthenticationFilter.java:115)
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.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:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:43)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at
org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:67)
at
org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:48)
at
org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134)
at
org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99)
at org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92)
at org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64)
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
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:372)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931)
at java.lang.Thread.run(Thread.java:662)
2013-11-25 13:33:54,062 DEBUG [org.geotools.jdbc] - SELECT SDO_AGGR_MBR(GEOM)
FROM OSMMTEST.ALL_SCOTLAND
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
