Amigos estou desenvolvendo um projeto da seguinte forma
.JSP, .JS E .HTM -> CAMADA DE APRESENTAÇÃO
.JAVA ->CAMADA DE NEGÓCIO E DE PERSISTÊNCIA
SGBD -> ORACLE 9i
Quando tento me conectar com o Banco(que está num servidor da rede) ele me retorna esse erro:
Erro ao tentar se conectar ao banco
java.sql.SQLException: Exceção de E/S: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at sigecon.OperacaoBanco.abrirConexao(OperacaoBanco.java:43)
at sigecon.ManipulaContratoInicial.getCadastroContratoInicial(ManipulaContratoInicial.java:27)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:314)
at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190)
at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:932)
at org.apache.jsp.pri.pri_005fCadastroContratoInicial_jsp._jspService(org.apache.jsp.pri.pri_005fCadastroContratoInicial_jsp:115)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
O meu .java de conexão é esse:
private static final String driverName = "oracle.jdbc.OracleDriver";
public static Connection conexao = null;
public static Statement statement = null;
private static String serverName = "servdesenv:1521:sigecon";
private static String usuario = "sigecon";
private static String senha = "sigeconsql";
private static String url = "jdbc:oracle:thin:@" + serverName;
public static void abrirConexao() throws SQLException, Exception {
try {
if (conexao == null) {
Class.forName(driverName);
// DriverManager.registerDriver(new OracleDriver());
conexao = DriverManager.getConnection(url, usuario, senha);
statement = conexao.createStatement();
System.out.println("Conexão aberta!");
} else {
System.out.println("Conexão já se encontra aberta!");
new SQLException("Erro SQL ao criar a conexao");
}
}
catch (SQLException e1) {
System.out.println("Erro ao tentar se conectar ao banco");
e1.printStackTrace();
} catch (Exception e2) {
System.out.println("Erro Geral ao abrir conexao");
e2.printStackTrace();
}
}
Bem, quem puder me ajudar, agradeço desde já e até mais!