proj.zoie.dataprovider.jdbc.OracleJDBCConnectionFactory Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zoie-core Show documentation

zoie core library

There is a newer version: 3.3.0

package proj.zoie.dataprovider.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import proj.zoie.dataprovider.jdbc.JDBCConnectionFactory;

public class OracleJDBCConnectionFactory implements JDBCConnectionFactory
{
  private static final String ORACLE_JDBC_URL_PREFIX="jdbc:oracle:thin:@";
  private static final String ORACLE_DRIVER_NAME = "oracle.jdbc.OracleDriver";

  private final String _username;
  private final String _password;
  private final String _url;
  

  private Connection _conn = null;

  public OracleJDBCConnectionFactory(String hostname, int port, String SID, String username, String password)
  {
    this(hostname +":" +port + ":" + SID, username, password);
  }

  public OracleJDBCConnectionFactory(String database, String username, String password)
  {
    _url = ORACLE_JDBC_URL_PREFIX + database;
    _username = username;
    _password = password;
  }

  public synchronized Connection getConnection() throws SQLException
  {
	if (_conn==null){
	    try
	    {
	      Class.forName(ORACLE_DRIVER_NAME);
	    } catch (Exception e)
	    {
	      throw new SQLException("unable to load driver: "+e.getMessage());
	    }
        _conn = DriverManager.getConnection (_url, _username, _password);
	}
	return _conn;
  }
  
  public synchronized void showndown() throws SQLException{
		if (_conn!=null){
			_conn.close();
		}
	}
}