SCTDBInterface.java

/*
 * SCTDBInterface.java
 *
 * Created on 08 September 2003, 12:31
 */

package ProdDatabase;
import java.sql.*;
public class SCTDBInterface implements DBAccessInfo {
    private static SCTDBInterface instance = new SCTDBInterface();
    public Connection connection;
    private String DBusername = "SCTREAD";
    
    private SCTDBInterface() {
        Refresh();
    }
    
    public static SCTDBInterface getInstance() {
        return instance;
    }

    public void Refresh() {
        try {
             if(connection==null) {
               System.out.println("Trying to connect to production database ...");
               // Load Oracle driver
               DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
               DriverManager.setLoginTimeout(10); // give it 10 seconds max before timing out
               connection = DriverManager.getConnection (connectionName, DBusername, DBpassword);
               System.out.println("Connection to SCT database established.");
               }
       }catch(Exception e){System.out.println("Failed to connect to database: "+e.toString());}

    }
    public boolean isConnected() {
       return (connection!=null);
       }
}

---