1.问题现象
启动JBOSS 发现报User not found: SA 错误,异常日志如下:
java.sql.SQLException: User not found: SA
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(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)
2.问题原因
从Jboss开发人员社区找到了类似问题
User not found; hsqldb-ds.xml| JBoss.org Content Archive (Read Only)
有人回答处理方式
原文: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.
大概意思是他在JBoss 4.0.5GA上遇到了相同的问题, 他发现/server/date/hypersonic 这个文件损坏了。通常情况下,关闭Jboss服务器的时候这些文件会被清理,当启动JBoss服务器的时候,它们会根据配置重新创建。当JBoss服务器异常关闭时候可能会出现此问题,因此删除hypersonic 文件夹和文件夹中的内容重启Jboss后问题会自行解决
3.解决方法
按照上述处理删除 JBOSS-HOME/server/all/data/hypersonic 后问题解决