package connections;import java.sql.*;public class ConnectionFactory {  private static ConnectionFactory ref = new ConnectionFactory();  private ConnectionFactory() {    try {      Class.forName("COM.cloudscape.core.JDBCDriver");      Class.forName("oracle.jdbc.driver.OracleDriver");    } catch (ClassNotFoundException e) {      System.out.println("ERROR: exception loading driver class");    }  }  public static Connection getConnection() throws SQLException  {    //String url = "jdbc:cloudscape:c:/wrox/database/Wrox4370.db";    String url = "jdbc:oracle:thin:@dbserver:1521:database";    return DriverManager.getConnection(url, "beg", "java");  }  public static void close(ResultSet rs)   {    try {      rs.close();    } catch (Exception ignored) {    }  }  public static void close(Statement stmt)   {    try {      stmt.close();    } catch (Exception ignored) {    }  }  public static void close(Connection conn)   {    try {      conn.close();    } catch (Exception ignored) {    }  }  }