Re: connection pool to postgresql

[Alexander Wallace]

Here is what i have in server.xml in the context of my app

                <Resource name="jdbc/postgresql" auth="Container"
type="javax.sql.DataSource"/> 
                    <ResourceParams name="jdbc/postgresql">
                      <parameter>
                            <name>factory</name>
                           
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                      </parameter>
                      <parameter>
                            <name>driverClassName</name>
                            <value>org.postgresql.Driver</value>
                      </parameter>
                      <parameter>
                            <name>url</name>
                           
<value>jdbc:postgresql://IP.GOES.HERE.XX/db_name_goes_here</value>
                      </parameter>
                      <parameter>
                            <name>username</name>
                            <value>TheUserNameGoesHere</value>
                      </parameter>
                      <parameter>
                            <name>password</name>
                            <value>ThePasswordGoesHere</value>
                      </parameter>
                      <parameter>
                            <name>maxActive</name>
                            <value>50</value>
                      </parameter>
                      <parameter>
                            <name>maxIdle</name>
                            <value>10</value>
                      </parameter>
                      <parameter>
                            <name>maxWait</name>
                            <value>-1</value>
                      </parameter>
                    </ResourceParams> 

then my web.xml

  <resource-ref>
    <description>postgreSQL Datasource</description>
    <res-ref-name>jdbc/postgresql</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

The following class provides connections from the pool:

import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

/**
 * Class Pool provides pooled connections from JNDI data source.
 * 
 */
public class Pool {

    /**
     * Method Pool creates a database pool
     */
    public Pool() {
        System.err.println("Pool Initialized");
    }

    /**
     * Method getConnection.
     * @return Connection 
     */
    public static Connection getConnection() {

        Connection cn = null;

        try {
            Context ctx = new InitialContext();
            DataSource ds =
(DataSource)ctx.lookup("java:comp/env/jdbc/postgresql");
            if (ds != null) { 
                cn = ds.getConnection();
            }
        }
        catch (Exception e) {
            e.printStackTrace(System.err);
        }

        return cn;
    }
}

And to get a connection and use it, just declare like:

Connection cn = Pool.getConnection();

And that's it!

On Fri, 2002-12-06 at 16:11, Dionisio Ruiz de Zarate wrote:
> Hello can anybody help me to configure one connection pool to postgresql
> from tomcat?
> and how can i use fron one java class?
> thanks
> 
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> 



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>