项目由tomcat转到was6.1.在连接oracle数据库时,有时是正常的,有时会出现java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection。
tomcat下一切正常,在网上找了好久也没找到答案,url正确,防火墙全部关闭,监听也有,而且在同一环境下tomcat启动,访问不会出现错误。
跪求大侠解决!
错误代码:
[12-5-10 16:08:01:652 GMT] 000000a0 PhaseIntercep W java.lang.Throwable <init> Application has thrown exception, unwinding now
                                 org.apache.cxf.interceptor.Fault: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionat org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:148)at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:83)at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:114)at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:55)at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:432)at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)at java.util.concurrent.FutureTask.run(FutureTask.java:138)at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:98)at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:236)at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:104)at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98)at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:392)at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:170)at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:142)at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:45)at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:101)at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:696)at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:641)at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1425)at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:92)at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:193)at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:725)at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:847)at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionat org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:596)at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:316)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)at com.newland.beecode.service.impl.CouponNewServiceImpl$$EnhancerByCGLIB$$3e9f24da.creatCouponsByBatch(<generated>)at com.newland.beecode.webservice.service.CreateCouponsFromFTPServiceImpl.creatCouponsByBatch(CreateCouponsFromFTPServiceImpl.java:26)at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:615)at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:166)at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)... 52 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connectionat org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1463)at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555)... 64 more
Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connectionat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)at java.sql.DriverManager.getConnection(DriverManager.java:562)at java.sql.DriverManager.getConnection(DriverManager.java:155)at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173)at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164)at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)... 69 more