tomcat7连接oracle的Connection refused问题解决
来源:互联网 发布:武钢裁员5万人 知乎 编辑:程序博客网 时间:2024/05/22 01:53
tomcat的server.xml配置如下:
<Resource name="jdbc/uopact1ds" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@30.51.9.26:1521:ngacct_s1" username="uop_act1" password="eb_1234" maxActive="60" maxIdle="20" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>报错信息如下:
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870592)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))org.apache.tapestry.ApplicationRuntimeExceptionorg.apache.tapestry.ApplicationRuntimeException: Unable to invoke method dataImportByTxt on com.company.sale.view.realuser.report.effectevaluation.DataImportList$Enhance_0@7e907e90[effectevaluation.DataImport]: nullcomponent:com.company.sale.view.realuser.report.effectevaluation.DataImportList$Enhance_0@7e907e90[effectevaluation.DataImport]location:context:/realuser/report/effectevaluation/DataImport.page, line 7, column 99 java.lang.RuntimeExceptionorg.apache.tapestry.ApplicationRuntimeException: Unable to invoke method dataImportByTxt on com.company.sale.view.realuser.report.effectevaluation.DataImportList$Enhance_0@7e907e90[effectevaluation.DataImport]: nullStack Trace:org.apache.tapestry.listener.ListenerMap$SyntheticListener.actionTriggered(ListenerMap.java:121)org.apache.tapestry.form.Submit.renderComponent(Submit.java:80)org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859)org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:626)org.apache.tapestry.form.Form.renderComponent(Form.java:366)org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859)org.apache.tapestry.form.Form.rewind(Form.java:601)org.apache.tapestry.engine.RequestCycle.rewindForm(RequestCycle.java:432)org.apache.tapestry.form.Form.trigger(Form.java:615)org.apache.tapestry.engine.DirectService.service(DirectService.java:169)org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:890)org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:200)org.apache.tapestry.ApplicationServlet.doPost(ApplicationServlet.java:329)javax.servlet.http.HttpServlet.service(HttpServlet.java:646)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)java.lang.Thread.run(Thread.java:736)Caused by: org.apache.tapestry.ApplicationRuntimeException: Unable to invoke method dataImportByTxt on com.company.sale.view.realuser.report.effectevaluation.DataImportList$Enhance_0@7e907e90[effectevaluation.DataImport]: nullorg.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMap.java:304)org.apache.tapestry.listener.ListenerMap.access$1(ListenerMap.java:269)org.apache.tapestry.listener.ListenerMap$SyntheticListener.invoke(ListenerMap.java:103)org.apache.tapestry.listener.ListenerMap$SyntheticListener.actionTriggered(ListenerMap.java:110)... 32 moreCaused by: java.lang.reflect.InvocationTargetExceptionsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)java.lang.reflect.Method.invoke(Method.java:611)org.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMap.java:278)... 35 moreCaused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870592)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)com.company.dbframework.jdbc.ConnectionManager.getConnection(ConnectionManager.java:172)com.company.webframework.tapestry.BaseData.getDBConn(BaseData.java:365)com.company.dbframework.BaseEntity.<init>(BaseEntity.java:39)com.company.component.AppEntity.<init>(AppEntity.java:32)com.company.sale.bean.realuser.report.effectevaluation.DataNumberListDAO.<init>(DataNumberListDAO.java:18)com.company.sale.bean.realuser.report.effectevaluation.DataImportBean.importSerialnumber(DataImportBean.java:105)com.company.sale.view.realuser.report.effectevaluation.DataImportList.dataImportByTxt(DataImportList.java:126)... 40 moreCaused by: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870592)(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:333)oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)... 49 more
select INSTANCE_NAME from v$instance;把ngacct_s1改为ngacct1即可。
本文出自:ouyida3的csdn blog
2015.3.5
0 0
- tomcat7连接oracle的Connection refused问题解决
- SSH connection refused的问题解决方法
- 远程连接 ssdb connection refused
- redis连接错误:Connection refused
- jTDS连接SQL Server时的Connection refused
- JDBC连接SqlServer2000出现"Connection refused: connect"的解决方案
- putty连接虚拟机里的ubuntu,提示说connection refused
- PUTTY连接虚拟机linux,出现connection refused的解决方法!
- ssh连接树莓派出现"network error:connection refused"的解决办法
- ssh连接树莓派出现"network error:connection refused"的解决办法
- android真机 连接PC端服务器调试 connection refused异常问题解决
- java.net.ConnectException: Connection refused问题解决办法
- 网络编程NetWorkOnMainThreadException和Connection refused问题解决
- java.net.ConnectException: Connection refused问题解决办法
- 本地Java连接oracle数据库失败Connection refused(sid指定错误)
- 连接Oracle数据库时遇到:Listener refused the connection with the following error。。。。
- socket--Connection refused的解决办法
- Connection refused问题的解决
- 【LeetCode】Linked List Cycle II
- uni1->C#->装箱拆箱
- Git删除空目录
- 硬盘基本知识(磁道、扇区、柱面、磁头数、簇、MBR、DBR)
- Generating SSH keys for github
- tomcat7连接oracle的Connection refused问题解决
- spring3.x使用经验总结
- 个推的使用方法
- SparseArray源码分析(未完)
- Linux cpuinfo 详解
- 堆和栈的区别
- python正则表达式
- hibernate get/load 懒加载 fetch
- C#中MessageBox的用法