Skip to main content

skip to main content

developerWorks  >  Java technology  >

Connection pools

Dive into connection pooling with J2EE

developerWorks

Return to article


EJB accesses a database resource using JDBC 1.0, without connection pooling

...
  import java.sql.*;
  import javax.sql.*;
  ...
  public class AccountBean implements EntityBean {
  ...
  public Collection ejbFindByLastName(String lName) {
     try {
           String dbdriver =  new InitialContext().lookup("java:comp/env/DBDRIVER").toString();
           Class.forName(dbdriver).newInstance();
           Connection conn = null;
           conn = DriverManager.getConnection("java:comp/env/DBURL", "userID", "password");
           ...
           conn.close();
        }
  ...
  }
  

Return to article