|
从HSQL 迁移到mysql 报错，不知道是hdsql 还是 mysql 有毛病，MySQL 版本是 5.7
com.fr.third.org.hibernate.exception.SQLGrammarException: could not execute statement
at com.fr.third.org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:91)
at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:60)
at com.fr.third.org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:111)
at com.fr.third.org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:429)
at com.fr.third.org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374)
at com.fr.third.org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1360)
at com.fr.third.org.hibernate.internal.QueryImpl.executeUpdate(QueryImpl.java:102)
at com.fr.decision.migration.manager.AbstractTransferManager.truncateTable(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.truncateTables(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.transfer(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(Unknown Source)
at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(Unknown Source)
at com.fr.decision.migration.MigrationContext$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'finedb.qrtz_triggers' doesn't exist
at sun.reflect.GeneratedConstructorAccessor735.newInstance(Unknown Source)
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:403)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2136)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2070)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5187)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2055)
at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:252)
at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 14 more
| 
