Java में Connection Pooling

public class Main {
	public static void main(String[] args) {
		// Opening a connection involves a handshake, auth, and session setup -- expensive to repeat
		System.out.println("Pooling reuses already-open connections instead of opening new ones every time");
	}
}

Login to try C/C++/Java/PHP code in the editor

import java.util.*;
public class Main {
	static class FakeConnection {}
	public static void main(String[] args) {
		Queue<FakeConnection> pool = new LinkedList<>();
		for (int i = 0; i < 5; i++) pool.add(new FakeConnection()); // fixed number, pre-opened at startup
		System.out.println("Pool size: " + pool.size());
	}
}

Login to try C/C++/Java/PHP code in the editor

import java.util.*;
public class Main {
	static class FakeConnection {}
	public static void main(String[] args) {
		Queue<FakeConnection> pool = new LinkedList<>(List.of(new FakeConnection(), new FakeConnection()));
		FakeConnection borrowed = pool.poll(); // borrowed, not opened fresh
		System.out.println("Borrowed, remaining: " + pool.size());
		pool.offer(borrowed); // returned instead of closed
		System.out.println("Returned, remaining: " + pool.size());
	}
}

Login to try C/C++/Java/PHP code in the editor

import java.util.concurrent.*;
public class Main {
	static class FakeConnection {}
	public static void main(String[] args) {
		BlockingQueue<FakeConnection> pool = new LinkedBlockingQueue<>();
		pool.add(new FakeConnection()); // thread-safe container, no manual synchronization needed
		System.out.println("Thread-safe pool size: " + pool.size());
	}
}

Login to try C/C++/Java/PHP code in the editor

public class Main {
	public static void main(String[] args) {
		// In production: HikariDataSource dataSource = new HikariDataSource(config);
		System.out.println("Production apps use HikariCP or Apache DBCP instead of a hand-rolled pool");
	}
}

Login to try C/C++/Java/PHP code in the editor