import java.sql.*;
import javax.servlet.http.*;

// Implements `HttpSessionBindingListener' to ensure connection is
// closed promptly when session ends.

public class DBSession implements HttpSessionBindingListener, DBConstants {

    static {
        System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");
    }

    DBSession() throws SQLException {
        conn = DriverManager.getConnection(url, username, password);
        stat = conn.createStatement();
    }

    public void valueBound(HttpSessionBindingEvent evt) {}

    public void valueUnbound(HttpSessionBindingEvent evt) {
        System.out.println("Closing Oracle connection...") ;  // debug

        try {
           conn.close() ;
        } catch (SQLException e) {}  // Not much to be done about it.
    }

    public Connection conn ;
    public Statement stat ;
}