NutzCN Logo
问答 nutzboot activiti集成 创建表 失败
发布于 508天前 作者 Hamming 913 次浏览 复制 上一个帖子 下一个帖子
标签:

nutzboot activiti集成 创建表 失败
异常信息 难道activiti 是用ibatis?

DEBUG] 17:53:54.699 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:34) - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
[DEBUG] 17:53:54.699 org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:19) - Running command with propagation NOT_SUPPORTED
[DEBUG] 17:53:54.709 org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138) - Opening JDBC Connection
[DEBUG] 17:53:54.709 org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102) - Setting autocommit to false on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@696174d3]
[DEBUG] 17:53:54.728 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==>  Preparing: select * from ACT_GE_PROPERTY where NAME_ = ? 
[DEBUG] 17:53:54.740 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==> Parameters: schema.version(String)
[ERROR] 17:53:54.760 org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:171) - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist
### The error may exist in org/activiti/db/mapping/entity/Property.xml
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
### The error occurred while setting parameters
### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
### Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)
	at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:471)
	at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:1029)
	at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1422)
	at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27)
	at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
	at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
	at org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:25)
	at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
	at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80)
	at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:613)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.nutz.lang.Invoking$NullArgInvoker.invoke(Invoking.java:77)
	at org.nutz.lang.Invoking.invoke(Invoking.java:192)
	at org.nutz.lang.Mirror.invoke(Mirror.java:1132)
	at org.nutz.ioc.impl.ObjectMakerImpl$1.born(ObjectMakerImpl.java:80)
	at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:78)
	at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:117)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161)
	at org.nutz.boot.starter.activiti.ActivitiSetupStarter.start(ActivitiSetupStarter.java:16)
	at org.nutz.boot.AppContext.startServers(AppContext.java:310)
	at org.nutz.boot.NbApp.execute(NbApp.java:210)
	at org.nutz.boot.NbApp.run(NbApp.java:182)
	at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:101)
Caused by: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist
8 回复

参考DEMO 每次启动 错误都不一样


