workflow添加mysql数据配置后不能登录

Question

后台报错

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Answer 1

提问者 qq_慕运维8168874 2019-08-22 22:46:53

提示有个表不存在。我在别的地方找到对应的表，添加上去就不报错了，应该是自动生成表时没有漏的表，或者是数据库版本的问题，我们课堂的数据库是什么版本啊

• Jimmy #1

  数据库是mysql6跟具体的版本关系不大

Answer 2

Jimmy 2019-08-22 22:40:55

看提示是数据库操作错误，请贴一下更明细的异常堆栈吗

• 慕神1562785 #1

  这张表是在什么时候创建的 ？ 
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'workflow2.act_idm_persistent_token' doesn't exist
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
          at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
          at com.mysql.jdbc.Util.getInstance(Util.java:408)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
          at