MainC3P0.java

import java.sql.Connection;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class MainC3P0 {

  /**
	 * @param args
	 */
	public static void main(String[] args) throws Exception {
		ComboPooledDataSource cpds = new ComboPooledDataSource();
		cpds.setDriverClass("com.mysql.jdbc.Driver");
		cpds.setJdbcUrl("jdbc:mysql://localhost/lportal");
		cpds.setUser("root");
		cpds.setPassword("root");

		cpds.setUnreturnedConnectionTimeout(8);
		cpds.setDebugUnreturnedConnectionStackTraces(true);

		Connection con = cpds.getConnection();

		Thread.sleep(11 * 1000);

		con.close();

		System.out.println("done");

	}

}