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?