[DEBUG] 18:04:45.315 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:34) - --- starting SchemaOperationsProcessEngineBuild -------------------------------------------------------- [DEBUG] 18:04:45.315 org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:19) - Running command with propagation NOT_SUPPORTED [DEBUG] 18:04:45.331 org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138) - Opening JDBC Connection [DEBUG] 18:04:45.331 org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102) - Setting autocommit to false on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@8bc0696] [DEBUG] 18:04:45.337 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==> Preparing: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [DEBUG] 18:04:45.347 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==> Parameters: [ERROR] 18:04:45.368 org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:171) - Error while closing command context org.activiti.engine.ActivitiException: no activiti tables in db. set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:940) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1419) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:25) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.nutz.lang.Invoking$NullArgInvoker.invoke(Invoking.java:77) at org.nutz.lang.Invoking.invoke(Invoking.java:192) at org.nutz.lang.Mirror.invoke(Mirror.java:1132) at org.nutz.ioc.impl.ObjectMakerImpl$1.born(ObjectMakerImpl.java:80) at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:78) at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:117) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161) at org.nutz.boot.starter.activiti.ActivitiSetupStarter.start(ActivitiSetupStarter.java:16) at org.nutz.boot.AppContext.startServers(AppContext.java:310) at org.nutz.boot.NbApp.execute(NbApp.java:210) at org.nutz.boot.NbApp.run(NbApp.java:182) at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:101) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' ### Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:67) at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:962) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:918) ... 27 more Caused by: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy52.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120) ... 32 more [DEBUG] 18:04:45.371 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:121) - firing event rolling back... [DEBUG] 18:04:45.372 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:128) - rolling back ibatis sql session... [DEBUG] 18:04:45.373 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:137) - firing event rolled back... [DEBUG] 18:04:45.373 org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:124) - Resetting autocommit to true on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@8bc0696] [DEBUG] 18:04:45.374 org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:92) - Closing JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@8bc0696] [DEBUG] 18:04:45.374 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:40) - --- SchemaOperationsProcessEngineBuild finished -------------------------------------------------------- [DEBUG] 18:04:45.374 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:41) - [DEBUG] 18:04:45.374 org.nutz.ioc.impl.ScopeContext.remove(ScopeContext.java:85) - Remove object 'processEngine' from [app] [ERROR] 18:04:45.375 org.nutz.boot.NbApp.execute(NbApp.java:224) - something happen!! org.nutz.ioc.IocException: IocBean[processEngine] throw Exception when creating at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:153) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161) at org.nutz.boot.starter.activiti.ActivitiSetupStarter.start(ActivitiSetupStarter.java:16) at org.nutz.boot.AppContext.startServers(AppContext.java:310) at org.nutz.boot.NbApp.execute(NbApp.java:210) at org.nutz.boot.NbApp.run(NbApp.java:182) at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:101) Caused by: org.nutz.lang.InvokingException: Fail to invoke [org.nutz.integration.activiti.NutProcessEngineConfiguration].buildProcessEngine() by args: For the reason: Table 'nutzsite.act_ge_property' doesn't exist at org.nutz.lang.Invoking.invoke(Invoking.java:195) at org.nutz.lang.Mirror.invoke(Mirror.java:1132) at org.nutz.ioc.impl.ObjectMakerImpl$1.born(ObjectMakerImpl.java:80) at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:78) at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:117) ... 8 more Caused by: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy52.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:67) at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:962) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:918) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1419) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:25) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.nutz.lang.Invoking$NullArgInvoker.invoke(Invoking.java:77) at org.nutz.lang.Invoking.invoke(Invoking.java:192) ... 12 more [INFO ] 18:04:45.383 org.eclipse.jetty.server.AbstractConnector.doStop(AbstractConnector.java:341) - Stopped ServerConnector@432e3a3b{HTTP/1.1,[http/1.1]}{127.0.0.1:8090} [INFO ] 18:04:45.383 org.eclipse.jetty.server.session.HouseKeeper.stopScavenging(HouseKeeper.java:167) - node0 Stopped scavenging [INFO ] 18:04:45.385 org.nutz.boot.starter.nutz.mvc.NbMvcLoading.depose(NbMvcLoading.java:54) - Nutz.Mvc[nutz] is deposing ...

哪种数据库,默认建表打开没?

MySQL 8.0 默认建表打开 还是一样的错


