jeesite mysql_Jeesite框架mysql数据库初始报错

2023-05-16

[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] ------------------------------------------------------------------------

本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

jeesite mysql_Jeesite框架mysql数据库初始报错 的相关文章

  • 使用 RMySQL 会干扰 RPostgreSQL

    我有一个 R 脚本 我想从 MySQL 数据库中提取一些数据 然后从 PostgreSQL 数据库中提取一些数据 但是 从 RMySQL 加载 MySQL 驱动程序会阻止我从以下位置加载 PostgreSQL 驱动程序 PostgreSQL
  • mysqli_stmt_bind_result 的奇怪问题

    好吧 这让我很烦恼 我似乎在 PHP 文档中找不到任何内容 在 Google resultosphere 中也找不到任何内容 所以也许有人可以在这里提供帮助 我正在使用准备好的语句 绑定结果 然后使用这些绑定结果来填充下拉列表 例子
  • mysql中的按位移位

    如何在 MySQL 中进行按位移位 有没有具体的指令或者操作符 如果不是 如何最佳地模拟它 看一下按位运算符MySQL first http dev mysql com doc refman 5 0 en bit functions htm
  • 如何使组合键唯一?

    I am making a database of students in one school Here is what I have so far 如果您不喜欢阅读 请跳至 简而言之 部分 问题是我对这个设计并不满意 我想要的组合gra
  • 是否可以在MYSQL中动态选择列名,其中列名是N个已知值中的1?

    我担心答案会是直接的 不 但我想知道是否可以在 MySQL 中执行如下操作 SELECT title label name FROM table 即选择单个列 可以称为title label or name from table 原因是 查
  • MYSQL 查询 WHERE IN 与 OR

    我开发了一个使用 OR 查询的系统 SELECT FROM tableA JOIN tableB ON idA idB WHERE idA 1 OR idA 2 OR idA 3 OR idA 4 OR idA 5 OR idA 100 与
  • 从 varchar(100) 类型获取时间(HH:MM AM/PM)格式

    如何将字符串 RD OT 07 30 转换为时间 我只知道如何将 07 30 AM 转换为时间 下面的代码给了我一个空白数据 id strtoupper POST id query mysql query SELECT STR TO DAT
  • 删除 mysql 数据库中超过 3 个月的行的作业

    我们使用 mysql 服务器作为集中式日志系统 我希望有一项工作来定期删除 清理超过 3 个月的表条目 做这个的最好方式是什么 提前致谢 hinling 您是否在字段中存储项目的创建日期 If so DELETE FROM myTable
  • Mac OS X Yosemite/El Capitan 上自动启动 MySQL 服务器

    我想在启动时自动启动 MySQL 服务器 这在小牛队是可能的 但在优胜美地似乎不起作用 edit 似乎这也适用于 El Capitan dcc 非常接近 这是 MySQL 在 Yosemite 上再次自动启动的方式 The com mysq
  • 使用 Hibernate 和 MySQL、全局和本地进行 Spring 事务管理

    我正在使用 MySQL Server 5 1 Spring 3 0 5 和 Hibernate 3 6 开发 Web 应用程序 我使用 Springs 事务管理 我是新手 所以如果我问一个容易回答的问题 请耐心等待 1 我读到了有关全局 x
  • Mysql获取特定表的最后一个id

    我必须从特定的插入表中获取最后的插入 ID 可以说我有这个代码 INSERT INTO blahblah test1 test 2 VALUES test1 test2 INSERT INTO blahblah2 test1 test 2
  • 数据库中的持久日期不等于检索日期

    我有一个具有 Date 属性的简单实体类 此属性对应于 MySQL 日期时间列 Entity public class Entity Column name start date Temporal TemporalType TIMESTAM
  • MySQL #1093 - 您无法在 FROM 子句中指定用于更新的目标表“赠品”

    I tried UPDATE giveaways SET winner 1 WHERE ID SELECT MAX ID FROM giveaways 但它给出了 1093 您无法指定目标表 赠品 进行更新FROM clause 本文 ht
  • 显示一个表中的所有记录以及另一表中的匹配记录

    您好 我有一张下表 其中记录了活动和积分 Activites A ID Site ActivityValue ActivityName 1 site1 7 ActivityName1 2 site1 6 ActivityName2 2 si
  • 如何检查 $row['column_name'] 是否返回空 php mysql

    我有一个带有列的表格 id name phone describe 当我从这个表中获取值时 我正在使用 row mysql fetch array query 现在我想检查是否 row describe 返回空值 如何查看php 您可以使用
  • 数据库级别的别名列名 [MySQL]

    别名 可能是错误的词 因为它是在将列 表名称作为查询中的其他名称引用的上下文中使用的 我感兴趣的是是否有一种方法可以在数据库中为列指定两个名称 如果我要打印这样的表格 它看起来会是这样的 mysql gt SELECT FROM User
  • Python 的 mysqldb 晦涩文档

    Python 模块 mysqldb 中有许多转义函数 我不理解它们的文档 而且我努力查找它们也没有发现任何结果 gt gt gt print mysql escape doc escape obj dict escape any speci
  • 如何将“mysql source”命令与 mysql 变量一起使用?

    我需要从 mysql shell 执行一个基于如下条件的 SQL 文件 mysql gt 源 var 其中 var 包含文件名 这不可能 source是MySQL客户端程序在本地识别并执行的命令 变量存在于服务器上 因此客户端不知道什么 v
  • 退出 PHP 脚本后终止或停止 MySQL 查询

    我在工作中运行一个统计服务器 由于运行的查询量很大 该服务器有时会变得非常慢 我们的营销团队使用它作为主要统计工具 团队中的某些人有时会在脚本结束之前退出脚本 通过关闭浏览器或选项卡 同时 SQL 查询继续执行 当有人关闭或离开 PHP 脚
  • 通过Java从MySQL中获取大量记录

    有一个 MySQL 表 服务器上的用户 它有 28 行和 100 万条记录 也可能会增加 我想从这个表中获取所有行 对它们进行一些操作 然后将它们添加到 MongoDB 中 我知道通过简单的 从用户中选择 操作来检索这些记录将花费大量时间

随机推荐