Weblogic数据源连接问题

0 0

Weblogic数据源连接问题20

在使用数据源之后，每过一段时间就会报错。
数据源连接参数：
<jdbc-driver-params>
<url>jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 101.86.38.15)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 101.86.38.16)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = cpdb)))</url>
<driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>
两台数据库用做负载均衡。

错误信息如下：

2012-05-24 14:50:12,080 [org.hibernate.util.JDBCExceptionReporter][logExceptions]-[WARN] SQL Error: 0, SQLState: null
2012-05-24 14:50:12,083 [org.hibernate.util.JDBCExceptionReporter][logExceptions]-[ERROR] Internal error: Cannot obtain XAConnection Creation of XAConnection for pool jdbc/MRDS failed after default wait time configured for pool : java.lang.NullPointerException
2012-05-24 14:50:12,085 [org.hibernate.util.JDBCExceptionReporter][logExceptions]-[WARN] SQL Error: 0, SQLState: null
2012-05-24 14:50:12,087 [org.hibernate.util.JDBCExceptionReporter][logExceptions]-[ERROR] Internal error: Cannot obtain XAConnection Creation of XAConnection for pool jdbc/MRDS failed after default wait time configured for pool : java.lang.NullPointerException
2012-05-24 14:50:12,091 [org.codehaus.xfire.handler.DefaultFaultHandler][invoke]-[ERROR] Fault occurred!
java.lang.NullPointerException
at com.ausr.entry.ReWebServiceImpl.requestinfo201007(ReWebServiceImpl.java:316)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
at $Proxy63.requestinfo201007(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:54)
at org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:271)
at org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:84)
at org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:132)
at org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:107)
at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
at org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64)
at org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:39)
at org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:301)
at org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:130)
at org.codehaus.xfire.spring.remoting.XFireServletControllerAdapter.handleRequest(XFireServletControllerAdapter.java:68)
at org.codehaus.xfire.spring.remoting.XFireExporter.handleRequest(XFireExporter.java:48)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:717)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:658)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:857)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3244)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

谢谢！！！

Weblogic 负载均衡数据源

2012年5月24日 22:13

398986561
14
0 0 0

1个答案按时间排序按投票排序

0 0

你用xfire 时webservice导致的。
Cannot obtain XAConnection Creation of XAConnection for pool jdbc/MRDS failed after default wait time configured for pool
链接超时，是否应该配置大一些

2012年5月25日 09:17