/*************************************************************
 * @file:   RawDataReader.java
 * @author: Bansi Kotecha
 * @notes:  For accessing a Postgresql Database Server 
 * @data:   March 2003
 *************************************************************/
import java.sql.Connection;
import java.sql.DriverManager;

abstract public class RawDataReader {
    
    public static String dbHost = "slinky.cs.nyu.edu";
    public static String dbPort = "5432";
    // public static String dbUser = "visclass";		// alt: "tiger"
    public static String dbUser = "tiger";		// alt: "tiger"
    // public static String dbPassword = "visclass";	// alt: "tiger"
    public static String dbPassword = "tiger";	// alt: "tiger"
    // public static String database = "visdata";	// alt: "rawdata"
    public static String database = "rawdata";		// alt: "rawdata"

    public Connection con = null;

    public Connection establishConnection() {
	String url = "";
	//Connection con = null;
	try {
	    url = "jdbc:postgresql://" + dbHost + ":" + dbPort + "/" + database;
	    Class.forName("org.postgresql.Driver");
	    con = DriverManager.getConnection(url, dbUser, dbPassword);
	con.setAutoCommit(false);
	} catch (Exception e){
	    e.printStackTrace();
	}
       	return con;
    }


    // You should call this commit() method after you are finished
    //	processing your database: 

    public void commit() {
	try {
		con.commit();
	} catch (Exception e) {
		e.printStackTrace();
	}
    }
}