/**
 * Database Global Broker Superclass.
 * @version 1.0.0 7/28/99
 * @author Marc A. Mnich
 */
package com.javaexchange.dbConnectionBroker;


import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import sun.misc.*;
import java.util.*;
import com.javaexchange.dbConnectionBroker.*;

/**
 * Creates a two-tier database connection pool that can be shared
 * by many servlets through inheritance.
 * @version 1.0.0 7/28/99
 * @author Marc A. Mnich
 */
public class HttpServletJXGB extends HttpServlet {

   protected static DbConnectionBroker myBroker;

    public void init (ServletConfig config) throws ServletException  {
       super.init(config);
 
	if(myBroker == null) { // Only created by first servlet to call
	    Properties p = new Properties();
	    try {
		p.load(new
		       FileInputStream("C:/work/jt/tomcat/webapps/jd/WEB-INF/classes/com/javaexchange/dbConnectionBroker/dbs.dat"));

		String dbDriver = (String) p.get("dbDriver");
		String dbServer = (String) p.get("dbServer");
		String dbLogin  = (String) p.get("dbLogin");
		String dbPassword = (String) p.get("dbPassword");
		int minConns   = Integer.parseInt((String) p.get("minConns"));
		int maxConns   = Integer.parseInt((String) p.get("maxConns"));
		String logFileString = (String) p.get("logFileString");
		double maxConnTime   =
		    (new Double((String)p.get("maxConnTime"))).doubleValue();
		
		
myBroker = new DbConnectionBroker(dbDriver,dbServer,dbLogin,dbPassword,
			     minConns,maxConns,logFileString,maxConnTime);

/*myBroker = new DbConnectionBroker("sun.jdbc.odbc.JdbcOdbcDriver",
                                         "jdbc:odbc:calendar",
                                        null,null,2,6,
                                        "c:/work/test.log",1.0);*/
System.out.println("hello" + myBroker.getSize());
	    }
	    catch (FileNotFoundException f) {}
	    catch (IOException e) {System.out.println("can't find file");}
	}
    
}
  Connection conn = null;


    /** Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
        //processRequest(request, response);
	conn = myBroker.getConnection();
        
       
    } 
     
}