public class Conn implements Serializable {



	private static ComboPooledDataSource cpds;

	protected transient Connection conn;



	public void connect() {

		conn = Conn.getConnection();

	}



	public static Connection getConnection() {

		Connection ret = null;

		if (cpds == null) {

  		        createPool();

		}

		try {

			ret = cpds.getConnection();

		} catch (SQLException e) {

			// <skip> some code

		}

		return retorno;

	}



	public void disconnect() {

		try {

			conn.close();

		} catch (SQLException e) {

			// <skip> some code

		}

	}



	private static void createPool() {

		cpds = new ComboPooledDataSource();

  	        cpds.setDriverClass("com.mysql.jdbc.Driver");

		cpds.setJdbcUrl("jdbc:mysql://host/db?user=..?password=...");

		cpds.setUser("user");

		cpds.setPassword("pwd");

		cpds.setAcquireIncrement(2);

		cpds.setMaxConnectionAge(60 * 60 * 3);

		cpds.setMaxIdleTimeExcessConnections(60 * 10);

		cpds.setPreferredTestQuery("SELECT 1");

		cpds.setIdleConnectionTestPeriod(60 * 10);

		cpds.setMinPoolSize(3);

		cpds.setMaxPoolSize(30);

	}



}