java.sql.SQLException: XA error: XAER_RMFAIL

本文记录了一次晚上访问应用时遇到的数据库连接问题,错误显示无法打开连接,经过几分钟后问题自行解决。疑似网络波动或数据库连接问题导致。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

晚上访问应用时遇到一个错误,错误如下:

2007-08-07 22:18:37,986 - new97.pub.err.SysException:125  DEBUG - net.sf.hibernate.JDBCException: Cannot open connection
 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:281)
 at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
 at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
 at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
 at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
 at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
 at net.sf.hibernate.loader.Loader.list(Loader.java:941)
 at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483)
 at new97.sm.ejb.dao.SysUserDAO.findSysUsers(SysUserDAO.java:356)
 at new97.sm.ejb.dao.SysUserDAO.findSysUserByNamePwd(SysUserDAO.java:51)
 at new97.sm.ejb.service.SMSysUserSVRBean.login(SMSysUserSVRBean.java:63)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl.login(SMSysUserSVR_svlcb2_EOImpl.java:658)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl_CBV.login(Unknown Source)
 at new97.sm.delegate.SMSysUserDelegate.login(SMSysUserDelegate.java:186)
 at new97.sm.struts.SMLoginAction.login(SMLoginAction.java:79)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
 at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
 at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at new97.wm.struts.WMBatchOpertionFilter.doFilter(WMBatchOpertionFilter.java:76)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6987)
 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java(Compiled Code))
 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java(Compiled Code))
 at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
 at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
 at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java(Compiled Code))
 at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Caused by: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAER_RMFAIL : Resource manager is unavailable start() failed on resource 'OracleNew97Pool3': XAER_RMFAIL : Resource manager is unavailable
oracle.jdbc.xa.OracleXAException
 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java(Compiled Code))
 at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
 at weblogic.jdbc.wrapper.VendorXAResource.start(VendorXAResource.java:50)
 at weblogic.jdbc.jta.DataSource.start(DataSource.java:696)
 at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java(Compiled Code))
 at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java(Compiled Code))
 at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java(Compiled Code))
 at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.enlist(DataSource.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:450)
 at weblogic.jdbc.jta.DataSource.connect(DataSource.java:408)
 at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:329)
 at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
 at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
 at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
 at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
 at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
 at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
 at net.sf.hibernate.loader.Loader.list(Loader.java:941)
 at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483)
 at new97.sm.ejb.dao.SysUserDAO.findSysUsers(SysUserDAO.java:356)
 at new97.sm.ejb.dao.SysUserDAO.findSysUserByNamePwd(SysUserDAO.java:51)
 at new97.sm.ejb.service.SMSysUserSVRBean.login(SMSysUserSVRBean.java:63)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl.login(SMSysUserSVR_svlcb2_EOImpl.java:658)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl_CBV.login(Unknown Source)
 at new97.sm.delegate.SMSysUserDelegate.login(SMSysUserDelegate.java:186)
 at new97.sm.struts.SMLoginAction.login(SMLoginAction.java:79)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
 at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
 at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at new97.wm.struts.WMBatchOpertionFilter.doFilter(WMBatchOpertionFilter.java:76)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6987)
 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java(Compiled Code))
 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java(Compiled Code))
 at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
 at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
 at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java(Compiled Code))
 at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

 at weblogic.jdbc.jta.DataSource.enlist(DataSource.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:450)
 at weblogic.jdbc.jta.DataSource.connect(DataSource.java:408)
 at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:329)
 at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
 at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
 at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
 at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
 at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
 at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
 at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
 at net.sf.hibernate.loader.Loader.list(Loader.java:941)
 at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483)
 at new97.sm.ejb.dao.SysUserDAO.findSysUsers(SysUserDAO.java:356)
 at new97.sm.ejb.dao.SysUserDAO.findSysUserByNamePwd(SysUserDAO.java:51)
 at new97.sm.ejb.service.SMSysUserSVRBean.login(SMSysUserSVRBean.java:63)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl.login(SMSysUserSVR_svlcb2_EOImpl.java:658)
 at new97.sm.ejb.service.SMSysUserSVR_svlcb2_EOImpl_CBV.login(Unknown Source)
 at new97.sm.delegate.SMSysUserDelegate.login(SMSysUserDelegate.java:186)
 at new97.sm.struts.SMLoginAction.login(SMLoginAction.java:79)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
 at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
 at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at new97.wm.struts.WMBatchOpertionFilter.doFilter(WMBatchOpertionFilter.java:76)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6987)
 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java(Compiled Code))
 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java(Compiled Code))
 at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
 at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
 at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java(Compiled Code))
 at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

 at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java(Compiled Code))
 at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:450)
 at weblogic.jdbc.jta.DataSource.connect(DataSource.java:408)
 at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:329)
 at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
 ... 45 more

过了几分钟,我在登陆就OK了。不知道为什么?我怀疑是网络或由于连接不上数据库造成的,请各位大侠请教!!

 

java.sql.SQLException: Database connection error 是一个常见的数据库连接错误,通常在Java应用程序尝试连接数据库时发生。这个错误可能由多种原因引起,以下是一些常见的原因及解决方法: 1. **数据库URL错误**: - 检查数据库URL是否正确,包括主机名、端口号和数据库名。 - 确保URL格式符合所使用的数据库类型(如MySQL、PostgreSQL等)。 2. **数据库驱动问题**: - 确保已正确添加数据库驱动到项目的类路径中。 - 检查驱动版本是否与数据库版本兼容。 3. **数据库服务器未启动**: - 确认数据库服务器已启动并正在运行。 - 检查数据库服务器的网络连接是否正常。 4. **认证信息错误**: - 验证连接数据库的用户名和密码是否正确。 - 确保用户具有访问指定数据库的权限。 5. **网络问题**: - 检查网络连接是否正常,确保应用程序能够访问数据库服务器。 - 确认防火墙或安全组设置没有阻止数据库连接。 6. **连接池配置错误**: - 如果使用连接池(如HikariCP、C3P0等),检查连接池配置是否正确。 - 确认连接池参数(如最大连接数、最小连接数等)设置合理。 示例代码检查数据库连接: ```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DatabaseConnectionTest { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/your_database"; String user = "your_username"; String password = "your_password"; try { Connection connection = DriverManager.getConnection(url, user, password); System.out.println("Database connection successful!"); connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值