Hi Friends
Iam trying to establish connection to oracle database I have the tns entries correct and am able to connect through sql plus but when I do programatically I get this error thrown on the
JBoss server.
Is there any other configuration that i need to do in JBoss.
18:31:16,577 INFO [STDOUT] Error Code : 17002
18:31:16,577 INFO [STDOUT] Error Message : Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
18:31:16,577 ERROR [STDERR] java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
18:31:16,577 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
18:31:16,577 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
18:31:16,577 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
18:31:16,577 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:263)
18:31:16,577 ERROR [STDERR] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
18:31:16,577 ERROR [STDERR] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
18:31:16,577 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:512)
18:31:16,577 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:171)
18:31:16,577 ERROR [STDERR] at org.nortel.accesscare.network.application.DBConnection.getConnection(DBConnection.java:32)
18:31:16,577 ERROR [STDERR] at org.nortel.accesscare.network.web.V_logonAction.execute(V_logonAction.java:43)
18:31:16,577 ERROR [STDERR] at org.nortel.accesscare.util.ACActionServlet.process(ACActionServlet.java:77)
18:31:16,577 ERROR [STDERR] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
18:31:16,577 ERROR [STDERR] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
18:31:16,577 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
18:31:16,577 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
18:31:16,587 ERROR [STDERR] at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
18:31:16,587 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
18:31:16,627 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
18:31:16,627 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
18:31:16,627 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
18:31:16,627 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
18:31:16,627 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
18:31:16,627 ERROR [STDERR] at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
18:31:16,627 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
18:31:16,627 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
18:31:16,627 ERROR [STDERR] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
18:31:16,627 ERROR [STDERR] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
18:31:16,627 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
Please gimme a solution....
Thanks and Regards,
Ramachandran.V