Loading ...
Sorry, an error occurred while loading the content.

Re: Res: [riojug] driver oracle

Expand Messages
  • João Paulo Linhares Gonçalves
    A partir desta m�quina que est� com o Tomcat vc consegue se conectar normalmente com o Oracle ? Procure compilar a classe de exemplo que vem com o driver JDBC
    Message 1 of 4 , Jul 27, 2005
    View Source
    • 0 Attachment
      A partir desta máquina que está com o Tomcat vc consegue se conectar
      normalmente com o Oracle ?

      Procure compilar a classe de exemplo que vem com o driver JDBC do
      Oracle, alterando a url para o seu caso e veja se consegue acessar o
      banco.


      Em 27/07/05, monte_sinai2001<monte_sinai2001@...> escreveu:
      >
      > Beleza,
      >
      > Coloquei no diretorio lib do tomcat e o erro que aparece Ã(c) esse abaixo.
      > E o que estou usando Ã(c):
      >
      > Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
      >
      > con =
      > DriverManager.getConnection("jdbc:oracle:thin:@10.123.33.30:1521:SMS_WAP_TST","ADM_TSP","senha");
      >
      > Aonde pode estar o problema?
      >
      >
      > javax.servlet.ServletException: Exceção de E/S: Connection
      > refused(DESCRIPTION=(TMP=)(VSNNUM=135296000)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
      > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
      > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
      > org.apache.jsp.conecta.Acesso_005fOracle_jsp._jspService(Acesso_005fOracle_jsp.java:79)
      > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      >
      > root cause
      >
      > java.sql.SQLException: Exceção de E/S: Connection
      > refused(DESCRIPTION=(TMP=)(VSNNUM=135296000)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
      > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
      > oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
      > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
      > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
      > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
      > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
      > java.sql.DriverManager.getConnection(DriverManager.java:512)
      > java.sql.DriverManager.getConnection(DriverManager.java:171)
      > org.apache.jsp.conecta.Acesso_005fOracle_jsp._jspService(Acesso_005fOracle_jsp.java:66)
      > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      >
      >
      >
      >
      >
      > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
      > Rio Java Users Group www.riojug.org
      > E-mail dos Moderadores riojug-owner@yahoogroups.com
      >
      > Patrocínio: Quality Software, SENAC-Rio CIT, Locaweb
      > Apoio: Java Magazine, SQL Magazine
      > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
      > Participe também das outras listas do RioJUG:
      > SCJP (groups.yahoo.com/group/scjp_riojug)
      > SCWCD (groups.yahoo.com/group/scwcd_riojug)
      > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
      > Yahoo! Groups Links
      >
      >
      >
      >
      >
      >
      >


      --
      João Paulo L.G.
      joaopaulolg@...
    • monte_sinai2001
      Esse erro dá quando rodo localmente. Pelo toad,sql+ acesso normalmente esse banco, com os mesmos dados que estou passando(banco,usuario e senha). ... abaixo.
      Message 2 of 4 , Jul 27, 2005
      View Source
      • 0 Attachment
        Esse erro dá quando rodo localmente. Pelo toad,sql+ acesso
        normalmente esse banco, com os mesmos dados que estou
        passando(banco,usuario e senha).


        --- In riojug@yahoogroups.com, Jo�o Paulo Linhares Gon�alves
        <joaopaulolg@g...> wrote:
        > A partir desta m�quina que est� com o Tomcat vc consegue se conectar
        > normalmente com o Oracle ?
        >
        > Procure compilar a classe de exemplo que vem com o driver JDBC do
        > Oracle, alterando a url para o seu caso e veja se consegue acessar o
        > banco.
        >
        >
        > Em 27/07/05, monte_sinai2001<monte_sinai2001@y...> escreveu:
        > >
        > > Beleza,
        > >
        > > Coloquei no diretorio lib do tomcat e o erro que aparece �(c) esse
        abaixo.
        > > E o que estou usando �(c):
        > >
        > > Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
        > >
        > > con =
        > >
        DriverManager.getConnection("jdbc:oracle:thin:@10.123.33.30:1521:SMS_WAP_TST","ADM_TSP","senha");
        > >
        > > Aonde pode estar o problema?
        > >
        > >
        > > javax.servlet.ServletException: Exceção de E/S: Connection
        > >
        refused(DESCRIPTION=(TMP=)(VSNNUM=135296000)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
        > >
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
        > >
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
        > >
        org.apache.jsp.conecta.Acesso_005fOracle_jsp._jspService(Acesso_005fOracle_jsp.java:79)
        > >
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        > >
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        > >
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        > >
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        > >
        > > root cause
        > >
        > > java.sql.SQLException: Exceção de E/S: Connection
        > >
        refused(DESCRIPTION=(TMP=)(VSNNUM=135296000)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
        > >
        oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        > >
        oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        > >
        oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
        > >
        oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
        > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
        > >
        oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
        > >
        oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
        > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
        > > java.sql.DriverManager.getConnection(DriverManager.java:512)
        > > java.sql.DriverManager.getConnection(DriverManager.java:171)
        > >
        org.apache.jsp.conecta.Acesso_005fOracle_jsp._jspService(Acesso_005fOracle_jsp.java:66)
        > >
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        > >
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        > >
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        > >
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        > >
        > >
        > >
        > >
        > >
        > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
        > > Rio Java Users Group www.riojug.org
        > > E-mail dos Moderadores riojug-owner@yahoogroups.com
        > >
        > > Patroc�nio: Quality Software, SENAC-Rio CIT, Locaweb
        > > Apoio: Java Magazine, SQL Magazine
        > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
        > > Participe tamb�m das outras listas do RioJUG:
        > > SCJP (groups.yahoo.com/group/scjp_riojug)
        > > SCWCD (groups.yahoo.com/group/scwcd_riojug)
        > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
        > > Yahoo! Groups Links
        > >
        > >
        > >
        > >
        > >
        > >
        > >
        >
        >
        > --
        > Jo�o Paulo L.G.
        > joaopaulolg@g...
      Your message has been successfully submitted and would be delivered to recipients shortly.