启动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.<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)
[处理方法]
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.
删除 JBOSS-HOME/server/all/data/hypersonic