Pool connection

[rsrinivasan]

Hi all,

Im implementing pool connection in my web application. And im using dbcp.jar1.1 for pool connection. I do not know how to find free connection in the pool. If anyone know how to find this, reply me.

Thanks,

[JosAH]

The dbcp pool takes care of that: when you ask it for a Connection it searches its
pool and returns you an available one if there is one. Otherwise it opens a new
Connection for you.

kind regards,

Jos

[BigDaddyLH]

Post the code you are currently using to get a connection.

[rsrinivasan]

Post the code you are currently using to get a connection.

Thanks for reply..

This is my code to get the Pool connection..

private Connection getPoolConnection()
    {
            try
        {
            Context initctxt = new InitialContext();
            Context envctxt = (Context)initctxt.lookup("java:comp/env");
            DataSource dsrc = (DataSource)envctxt.lookup("jdbc/tri");
            dbConnection = dsrc.getConnection();
        }
        catch(NamingException ne)
        {
            ne.printStackTrace();
                    }
        catch(SQLException sqle)
        {
            sqle.printStackTrace();
        }
        return dbConnection;
    }

This is the configuration in "server.xml" file

<Environment name="maxExemptions" type="java.lang.Integer" value="15"/>
          <Parameter name="context.param.name" value="context.param.value" override="false"/>
          <Resource name="jdbc/tri" auth="Container" type="javax.sql.DataSource"/>

I want to know how much of connections are free at a time.

[BigDaddyLH]

I want to know how much of connections are free at a time.

Why do you need to know that?