[Geoserver-users] Oracle connections

Jonathan_Moules2 · December 13, 2012, 6:04pm

Hi All,
I’ve installed the Oracle extension and it seems to be working well. Possibly too well because I have the following three:

Oracle NG - Oracle Database
Oracle NG (JNDI) - Oracle Database (JNDI)
Oracle NG (OCI) - Oracle Database (OCI)

I can find documentation for the first here:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

which includes references to (and screenshot of) JNDI here: http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

But nothing on the OCI one.

What are the differences between these? Just the connection type? I can’t seem to find anything about the third one at all (I guess its using the Oracle OCI client I have installed). Do any of them have any particular advantages (i.e. speed?)
Thanks,
Jonathan

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.

cmaul · December 13, 2012, 11:03pm

Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven't used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed... yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian

-----
____________________________

Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Jonathan_Moules2 · December 14, 2012, 10:39am

Hi Christian,
Thanks for the detailed information. I’m more inclined to picking between the OCI and the NG one’s myself. I have the NG one set up and working but the OCI one doesn’t work.

I get this error in the console when I hit “save” for a new OCI Oracle store:

109562 [btpool0-2] ERROR org.mortbay.log - Nested in org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3139)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3135)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:420)
at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:46)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1652)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:833)
at org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:300)
at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:114)
at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:366)
at org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
at org.geoserver.web.data.store.DataAccessNewPage.onSaveDataStore(DataAccessNewPage.java:91)
at org.geoserver.web.data.store.AbstractDataAccessPage$1.onSubmit(AbstractDataAccessPage.java:162)
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)
109687 [btpool0-2] ERROR org.mortbay.log - /geoserver/web/
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3139)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3135)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:420)
at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:46)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1652)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:833)
at org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:300)
at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:114)
at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:366)
at org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
at org.geoserver.web.data.store.DataAccessNewPage.onSaveDataStore(DataAccessNewPage.java:91)
at org.geoserver.web.data.store.AbstractDataAccessPage$1.onSubmit(AbstractDataAccessPage.java:162)
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)

I guess something is missing, but there’s no documentation on the OCI connection as far as I can tell, so its not clear what I need to do.
Anyone have any suggestions?
Thanks,
Jonathan

On 13 December 2012 23:03, cmaul <Christian.Maul@anonymised.com> wrote:

Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven’t used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed… yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian

Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

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

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.

Paolo_Crosato · December 14, 2012, 11:20am

Hi, it would seem you are missing ojdbc from oracle in your java library path, or the binaries like libocijdbc11.so. I had the same issue with other spring apps relying on oracle. It could be that ojdbc5/6 is missing, or it can’t find the oci layer because the libraries are not in the directories the linker is parsing. I would first check if the ojdb6.jar is in the tomcat/lib directory, if not get it from oracle . For oci to work you will need the oci libraries too, you can get the instant client here if you haven’t got it already: This provides the jars too, so you can skip the ojdbc donwload. Now all the pieces should be there, to make them work together you have to set ORACLE_HOME to the client path, like this: ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to the linker search path, either by LD_LIBRARY_PATH which works but is not recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again. If you are on windows setting ORACLE_HOME and adding the executables and the libs to the PATH var should be enough. In summary what you need are the jars and the oci (libocci, libocijdbc1X.so) libs, when you have them it’s just about having them talk together. Hope it helps, getting Oracle to work like you want it to is always troublesome Regards, Paolo

···

Il 14/12/2012 11:39, Jonathan Moules ha scritto:

Hi Christian,
Thanks for the detailed information. I’m more inclined to picking between the OCI and the NG one’s myself. I have the NG one set up and working but the OCI one doesn’t work.

I get this error in the console when I hit “save” for a new OCI Oracle store:

109562 [btpool0-2] ERROR org.mortbay.log - Nested in org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

On 13 December 2012 23:03, cmaul <Christian.Maul@anonymised.com> wrote:

Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven’t used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed… yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian

Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

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

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.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
[http://p.sf.net/sfu/logmein_12329d2d](http://p.sf.net/sfu/logmein_12329d2d)
_______________________________________________
Geoserver-users mailing list
[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)

-- 
Paolo Crosato
Software engineer/Custom Solutions
e-mail: [paolo.crosato@anonymised.com](mailto:paolo.crosato@anonymised.com)
Office phone: +3904221722825

UBIEST S.p.A.
........................................................................................
[www.ubiest.com](http://www.ubiest.com)
Via E. Reginato, 85/H - 31100 Treviso- ITALY Tel [+39] 0422 210 194 - Fax [+39] 0422 210 270 ........................................................................................
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Jonathan_Moules2 · December 14, 2012, 3:35pm

Hi Paulo,
Thanks for that. I do have the relevant files already installed, but don’t have an ORACLE_HOME set because other software breaks if I set it (I have both 32bit and 64 oracle installs, so if I set Oracle Home to one, then software for the other breaks).

Do you know if the OCI driver offers a performance advantage over the plain Oracle driver?

Thanks again,
Jonathan

On 14 December 2012 11:20, Paolo Crosato <paolo.crosato@anonymised.com> wrote:

Il 14/12/2012 11:39, Jonathan Moules ha scritto:

Hi Christian,
Thanks for the detailed information. I’m more inclined to picking between the OCI and the NG one’s myself. I have the NG one set up and working but the OCI one doesn’t work.

I get this error in the console when I hit “save” for a new OCI Oracle store:

109562 [btpool0-2] ERROR org.mortbay.log - Nested in org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

Hi,
it would seem you are missing ojdbc from oracle in your java library path, or the binaries like libocijdbc11.so. I had the same issue with other spring apps relying on oracle. It could be that ojdbc5/6 is missing, or it can’t find the oci layer because the libraries are not in the directories the linker is parsing.
I would first check if the ojdb6.jar is in the tomcat/lib directory, if not get it from oracle http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html .
For oci to work you will need the oci libraries too, you can get the instant client here if you haven’t got it already: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
This provides the jars too, so you can skip the ojdbc donwload.

Now all the pieces should be there, to make them work together you have to set ORACLE_HOME to the client path, like this: ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to the linker search path, either by LD_LIBRARY_PATH which works but is not recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.

If you are on windows setting ORACLE_HOME and adding the executables and the libs to the PATH var should be enough.

In summary what you need are the jars and the oci (libocci, libocijdbc1X.so) libs, when you have them it’s just about having them talk together.

Hope it helps, getting Oracle to work like you want it to is always troublesome

Regards,

Paolo
On 13 December 2012 23:03, cmaul <Christian.Maul@anonymised.com> wrote:

Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven’t used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed… yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian

Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

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

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.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
[http://p.sf.net/sfu/logmein_12329d2d](http://p.sf.net/sfu/logmein_12329d2d)
________________
_________________________
______
Geoserver-users mailing list
[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)
-- 
Paolo Crosato
Software engineer/Custom Solutions
e-mail: [paolo.crosato@anonymised.com](mailto:paolo.crosato@anonymised.com)Office phone: +3904221722825

UBIEST S.p.A.
........................................................................................
[www.ubiest.com](http://www.ubiest.com)Via E. Reginato, 85/H - 31100 Treviso- ITALY Tel [+39] 0422 210 194 - Fax [+39] 0422 210 270 ........................................................................................
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

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

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.

[Geoserver-users] Oracle connections

Telephone: +61-3-8636 2325 Telefax: +61-3-8636 2813

Telephone: +61-3-8636 2325 Telefax: +61-3-8636 2813

Telephone: +61-3-8636 2325 Telefax: +61-3-8636 2813

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813