How does JDBC work in Java? Explain DriverManager, connection pooling (HikariCP), transactions, and isolation levels.

Answer preview

JDBC is Java's standard database API. Connection pooling (HikariCP, Tomcat Pool) reuses TCP connections and authenticated sessions — creating a new connection per request is prohibitively expensive.…