Hi there,

Manpreet this side , ihave a problem regarding connection pooling,the code given below throws the java.sql.SQLException.But create a pool with size 10 if i print it with pool.getPoolSize();.I am using the apache's snaq package.
If you can solve this problem please help me.I shall be thankfull to you.

			

			

			

			

			import snaq.db.ConnectionPool;
			

			

			

			import java.sql.Connection;
			

			

			

			

			try
			

			

			

			{
			

			

			

			Connection con=null;
			

			

			

			ConnectionPool pool=new ConnectionPool("firstPool",10,30,1800000,url,"user","password");
			

			

			

			

			

			long timeout=200000;
			

			

			

			con=pool.getConnection();
			

			

			

			//con=pool.getConnection(timeout);
			

			

			

			}catch(SQLEXCEPTION sq)
			

			

			

			{
			

			

			

			System.out.println("SSSSSSSSSS=="+sq);
			

			

			

			}