[DEBUG] 09:17:04.056 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:34) - --- starting SchemaOperationsProcessEngineBuild -------------------------------------------------------- [DEBUG] 09:17:04.056 org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:19) - Running command with propagation NOT_SUPPORTED [DEBUG] 09:17:04.064 org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138) - Opening JDBC Connection [DEBUG] 09:17:04.064 org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102) - Setting autocommit to false on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@d66502] [DEBUG] 09:17:04.078 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ? [DEBUG] 09:17:04.088 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142) - ==> Parameters: schema.version(String) [ERROR] 09:17:04.105 org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:171) - Error while closing command context org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73) at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:471) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:1029) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1422) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:25) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.nutz.lang.Invoking$NullArgInvoker.invoke(Invoking.java:77) at org.nutz.lang.Invoking.invoke(Invoking.java:192) at org.nutz.lang.Mirror.invoke(Mirror.java:1132) at org.nutz.ioc.impl.ObjectMakerImpl$1.born(ObjectMakerImpl.java:80) at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:78) at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:117) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161) at org.nutz.boot.starter.activiti.ActivitiSetupStarter.start(ActivitiSetupStarter.java:16) at org.nutz.boot.AppContext.startServers(AppContext.java:310) at org.nutz.boot.NbApp.execute(NbApp.java:210) at org.nutz.boot.NbApp.run(NbApp.java:182) at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:105) Caused by: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy51.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120) ... 31 more [DEBUG] 09:17:04.107 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:121) - firing event rolling back... [DEBUG] 09:17:04.107 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:128) - rolling back ibatis sql session... [DEBUG] 09:17:04.108 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:137) - firing event rolled back... [DEBUG] 09:17:04.108 org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:124) - Resetting autocommit to true on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@d66502] [DEBUG] 09:17:04.108 org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:92) - Closing JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@d66502] [DEBUG] 09:17:04.108 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:40) - --- SchemaOperationsProcessEngineBuild finished -------------------------------------------------------- [DEBUG] 09:17:04.108 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:41) - [DEBUG] 09:17:04.109 org.nutz.ioc.impl.ScopeContext.remove(ScopeContext.java:85) - Remove object 'processEngine' from [app] [ERROR] 09:17:04.109 org.nutz.boot.NbApp.execute(NbApp.java:224) - something happen!! org.nutz.ioc.IocException: IocBean[processEngine] throw Exception when creating at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:153) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271) at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161) at org.nutz.boot.starter.activiti.ActivitiSetupStarter.start(ActivitiSetupStarter.java:16) at org.nutz.boot.AppContext.startServers(AppContext.java:310) at org.nutz.boot.NbApp.execute(NbApp.java:210) at org.nutz.boot.NbApp.run(NbApp.java:182) at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:105) Caused by: org.nutz.lang.InvokingException: Fail to invoke [org.nutz.integration.activiti.NutProcessEngineConfiguration].buildProcessEngine() by args: For the reason: Table 'nutzsite.act_ge_property' doesn't exist at org.nutz.lang.Invoking.invoke(Invoking.java:195) at org.nutz.lang.Mirror.invoke(Mirror.java:1132) at org.nutz.ioc.impl.ObjectMakerImpl$1.born(ObjectMakerImpl.java:80) at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:78) at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:117) ... 8 more Caused by: java.sql.SQLSyntaxErrorException: Table 'nutzsite.act_ge_property' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy51.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73) at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:471) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:1029) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1422) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:25) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.nutz.lang.Invoking$NullArgInvoker.invoke(Invoking.java:77) at org.nutz.lang.Invoking.invoke(Invoking.java:192) ... 12 more [INFO ] 09:17:04.119 org.eclipse.jetty.server.AbstractConnector.doStop(AbstractConnector.java:341) - Stopped ServerConnector@67d0c728{HTTP/1.1,[http/1.1]}{127.0.0.1:8090} [INFO ] 09:17:04.119 org.eclipse.jetty.server.session.HouseKeeper.stopScavenging(HouseKeeper.java:167) - node0 Stopped scavenging [INFO ] 09:17:04.120 org.nutz.boot.starter.nutz.mvc.NbMvcLoading.depose(NbMvcLoading.java:54) - Nutz.Mvc[nutz] is deposing ... [INFO ] 09:17:04.120 org.nutz.boot.starter.nutz.mvc.NbMvcLoading.depose(NbMvcLoading.java:70) - Nutz.Mvc[nutz] is down in 0ms [INFO ] 09:17:04.124 org.eclipse.jetty.server.handler.ContextHandler$Context.log(ContextHandler.java:2345) - Cleaning up Shiro Environment [INFO ] 09:17:04.124 org.eclipse.jetty.server.handler.ContextHandler.doStop(ContextHandler.java:1045) - Stopped o.e.j.w.WebAppContext@2f054f70{/,[file:///Users/apple/IdeaProjects/ns/src/main/resources/static/, file:///Users/apple/IdeaProjects/ns/target/classes/static/, jar:file:/Users/apple/.m2/repository/org/nutz/nutzboot-starter-swagger/2.3.4.v20190410/nutzboot-starter-swagger-2.3.4.v20190410.jar!/static/],UNAVAILABLE} [INFO ] 09:17:04.127 org.nutz.ioc.impl.NutIoc.depose(NutIoc.java:287) - org.nutz.ioc.impl.NutIoc@612089786 is closing. startup date [19-05-06 09:16:59.964] [DEBUG] 09:17:04.128 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:109) - Depose object 'nutIocElResolver' ...

DEMO 运行 H2 可以建表


