java.sql.SQLException: User not found: SA

原创 2007年09月25日 17:40:00

错误:

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.2GA. It turned out that under the folder /server/<domain>/date/hypersonic the files had been corrupted.or changed  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. 

我的

D:/jboss-4.2.0.GA/server/all/data/hypersonic下的文件被build.xml给破坏了。删除后,重启JBoss就可回复。

mysql 存储过程的权限问题 java.sql.SQLException: The user specified as a definer ('xxxx'@'%') does not exist

从一个数据库 复制存储过程到另外一个数据库 如果是用图形界面的软件 比方说navicat   复制过去的话,然后执行 容易报错如下 java.sql.SQLException: The use...
  • sunjiyun26
  • sunjiyun26
  • 2016年07月04日 20:51
  • 742

java.sql.SQLException: Access denied for user 'Administrator'@'localhost' (using password: YES)

早上在做MyBatis+Spring整合的时候爆了个奇葩的bug org.mybatis.spring.MyBatisSystemException: nested exception is org...
  • u011731233
  • u011731233
  • 2015年08月26日 12:00
  • 5229

JBoss启动时报Problem starting service jboss:service=Hypersonic,database=localDB,java.sql.SQLException: User not found: SA解决办法

Jboss启动时一直报:        Problem   starting   service   jboss:service=Hypersonic,database=localDB        ...
  • lichkui
  • lichkui
  • 2008年01月09日 18:02
  • 4671

spring security authenticationProvider用法及关闭不隐藏UserNotFoundException的解决

这两天采用了spring security做登录验证,上一篇说到了增加图形验证码的解决办法,我们在config中增加了一个authenticationProvider的实现类。接下来我遇到的问题是用户...
  • wzl19870309
  • wzl19870309
  • 2017年04月21日 13:57
  • 1578

报表工具FineReport报错:java.sql.SQLException: The database is already in use by another process: lockFile

description The server encountered an internal error () that prevented it from fulfilling this reque...
  • leys123
  • leys123
  • 2014年06月04日 15:10
  • 4234

java通过JDBC链接SQLServer2012

下面请一字一句地看,一遍就设置成功,比你设置几十遍失败,费时会少得多。   首先,在连接数据库之前必须保证SQL Server 2012是采用SQL Server身份验证方式而不是windows身份验...
  • stewen_001
  • stewen_001
  • 2014年02月20日 14:20
  • 209803

Java的SQL语句的写法小结

Java的strSQL的写法确实有时候让人头疼:有 " +让你搞得不是很明白。其实,分开来看就行。识别每个符号的意思即可。"" 是SQL的字符串。是String类型的。 里主要用来字符串操作的。和数据...
  • longronglin
  • longronglin
  • 2006年11月03日 15:49
  • 2466

Spring Security教程(7)---- 解决UsernameNotFoundException无法被捕获的问题

这个教程是我在往项目中一点一点添加 Spring Security的过程的一个笔记,也是我学习 Spring Security的一个过程。 在解决这个问题之前要先说一点authenticatio...
  • z69183787
  • z69183787
  • 2014年03月13日 21:23
  • 6947

java.sql.SQLException: User not found: SA

错误:java.sql.SQLException: User not found: SA        at org.hsqldb.jdbc.Util.sqlException(Unknown Sou...
  • buffet518
  • buffet518
  • 2007年09月25日 17:40
  • 4009

java.sql.SQLException: 无效的列索引

java.sql.SQLException: 无效的列索引 “无效的列索引”其实是个低级的错误,原因无非几个:   1、sql串的?号数目和提供的变量数目不一致: 例如:jdb...
  • fu_manxing
  • fu_manxing
  • 2016年08月25日 15:23
  • 22090
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:java.sql.SQLException: User not found: SA
举报原因:
原因补充:

(最多只允许输入30个字)