On Tue, Mar 8, 2011 at 8:48 AM, Astrid Emde <[email protected]>wrote:
> Hello,
>
> in GeoServer 2.0.x we have three ways to connect to an Oracle datasource:
>
> Oracle NG
> Oracle NG (OCI)
> Oracle NG (JNDI)
>
> Which connection would you recommend? Which is the fastest, what are the
> advantages?
>
The basic one is probably the one you want to use unless you have specific
extra needs.
The OCI one uses the OCI drivers, which are half java and half native code,
requires the
full Oracle client to be installed and configured on the server running
GeoServer.
Some say it's faster, some say it's not. Not sure, haven't tried it myself
JNDI allows you to configure a single connection pool for the whole Tomcat,
that
is nice if you are running multiple GeoServers all against the same
database,
or if you need to configure multiple stores, each hitting a separate
database schema.
It's also the only solution that I've tried allowing one to connect to an
Oracle RAC
(cluster of databases), and also good if you need so setup some other
obscure
connection property.
Configuring the JNDI pool is not nearly as easy as the "basic" approach
though,
we have a basic tutorial here:
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
Hope this helps
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