[DEBUG] 09:22:33.002 org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:34) - --- starting SchemaOperationsProcessEngineBuild -------------------------------------------------------- [DEBUG] 09:22:33.002 org.nutz.integration.activiti.NutTransactionInterceptor.execute(NutTransactionInterceptor.java:19) - Running command with propagation NOT_SUPPORTED [DEBUG] 09:22:33.010 org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138) - Opening JDBC Connection [DEBUG] 09:22:33.011 org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102) - Setting autocommit to false on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@6f70a21b] [INFO ] 09:22:33.038 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1240) - performing create on engine with resource org/activiti/db/create/activiti.h2.create.engine.sql [DEBUG] 09:22:33.041 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_GE_PROPERTY ( NAME_ varchar(64), VALUE_ varchar(300), REV_ integer, primary key (NAME_) ) [DEBUG] 09:22:33.053 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: insert into ACT_GE_PROPERTY values ('schema.version', '5.22.0.0', 1) [DEBUG] 09:22:33.055 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: insert into ACT_GE_PROPERTY values ('schema.history', 'create(5.22.0.0)', 1) [DEBUG] 09:22:33.055 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: insert into ACT_GE_PROPERTY values ('next.dbid', '1', 1) [DEBUG] 09:22:33.055 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_GE_BYTEARRAY ( ID_ varchar(64), REV_ integer, NAME_ varchar(255), DEPLOYMENT_ID_ varchar(64), BYTES_ longvarbinary, GENERATED_ bit, primary key (ID_) ) [DEBUG] 09:22:33.056 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RE_DEPLOYMENT ( ID_ varchar(64), NAME_ varchar(255), CATEGORY_ varchar(255), TENANT_ID_ varchar(255) default '', DEPLOY_TIME_ timestamp, primary key (ID_) ) [DEBUG] 09:22:33.058 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RE_MODEL ( ID_ varchar(64) not null, REV_ integer, NAME_ varchar(255), KEY_ varchar(255), CATEGORY_ varchar(255), CREATE_TIME_ timestamp, LAST_UPDATE_TIME_ timestamp, VERSION_ integer, META_INFO_ varchar(4000), DEPLOYMENT_ID_ varchar(64), EDITOR_SOURCE_VALUE_ID_ varchar(64), EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64), TENANT_ID_ varchar(255) default '', primary key (ID_) ) [DEBUG] 09:22:33.059 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_EXECUTION ( ID_ varchar(64), REV_ integer, PROC_INST_ID_ varchar(64), BUSINESS_KEY_ varchar(255), PARENT_ID_ varchar(64), PROC_DEF_ID_ varchar(64), SUPER_EXEC_ varchar(64), ACT_ID_ varchar(255), IS_ACTIVE_ bit, IS_CONCURRENT_ bit, IS_SCOPE_ bit, IS_EVENT_SCOPE_ bit, SUSPENSION_STATE_ integer, CACHED_ENT_STATE_ integer, TENANT_ID_ varchar(255) default '', NAME_ varchar(255), LOCK_TIME_ timestamp, primary key (ID_) ) [DEBUG] 09:22:33.060 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, TYPE_ varchar(255) NOT NULL, LOCK_EXP_TIME_ timestamp, LOCK_OWNER_ varchar(255), EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64), PROCESS_INSTANCE_ID_ varchar(64), PROC_DEF_ID_ varchar(64), RETRIES_ integer, EXCEPTION_STACK_ID_ varchar(64), EXCEPTION_MSG_ varchar(4000), DUEDATE_ timestamp, REPEAT_ varchar(255), HANDLER_TYPE_ varchar(255), HANDLER_CFG_ varchar(4000), TENANT_ID_ varchar(255) default '', primary key (ID_) ) [DEBUG] 09:22:33.062 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RE_PROCDEF ( ID_ varchar(64) NOT NULL, REV_ integer, CATEGORY_ varchar(255), NAME_ varchar(255), KEY_ varchar(255) NOT NULL, VERSION_ integer NOT NULL, DEPLOYMENT_ID_ varchar(64), RESOURCE_NAME_ varchar(4000), DGRM_RESOURCE_NAME_ varchar(4000), DESCRIPTION_ varchar(4000), HAS_START_FORM_KEY_ bit, HAS_GRAPHICAL_NOTATION_ bit, SUSPENSION_STATE_ integer, TENANT_ID_ varchar(255) default '', primary key (ID_) ) [DEBUG] 09:22:33.063 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_TASK ( ID_ varchar(64), REV_ integer, EXECUTION_ID_ varchar(64), PROC_INST_ID_ varchar(64), PROC_DEF_ID_ varchar(64), NAME_ varchar(255), PARENT_TASK_ID_ varchar(64), DESCRIPTION_ varchar(4000), TASK_DEF_KEY_ varchar(255), OWNER_ varchar(255), ASSIGNEE_ varchar(255), DELEGATION_ varchar(64), PRIORITY_ integer, CREATE_TIME_ timestamp, DUE_DATE_ timestamp, CATEGORY_ varchar(255), SUSPENSION_STATE_ integer, TENANT_ID_ varchar(255) default '', FORM_KEY_ varchar(255), primary key (ID_) ) [DEBUG] 09:22:33.064 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_IDENTITYLINK ( ID_ varchar(64), REV_ integer, GROUP_ID_ varchar(255), TYPE_ varchar(255), USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64) null, PROC_DEF_ID_ varchar(64), primary key (ID_) ) [DEBUG] 09:22:33.065 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_VARIABLE ( ID_ varchar(64) not null, REV_ integer, TYPE_ varchar(255) not null, NAME_ varchar(255) not null, EXECUTION_ID_ varchar(64), PROC_INST_ID_ varchar(64), TASK_ID_ varchar(64), BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ varchar(4000), TEXT2_ varchar(4000), primary key (ID_) ) [DEBUG] 09:22:33.066 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_RU_EVENT_SUBSCR ( ID_ varchar(64) not null, REV_ integer, EVENT_TYPE_ varchar(255) not null, EVENT_NAME_ varchar(255), EXECUTION_ID_ varchar(64), PROC_INST_ID_ varchar(64), ACTIVITY_ID_ varchar(64), CONFIGURATION_ varchar(255), CREATED_ timestamp not null, PROC_DEF_ID_ varchar(64), TENANT_ID_ varchar(255) default '', primary key (ID_) ) [DEBUG] 09:22:33.067 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_EVT_LOG ( LOG_NR_ identity, TYPE_ varchar(64), PROC_DEF_ID_ varchar(64), PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), TIME_STAMP_ timestamp not null, USER_ID_ varchar(255), DATA_ longvarbinary, LOCK_OWNER_ varchar(255), LOCK_TIME_ timestamp, IS_PROCESSED_ bit default 0 ) [DEBUG] 09:22:33.084 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create table ACT_PROCDEF_INFO ( ID_ varchar(64) not null, PROC_DEF_ID_ varchar(64) not null, REV_ integer, INFO_JSON_ID_ varchar(64), primary key (ID_) ) [DEBUG] 09:22:33.085 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_) [DEBUG] 09:22:33.086 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_) [DEBUG] 09:22:33.087 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_) [DEBUG] 09:22:33.087 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_) [DEBUG] 09:22:33.088 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_) [DEBUG] 09:22:33.088 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_) [DEBUG] 09:22:33.089 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_) [DEBUG] 09:22:33.089 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: create index ACT_IDX_INFO_PROCDEF on ACT_PROCDEF_INFO(PROC_DEF_ID_) [DEBUG] 09:22:33.089 org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1310) - SQL: alter table ACT_GE_BYTEARRAY

兼容性问题吧

呃 那怎么解决呢

找到 创建DB 的SQL了 手动建表
org/activiti/activiti-engine/5.22.0/activiti-engine-5.22.0.jar!/org/activiti/db/create/activiti.mysql.create.engine.sql
activiti.mysql.create.history.sql
activiti.mysql.create.identity.sql

添加回复
请先登陆
回到顶部