Bom eu faço a conexão através de acesso a configuração de arquivos e metódos para conectar aos bancos, e não
Linha da classe que faz a conexão com o banco.
Connection conn = DBAUtil.getConnection(fileName, driver, connectString, user, password);
Onde :
fileName : classes12.jar
driver : oracle.jdbc.driver.OracleDriver
connectString : jdbc:oracle:thin:@[ip]:[porta]/[instancia]
user : teste
password : teste
Classe DBAUtil que gera a conexão com o Banco de Dados.
public class FarolDBAUtil {
private static LinkedHashMap<String, Driver> loadedDrivers = new LinkedHashMap<String, Driver>();
public static Connection getConnection(String fileName, String driver, String connectionString, String username, String password) throws MalformedURLException, InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
Connection con = null;
if(driver != null) {
driver = driver.trim();
}
Properties props = new Properties();
props.put("user", username);
props.put("password", password);
Driver d = loadJdbcDriver(driver, fileName);
con = d.connect(connectionString, props);
return con;
}
private static Driver loadJdbcDriver(String driver, String fileName) throws InstantiationException, IllegalAccessException, ClassNotFoundException, MalformedURLException {
Driver d;
if (loadedDrivers.containsKey(driver)) {
d = (Driver) loadedDrivers.get(driver);
} else {
File file = new File(Constants.HOME + Constants.LIB + "/" + fileName);
URL[] urls;
urls = new URL[] { file.toURL() };
ClassLoader loader = URLClassLoader.newInstance(urls);
d = (Driver) Class.forName(driver, true, loader).newInstance();
loadedDrivers.put(driver, d);
}
return d;
}
public static Properties loadSchedulerConfig() {
log.debug("Carregando Configurações do Quartz");
Properties properties = new Properties();
try {
File file = new File(Constants.HOME + Constants.CONFIG_DIR + Constants.QUARTZ_CONFIG);
FileInputStream fileInputStream = new FileInputStream(file);
properties.load(fileInputStream);
} catch (IOException exception) {
}
return properties;
}
Depois de passar por todo esse processo o objeto conn vem nulo, não conseguindo se conectar com o Banco.