小白请教个shiro报错问题

白白了白呀白 2018-03-29 09:57:24

项目昨天还运行好好的早上来启动就报下面的错误了
2018-03-29 09:44:49,536 INFO [apache.shiro.session.mgt.AbstractValidatingSessionManager] - Enabling session validation scheduler...
2018-03-29 09:45:04,518 INFO [springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2018-03-29 09:45:04,552 INFO [org.springframework.jdbc.support.SQLErrorCodesFactory] - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
2018-03-29 09:45:04,569 WARN [org.apache.shiro.authc.AbstractAuthenticator] - Authentication failed for token submission [com.smart.common.shiro.authority.security.UsernamePasswordToken - admin, rememberMe=true (0:0:0:0:0:0:0:1)]. Possible unexpected error? (Typical or expected login exceptions should extend from AuthenticationException).
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select * from sys_user where login_name = ?]; SQL state [S0022]; error code [0]; Column 'sys_org_id' not found.; nested exception is java.sql.SQLException: Column 'sys_org_id' not found.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655)

org.apache.shiro.authc.AuthenticationException: Authentication failed for token submission [com.smart.common.shiro.authority.security.UsernamePasswordToken - admin, rememberMe=true (0:0:0:0:0:0:0:1)]. Possible unexpected error? (Typical or expected login exceptions should extend from AuthenticationException).
at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:214)
at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:274)
at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:260)
a
Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select * from sys_user where login_name = ?]; SQL state [S0022]; error code [0]; Column 'sys_org_id' not found.; nested exception is java.sql.SQLException: Column 'sys_org_id' not found.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655)
at org.springfra
Caused by: java.sql.SQLException: Column 'sys_org_id' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1080)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5177)

有一句说Column 'sys_org_id' not found.可是我在这个实体类里有找到sysOrgId字段，百度的方法好像不多，找到的也不太适用我的，配置我都没碰过就报错了

...全文