小白请教个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字段,百度的方法好像不多,找到的也不太适用我的,配置我都没碰过就报错了
...全文
570 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
白白了白呀白 2018-03-29
  • 打赏
  • 举报
回复
以解决,是数据库表不对的问题,我之前在本地数据库做的,刚连接公司数据库做就没问题了,重新导入下公司的数据库

50,336

社区成员

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛(原bbs)
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