connection pooling

[Vijayalakshmi Karthikeyan]

Hi all,
Can we create a connection pooling for multiple database. If possible Can you please guide me with sample code..

[Jan Cumps]

Yes, this is possible. You can create a connection pool for each of your databases.
When you need a connection for a particular database, you ask one from the corresponding pool.
When you later close that connection, it will be automatically given back to the right pool.

[Kunal Lakhani]

1st you need to configure Tomcat 5.5 with admin console. After configuring that Create a helper class. Use JNDI to look up the connection. Create a static method to get connection(the return type for which is Connection)

I am providing you some part of the code

public class DbUtil {
	private static DataSource dataSource;

	static {

		try {
			Context initCtx = new InitialContext();

			Context envCtx = (Context)initCtx.lookup("java:comp/env");

			dataSource = (DataSource)envCtx.lookup("jdbc/myDS");

		} catch(Exception e) {
			e.printStackTrace();
		}
	}

	public static Connection getConnection() throws SQLException {
		Connection connection = dataSource.getConnection();
		return connection;
	}

Whenever you want to create a connection( logical connection), just call Classname.getConnection. (in my case DbUtil.getConnection)