GeoServer

Document usage of JNDI Connection pools in GeoServer

Details

  • Type: Task Task
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 1.7.4
  • Fix Version/s: 1.7.5, 2.0-beta2
  • Component/s: Documentation
  • Labels:
    None
  • Number of attachments :
    0

Description

Christian Mueller just added support for JNDI based connection pools in GeoServer. A tutorial on how to setup one for postgis in tomcat would be nice

Issue Links

depends upon

Improvement - An improvement or enhancement to an existing feature or task. GEOS-3131 Expand the set of connection unwrappers for Oracle JNDI usage

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
relates to

New Feature - A new feature of the product, which has yet to be developed. GEOT-2509 Adding jndi support to all jdbc-ng modules

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Andrea Aime added a comment -

The short story, so that I don't forget it, is:

  • add the jdbc driver into tomcat/lib
  • modify conf/context.xml and add 
    <Resource name="jdbc/pglocal" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="geoserver" password="whatever" driverClassName="org.postgresql.Driver"
               url="jdbc:postgresql://localhost/postgis"/>

    inside the Context element

  • modify GeoServer's web.xml and append at the end:
    <resource-ref>
    <description>postgreSQL Datasource example</description>
    <res-ref-name>jdbc/pglocal</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
    </resource-ref>
  • refer the jndi connection pool in the geoserver UI using: "java:comp/env/jdbc/pglocal"

See also:
http://www.mbaworld.com/docs/jndi-resources-howto.html
http://www.mbaworld.com/docs/jndi-datasource-examples-howto.html

Show
Andrea Aime added a comment - The short story, so that I don't forget it, is: add the jdbc driver into tomcat/lib modify conf/context.xml and add <Resource name= "jdbc/pglocal" auth= "Container" type= "javax.sql.DataSource" maxActive= "100" maxIdle= "30" maxWait= "10000" username= "geoserver" password= "whatever" driverClassName= "org.postgresql.Driver" url= "jdbc:postgresql://localhost/postgis" /> inside the Context element modify GeoServer's web.xml and append at the end: <resource-ref> <description>postgreSQL Datasource example</description> <res-ref-name>jdbc/pglocal</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> refer the jndi connection pool in the geoserver UI using: "java:comp/env/jdbc/pglocal" See also: http://www.mbaworld.com/docs/jndi-resources-howto.html http://www.mbaworld.com/docs/jndi-datasource-examples-howto.html
Hide
Permalink
Andrea Aime added a comment -

Upping priority. This feature will be certainly part of the announcement so we should be sure to point people to some docs about it (a tutorial showing how to setup things in Tomcat should do).

Show
Andrea Aime added a comment - Upping priority. This feature will be certainly part of the announcement so we should be sure to point people to some docs about it (a tutorial showing how to setup things in Tomcat should do).
Hide
Permalink
Andrea Aime added a comment -

Guide committed:
http://docs.geoserver.org/1.7.x/user/data/jndi-connection-pools.html
http://docs.geoserver.org/1.7.x/user/tutorials/tomcat-jndi/tomcat-jndi.html

Feedback appreciated

Show
Andrea Aime added a comment - Guide committed: http://docs.geoserver.org/1.7.x/user/data/jndi-connection-pools.html http://docs.geoserver.org/1.7.x/user/tutorials/tomcat-jndi/tomcat-jndi.html Feedback appreciated
Hide
Permalink
Andrea Aime added a comment -

Fixed in 1.7.5

Show
Andrea Aime added a comment - Fixed in 1.7.5
Hide
Permalink
Christian Mueller added a comment -

Nice, int the case of questions about handling this for Websphere or DB2 on the user mailing list, i will do something similar.

Show
Christian Mueller added a comment - Nice, int the case of questions about handling this for Websphere or DB2 on the user mailing list, i will do something similar.

People

  • Assignee:
    Andrea Aime
    Reporter:
    Andrea Aime
Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: