weblogic与oracle断开,Weblogic访问数据库存在闪断情况

最初由 caoliwei 发布

[B]用jdbc 写一段code test it [/B]

用weblogic直接测试连接数据库，有时成功，有时失败

怀疑是驱动问题，已经更新weblogic驱动

weblogic报错如下：

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:139) at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1092) at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1029) at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:320) at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:342) at weblogic.jdbc.common.internal.ConnectionPoolRuntimeMBeanImpl.testPool(ConnectionPoolRuntimeMBeanImpl.java:137) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:747) at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:726) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525) at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:765) at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946) at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481) at weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean_Stub.testPool(JDBCConnectionPoolRuntimeMBean_Stub.java:918) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPool(JDBCConnectionPoolCheckAction.java:194) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPool(JDBCConnectionPoolCheckAction.java:158) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPoolWrapper(JDBCConnectionPoolCheckAction.java:151) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.perform(JDBCConnectionPoolCheckAction.java:110) at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:173) at weblogic.management.console.actions.internal.ActionServlet.doGet(ActionServlet.java:91) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) --------------- nested within: ------------------ weblogic.common.ResourceException: 0:Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection - with nested exception: [weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection] at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1169) at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1029) at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:320) at weblogic.jdbc.common

.internal.ConnectionPool.reserve(ConnectionPool.java:342) at weblogic.jdbc.common.internal.ConnectionPoolRuntimeMBeanImpl.testPool(ConnectionPoolRuntimeMBeanImpl.java:137) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:747) at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:726) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525) at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:765) at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946) at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481) at weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean_Stub.testPool(JDBCConnectionPoolRuntimeMBean_Stub.java:918) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPool(JDBCConnectionPoolCheckAction.java:194) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPool(JDBCConnectionPoolCheckAction.java:158) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.testPoolWrapper(JDBCConnectionPoolCheckAction.java:151) at weblogic.management.console.actions.mbean.JDBCConnectionPoolCheckAction.perform(JDBCConnectionPoolCheckAction.java:110) at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:173) at weblogic.management.console.actions.internal.ActionServlet.doGet(ActionServlet.java:91) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)