Jboss 报错 java.sql.SQLException: User not found: SA

    技术2022-05-19  19

    今天上午在eclipse中重启了一下jboss报如下错误:

    sdx1 /opt/UMC/jboss/server/all/deploy>21:03:14,465 WARN  [ServiceController] Problem starting service jboss:service=Hypersonic,database=lo calDB java.sql.SQLException: User not found: SA         at org.hsqldb.jdbc.Util.sqlException(Unknown Source)         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)         at org.hsqldb.jdbcDriver.connect(Unknown Source)         at java.sql.DriverManager.getConnection(DriverManager.java:525)         at java.sql.DriverManager.getConnection(DriverManager.java:171)         at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:806)         at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:617)         at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:587)         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)         at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)         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:585)         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)         at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)         at $Proxy0.start(Unknown Source)         at org.jboss.system.ServiceController.start(ServiceController.java:428)         at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:585)         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)         at $Proxy4.start(Unknown Source)         at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)         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:585)         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce ptor.java:127)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)         at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)         at $Proxy41.start(Unknown Source)         at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:185)         at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)         at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:585)         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce ptor.java:127)         at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)         at $Proxy9.deploy(Unknown Source)         at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)         at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)         at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeplo ymentScanner.java:192)         at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploym entScanner.java:203)         at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeployme ntScanner.java:182) 21:03:14,488 ERROR [URLDeploymentScanner] Incomplete Deployment listing: --- MBeans waiting for other MBeans --- ObjectName: jboss:service=Hypersonic,database=localDB   State: FAILED   Reason: java.sql.SQLException: User not found: SA   Depends On Me:     jboss.jca:service=ManagedConnectionFactory,name=DefaultDS --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss:service=Hypersonic,database=localDB   State: FAILED   Reason: java.sql.SQLException: User not found: SA   Depends On Me:     jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

     

      在网上查找了解决办法如下:

     

    Just in case anyone else is looking at this an wondering what's going on. I had the same issue on JBoss 4.0.5GA. It turned out that under the folder /server//date/hypersonic the files had been corrupted. It seems that normally when you shutdown the server these get cleaned up and when you start the server they are recreated from the configuration. Basically I deleted the hypersonic directory and contents and restarted JBoss and everything sorted itself out.

    就是将/server//date/hypersonic 目录下的东西删除掉,重新启动jboss就好了。


    最新回复(0)