开发者社区> 问答> 正文

Jeesite框架mysql数据库初始报错?报错

[INFO] Scanning for projects...
[WARNING]
[WARNING] Some problems were encountered while building the effective model for com.thinkgem.jeesite:jeesite:war:1.2.7
[WARNING] 'dependencies.dependency.systemPath' for com.oracle:ojdbc14:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ojdbc14-10.2.0.4.0.jar will be unresolvable by dependent projects @ line 200, column 16
[WARNING] 'dependencies.dependency.systemPath' for org.wltea:analyzer:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/analyzer-2012_u6.jar will be unresolvable by dependent projects @ line 538, column 16
[WARNING] 'dependencies.dependency.systemPath' for net.coobird:thumbnailator:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/thumbnailator-0.4.2.jar will be unresolvable by dependent projects @ line 548, column 16
[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:apache-ant-zip:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/apache-ant-zip-2.3.jar will be unresolvable by dependent projects @ line 555, column 16
[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinder:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinder-2.3.jar will be unresolvable by dependent projects @ line 562, column 16
[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinderplugin-fileeditor:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinderplugin-fileeditor-2.3.jar will be unresolvable by dependent projects @ line 569, column 16
[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinderplugin-imageresize:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinderplugin-imageresize-2.3.jar will be unresolvable by dependent projects @ line 576, column 16
[WARNING] 'dependencies.dependency.systemPath' for bitwalker:UserAgentUtils:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/UserAgentUtils-1.13.jar will be unresolvable by dependent projects @ line 599, column 16
[WARNING]
[WARNING] It is highly recommended to fix these problems because they threaten the stability of your build.
[WARNING]
[WARNING] For this reason, future Maven versions might no longer support building such malformed projects.
[WARNING]
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building JeeSite 1.2.7
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-antrun-plugin:1.7:run (default-cli) @ jeesite ---
[INFO] Executing tasks

main:
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\sys\jeesite_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\cms\jeesite_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\oa\jeesite_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\gen\jeesite_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\gen\example_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\test\jeesite_mysql.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.engine.sql
      [sql] Failed to execute:  drop index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_TASK_CREATE on ACT_RU_TASK
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PROCINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PARENT
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_SUPER
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PROCDEF
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_EXE
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_PROCINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_PROCDEF
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_JOB drop FOREIGN KEY ACT_FK_JOB_EXCEPTION
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_job' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EVENT_SUBSCR drop FOREIGN KEY ACT_FK_EVENT_EXEC
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_SOURCE
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_SOURCE_EXTRA
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_DEPLOYMENT
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.history.sql
      [sql] Failed to execute:  drop index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  drop index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_taskinst' doesn't exist
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.identity.sql
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.engine.sql
      [sql] Failed to execute:   create table ACT_RE_DEPLOYMENT ( ID_ varchar(64), NAME_ varchar(255), CATEGORY_ varchar(255), TENANT_ID_ varchar(255) default '', DEPLOY_TIME_ timestamp(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bi' at line 1
      [sql] Failed to execute:   create table ACT_RE_MODEL ( ID_ varchar(64) not null, REV_ integer, NAME_ varchar(255), KEY_ varchar(255), CATEGORY_ varchar(255), CREATE_TIME_ timestamp(3) null, LAST_UPDATE_TIME_ timestamp(3) null, 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_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) null, LAST_UPDATE_TIME_ timestamp(3) null, VERSION_ integer, META_INFO_ varc' at line 1
      [sql] Failed to execute:   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_ TINYINT, IS_CONCURRENT_ TINYINT, IS_SCOPE_ TINYINT, IS_EVENT_SCOPE_ TINYINT, SUSPENSION_STATE_ integer, CACHED_ENT_STATE_ integer, TENANT_ID_ varchar(255) default '', NAME_ varchar(255), LOCK_TIME_ timestamp(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bi' at line 1
      [sql] Failed to execute:   create table ACT_RU_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, TYPE_ varchar(255) NOT NULL, LOCK_EXP_TIME_ timestamp(3) NULL, 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(3) NULL, REPEAT_ varchar(255), HANDLER_TYPE_ varchar(255), HANDLER_CFG_ varchar(4000), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, LOCK_OWNER_ varchar(255), EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64' at line 1
      [sql] Failed to execute:   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(3) NULL, DUE_DATE_ datetime(3), CATEGORY_ varchar(255), SUSPENSION_STATE_ integer, TENANT_ID_ varchar(255) default '', FORM_KEY_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, DUE_DATE_ datetime(3), CATEGORY_ varchar(255), SUSPENSION_STATE_ integ' at line 1
      [sql] Failed to execute:   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(3) not null DEFAULT CURRENT_TIMESTAMP(3), PROC_DEF_ID_ varchar(64), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null DEFAULT CURRENT_TIMESTAMP(3), PROC_DEF_ID_ varchar(64), TENANT_ID_ ' at line 1
      [sql] Failed to execute:   create table ACT_EVT_LOG ( LOG_NR_ bigint auto_increment, TYPE_ varchar(64), PROC_DEF_ID_ varchar(64), PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), TIME_STAMP_ timestamp(3) not null, USER_ID_ varchar(255), DATA_ LONGBLOB, LOCK_OWNER_ varchar(255), LOCK_TIME_ timestamp(3) null, IS_PROCESSED_ tinyint default 0, primary key (LOG_NR_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, USER_ID_ varchar(255), DATA_ LONGBLOB, LOCK_OWNER_ varchar(255), L' at line 1
      [sql] Failed to execute:   create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PARENT foreign key (PARENT_ID_) references ACT_RU_EXECUTION (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_SUPER foreign key (SUPER_EXEC_) references ACT_RU_EXECUTION (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK add constraint ACT_FK_TASK_EXE foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_JOB add constraint ACT_FK_JOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_job' doesn't exist
      [sql] Failed to execute:   alter table ACT_RU_EVENT_SUBSCR add constraint ACT_FK_EVENT_EXEC foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION(ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE foreign key (EDITOR_SOURCE_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE_EXTRA foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Failed to execute:   alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_DEPLOYMENT foreign key (DEPLOYMENT_ID_) references ACT_RE_DEPLOYMENT (ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.history.sql
      [sql] Failed to execute:  create table ACT_HI_PROCINST ( ID_ varchar(64) not null, PROC_INST_ID_ varchar(64) not null, BUSINESS_KEY_ varchar(255), PROC_DEF_ID_ varchar(64) not null, START_TIME_ datetime(3) not null, END_TIME_ datetime(3), DURATION_ bigint, START_USER_ID_ varchar(255), START_ACT_ID_ varchar(255), END_ACT_ID_ varchar(255), SUPER_PROCESS_INSTANCE_ID_ varchar(64), DELETE_REASON_ varchar(4000), TENANT_ID_ varchar(255) default '', NAME_ varchar(255), primary key (ID_), unique (PROC_INST_ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, END_TIME_ datetime(3), DURATION_ bigint, START_USER_ID_ varchar(25' at line 1
      [sql] Failed to execute:   create table ACT_HI_ACTINST ( ID_ varchar(64) not null, PROC_DEF_ID_ varchar(64) not null, PROC_INST_ID_ varchar(64) not null, EXECUTION_ID_ varchar(64) not null, ACT_ID_ varchar(255) not null, TASK_ID_ varchar(64), CALL_PROC_INST_ID_ varchar(64), ACT_NAME_ varchar(255), ACT_TYPE_ varchar(255) not null, ASSIGNEE_ varchar(255), START_TIME_ datetime(3) not null, END_TIME_ datetime(3), DURATION_ bigint, TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, END_TIME_ datetime(3), DURATION_ bigint, TENANT_ID_ varchar(255) d' at line 1
      [sql] Failed to execute:   create table ACT_HI_TASKINST ( ID_ varchar(64) not null, PROC_DEF_ID_ varchar(64), TASK_DEF_KEY_ varchar(255), PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), NAME_ varchar(255), PARENT_TASK_ID_ varchar(64), DESCRIPTION_ varchar(4000), OWNER_ varchar(255), ASSIGNEE_ varchar(255), START_TIME_ datetime(3) not null, CLAIM_TIME_ datetime(3), END_TIME_ datetime(3), DURATION_ bigint, DELETE_REASON_ varchar(4000), PRIORITY_ integer, DUE_DATE_ datetime(3), FORM_KEY_ varchar(255), CATEGORY_ varchar(255), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, CLAIM_TIME_ datetime(3), END_TIME_ datetime(3), DURATION_ bigint, ' at line 1
      [sql] Failed to execute:   create table ACT_HI_VARINST ( ID_ varchar(64) not null, PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), NAME_ varchar(255) not null, VAR_TYPE_ varchar(100), REV_ integer, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ varchar(4000), TEXT2_ varchar(4000), CREATE_TIME_ datetime(3), LAST_UPDATED_TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3), LAST_UPDATED_TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT C' at line 1
      [sql] Failed to execute:   create table ACT_HI_DETAIL ( ID_ varchar(64) not null, TYPE_ varchar(255) not null, PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), ACT_INST_ID_ varchar(64), NAME_ varchar(255) not null, VAR_TYPE_ varchar(255), REV_ integer, TIME_ datetime(3) not null, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ varchar(4000), TEXT2_ varchar(4000), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ var' at line 1
      [sql] Failed to execute:   create table ACT_HI_COMMENT ( ID_ varchar(64) not null, TYPE_ varchar(255), TIME_ datetime(3) not null, USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64), ACTION_ varchar(255), MESSAGE_ varchar(4000), FULL_MSG_ LONGBLOB, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar' at line 1
      [sql] Failed to execute:   create table ACT_HI_ATTACHMENT ( ID_ varchar(64) not null, REV_ integer, USER_ID_ varchar(255), NAME_ varchar(255), DESCRIPTION_ varchar(4000), TYPE_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64), URL_ varchar(4000), CONTENT_ID_ varchar(64), TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin' at line 1
      [sql] Failed to execute:    create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist
      [sql] Failed to execute:  create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_)
      [sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_taskinst' doesn't exist
      [sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.identity.sql
      [sql] 280 of 352 SQL statements executed successfully
   [dbunit] Executing operation: INSERT
   [dbunit]           on   file: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\sys\jeesite_data.xls
   [dbunit]           with format: xls
   [dbunit] Executing operation: INSERT
   [dbunit]           on   file: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\cms\jeesite_data.xls
   [dbunit]           with format: xls
[INFO] Executed tasks
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 40.745s
[INFO] Finished at: Mon Apr 24 10:31:21 CST 2017
[INFO] Final Memory: 18M/201M
[INFO] ------------------------------------------------------------------------

展开
收起
爱吃鱼的程序员 2020-06-08 15:20:20 940 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    maven的依赖jar有问题。还有就是数据库表很多都不存在,先跑一道脚本。

    就是跑的数据库初始脚本,然后报的这个错误检查一下,项目环境,在输出class文件路径,是否与output标签的路径一致。
    2020-06-08 15:20:38
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像