11.5 activiti 的部署步骤_大师哈哈哈

http://blog.sina.com.cn/u/3203118937

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

11.5 activiti 的部署步骤

(2015-11-05 11:09:13)

标签：

it

注意：请预留9080端口给 WebService

1、创建数据库 activitiDB,使用下面的脚本建表

create table ACT_ID_GROUP (

ID_ nvarchar(64),

REV_ int,

NAME_ nvarchar(255),

TYPE_ nvarchar(255),

primary key (ID_)

);

create table ACT_ID_MEMBERSHIP (

USER_ID_ nvarchar(64),

GROUP_ID_ nvarchar(64),

primary key (USER_ID_, GROUP_ID_)

);

create table ACT_ID_USER (

ID_ nvarchar(64),

REV_ int,

FIRST_ nvarchar(255),

LAST_ nvarchar(255),

EMAIL_ nvarchar(255),

PWD_ nvarchar(255),

PICTURE_ID_ nvarchar(64),

primary key (ID_)

);

create table ACT_ID_INFO (

ID_ nvarchar(64),

REV_ int,

USER_ID_ nvarchar(64),

TYPE_ nvarchar(64),

KEY_ nvarchar(255),

VALUE_ nvarchar(255),

PASSWORD_ varbinary(max),

PARENT_ID_ nvarchar(255),

primary key (ID_)

);

alter table ACT_ID_MEMBERSHIP

add constraint ACT_FK_MEMB_GROUP

foreign key (GROUP_ID_)

references ACT_ID_GROUP (ID_);

alter table ACT_ID_MEMBERSHIP

add constraint ACT_FK_MEMB_USER

foreign key (USER_ID_)

references ACT_ID_USER (ID_);

-------------------------------------------------------------------------------

create table ACT_GE_PROPERTY (

NAME_ nvarchar(64),

VALUE_ nvarchar(300),

REV_ int,

primary key (NAME_)

);

insert into ACT_GE_PROPERTY

values ('schema.version', '5.14', 1);

insert into ACT_GE_PROPERTY

values ('schema.history', 'create(5.14)', 1);

insert into ACT_GE_PROPERTY

values ('next.dbid', '1', 1);

create table ACT_GE_BYTEARRAY (

ID_ nvarchar(64),

REV_ int,

NAME_ nvarchar(255),

DEPLOYMENT_ID_ nvarchar(64),

BYTES_ varbinary(max),

GENERATED_ tinyint,

primary key (ID_)

);

create table ACT_RE_DEPLOYMENT (

ID_ nvarchar(64),

NAME_ nvarchar(255),

CATEGORY_ nvarchar(255),

DEPLOY_TIME_ datetime,

primary key (ID_)

);

create table ACT_RE_MODEL (

ID_ nvarchar(64) not null,

REV_ int,

NAME_ nvarchar(255),

KEY_ nvarchar(255),

CATEGORY_ nvarchar(255),

CREATE_TIME_ datetime,

LAST_UPDATE_TIME_ datetime,

VERSION_ int,

META_INFO_ nvarchar(4000),

DEPLOYMENT_ID_ nvarchar(64),

EDITOR_SOURCE_VALUE_ID_ nvarchar(64),

EDITOR_SOURCE_EXTRA_VALUE_ID_ nvarchar(64),

primary key (ID_)

);

create table ACT_RU_EXECUTION (

ID_ nvarchar(64),

REV_ int,

PROC_INST_ID_ nvarchar(64),

BUSINESS_KEY_ nvarchar(255),

PARENT_ID_ nvarchar(64),

PROC_DEF_ID_ nvarchar(64),

SUPER_EXEC_ nvarchar(64),

ACT_ID_ nvarchar(255),

IS_ACTIVE_ tinyint,

IS_CONCURRENT_ tinyint,

IS_SCOPE_ tinyint,

IS_EVENT_SCOPE_ tinyint,

SUSPENSION_STATE_ tinyint,

CACHED_ENT_STATE_ int,

primary key (ID_)

);

create table ACT_RU_JOB (

ID_ nvarchar(64) NOT NULL,

REV_ int,

TYPE_ nvarchar(255) NOT NULL,

LOCK_EXP_TIME_ datetime,

LOCK_OWNER_ nvarchar(255),

EXCLUSIVE_ bit,

EXECUTION_ID_ nvarchar(64),

PROCESS_INSTANCE_ID_ nvarchar(64),

PROC_DEF_ID_ nvarchar(64),

RETRIES_ int,

EXCEPTION_STACK_ID_ nvarchar(64),

EXCEPTION_MSG_ nvarchar(4000),

DUEDATE_ datetime NULL,

REPEAT_ nvarchar(255),

HANDLER_TYPE_ nvarchar(255),

HANDLER_CFG_ nvarchar(4000),

primary key (ID_)

);

create table ACT_RE_PROCDEF (

ID_ nvarchar(64) not null,

REV_ int,

CATEGORY_ nvarchar(255),

NAME_ nvarchar(255),

KEY_ nvarchar(255) not null,

VERSION_ int not null,

DEPLOYMENT_ID_ nvarchar(64),

RESOURCE_NAME_ nvarchar(4000),

DGRM_RESOURCE_NAME_ nvarchar(4000),

DESCRIPTION_ nvarchar(4000),

HAS_START_FORM_KEY_ tinyint,

SUSPENSION_STATE_ tinyint,

primary key (ID_)

);

create table ACT_RU_TASK (

ID_ nvarchar(64),

REV_ int,

EXECUTION_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

PROC_DEF_ID_ nvarchar(64),

NAME_ nvarchar(255),

PARENT_TASK_ID_ nvarchar(64),

DESCRIPTION_ nvarchar(4000),

TASK_DEF_KEY_ nvarchar(255),

OWNER_ nvarchar(255),

ASSIGNEE_ nvarchar(255),

DELEGATION_ nvarchar(64),

PRIORITY_ int,

CREATE_TIME_ datetime,

DUE_DATE_ datetime,

SUSPENSION_STATE_ int,

primary key (ID_)

);

create table ACT_RU_IDENTITYLINK (

ID_ nvarchar(64),

REV_ int,

GROUP_ID_ nvarchar(255),

TYPE_ nvarchar(255),

USER_ID_ nvarchar(255),

TASK_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

PROC_DEF_ID_ nvarchar(64),

primary key (ID_)

);

create table ACT_RU_VARIABLE (

ID_ nvarchar(64) not null,

REV_ int,

TYPE_ nvarchar(255) not null,

NAME_ nvarchar(255) not null,

EXECUTION_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

TASK_ID_ nvarchar(64),

BYTEARRAY_ID_ nvarchar(64),

DOUBLE_ double precision,

LONG_ numeric(19,0),

TEXT_ nvarchar(4000),

TEXT2_ nvarchar(4000),

primary key (ID_)

);

create table ACT_RU_EVENT_SUBSCR (

ID_ nvarchar(64) not null,

REV_ int,

EVENT_TYPE_ nvarchar(255) not null,

EVENT_NAME_ nvarchar(255),

EXECUTION_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

ACTIVITY_ID_ nvarchar(64),

CONFIGURATION_ nvarchar(255),

CREATED_ datetime not null,

primary key (ID_)

);

create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);

create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);

create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);

create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);

create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);

create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);

create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;

create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);

create index ACT_IDX_EXECUTION_PROC on ACT_RU_EXECUTION(PROC_DEF_ID_);

create index ACT_IDX_EXECUTION_PARENT on ACT_RU_EXECUTION(PARENT_ID_);

create index ACT_IDX_EXECUTION_SUPER on ACT_RU_EXECUTION(SUPER_EXEC_);

create index ACT_IDX_EXECUTION_IDANDREV on ACT_RU_EXECUTION(ID_, REV_);

create index ACT_IDX_VARIABLE_BA on ACT_RU_VARIABLE(BYTEARRAY_ID_);

create index ACT_IDX_VARIABLE_EXEC on ACT_RU_VARIABLE(EXECUTION_ID_);

create index ACT_IDX_VARIABLE_PROCINST on ACT_RU_VARIABLE(PROC_INST_ID_);

create index ACT_IDX_IDENT_LNK_TASK on ACT_RU_IDENTITYLINK(TASK_ID_);

create index ACT_IDX_IDENT_LNK_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);

create index ACT_IDX_IDENT_LNK_PROCDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);

create index ACT_IDX_TASK_EXEC on ACT_RU_TASK(EXECUTION_ID_);

create index ACT_IDX_TASK_PROCINST on ACT_RU_TASK(PROC_INST_ID_);

create index ACT_IDX_EXEC_PROC_INST_ID on ACT_RU_EXECUTION(PROC_INST_ID_);

create index ACT_IDX_TASK_PROC_DEF_ID on ACT_RU_TASK(PROC_DEF_ID_);

create index ACT_IDX_EVENT_SUBSCR_EXEC_ID on ACT_RU_EVENT_SUBSCR(EXECUTION_ID_);

create index ACT_IDX_JOB_EXCEPTION_STACK_ID on ACT_RU_JOB(EXCEPTION_STACK_ID_);

alter table ACT_GE_BYTEARRAY

add constraint ACT_FK_BYTEARR_DEPL

foreign key (DEPLOYMENT_ID_)

references ACT_RE_DEPLOYMENT (ID_);

alter table ACT_RE_PROCDEF

add constraint ACT_UNIQ_PROCDEF

unique (KEY_,VERSION_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_PARENT

foreign key (PARENT_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_SUPER

foreign key (SUPER_EXEC_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_PROCDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_TSKASS_TASK

foreign key (TASK_ID_)

references ACT_RU_TASK (ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_ATHRZ_PROCEDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_IDL_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_EXE

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_PROCDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_EXE

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION(ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_BYTEARRAY

foreign key (BYTEARRAY_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RU_JOB

add constraint ACT_FK_JOB_EXCEPTION

foreign key (EXCEPTION_STACK_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RU_EVENT_SUBSCR

add constraint ACT_FK_EVENT_EXEC

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION(ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_SOURCE

foreign key (EDITOR_SOURCE_VALUE_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_SOURCE_EXTRA

foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_DEPLOYMENT

foreign key (DEPLOYMENT_ID_)

references ACT_RE_DEPLOYMENT (ID_);

----------------------------------------------------------------------------------------------------

create table ACT_HI_PROCINST (

ID_ nvarchar(64) not null,

PROC_INST_ID_ nvarchar(64) not null,

BUSINESS_KEY_ nvarchar(255),

PROC_DEF_ID_ nvarchar(64) not null,

START_TIME_ datetime not null,

END_TIME_ datetime,

DURATION_ numeric(19,0),

START_USER_ID_ nvarchar(255),

START_ACT_ID_ nvarchar(255),

END_ACT_ID_ nvarchar(255),

SUPER_PROCESS_INSTANCE_ID_ nvarchar(64),

DELETE_REASON_ nvarchar(4000),

primary key (ID_),

unique (PROC_INST_ID_)

);

create table ACT_HI_ACTINST (

ID_ nvarchar(64) not null,

PROC_DEF_ID_ nvarchar(64) not null,

PROC_INST_ID_ nvarchar(64) not null,

EXECUTION_ID_ nvarchar(64) not null,

ACT_ID_ nvarchar(255) not null,

TASK_ID_ nvarchar(64),

CALL_PROC_INST_ID_ nvarchar(64),

ACT_NAME_ nvarchar(255),

ACT_TYPE_ nvarchar(255) not null,

ASSIGNEE_ nvarchar(255),

START_TIME_ datetime not null,

END_TIME_ datetime,

DURATION_ numeric(19,0),

primary key (ID_)

);

create table ACT_HI_TASKINST (

ID_ nvarchar(64) not null,

PROC_DEF_ID_ nvarchar(64),

TASK_DEF_KEY_ nvarchar(255),

PROC_INST_ID_ nvarchar(64),

EXECUTION_ID_ nvarchar(64),

NAME_ nvarchar(255),

PARENT_TASK_ID_ nvarchar(64),

DESCRIPTION_ nvarchar(4000),

OWNER_ nvarchar(255),

ASSIGNEE_ nvarchar(255),

START_TIME_ datetime not null,

CLAIM_TIME_ datetime,

END_TIME_ datetime,

DURATION_ numeric(19,0),

DELETE_REASON_ nvarchar(4000),

PRIORITY_ int,

DUE_DATE_ datetime,

FORM_KEY_ nvarchar(255),

primary key (ID_)

);

create table ACT_HI_VARINST (

ID_ nvarchar(64) not null,

PROC_INST_ID_ nvarchar(64),

EXECUTION_ID_ nvarchar(64),

TASK_ID_ nvarchar(64),

NAME_ nvarchar(255) not null,

VAR_TYPE_ nvarchar(100),

REV_ int,

BYTEARRAY_ID_ nvarchar(64),

DOUBLE_ double precision,

LONG_ numeric(19,0),

TEXT_ nvarchar(4000),

TEXT2_ nvarchar(4000),

primary key (ID_)

);

create table ACT_HI_DETAIL (

ID_ nvarchar(64) not null,

TYPE_ nvarchar(255) not null,

PROC_INST_ID_ nvarchar(64),

EXECUTION_ID_ nvarchar(64),

TASK_ID_ nvarchar(64),

ACT_INST_ID_ nvarchar(64),

NAME_ nvarchar(255) not null,

VAR_TYPE_ nvarchar(255),

REV_ int,

TIME_ datetime not null,

BYTEARRAY_ID_ nvarchar(64),

DOUBLE_ double precision,

LONG_ numeric(19,0),

TEXT_ nvarchar(4000),

TEXT2_ nvarchar(4000),

primary key (ID_)

);

create table ACT_HI_COMMENT (

ID_ nvarchar(64) not null,

TYPE_ nvarchar(255),

TIME_ datetime not null,

USER_ID_ nvarchar(255),

TASK_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

ACTION_ nvarchar(255),

MESSAGE_ nvarchar(4000),

FULL_MSG_ varbinary(max),

primary key (ID_)

);

create table ACT_HI_ATTACHMENT (

ID_ nvarchar(64) not null,

REV_ integer,

USER_ID_ nvarchar(255),

NAME_ nvarchar(255),

DESCRIPTION_ nvarchar(4000),

TYPE_ nvarchar(255),

TASK_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

URL_ nvarchar(4000),

CONTENT_ID_ nvarchar(64),

primary key (ID_)

);

create table ACT_HI_IDENTITYLINK (

ID_ nvarchar(64),

GROUP_ID_ nvarchar(255),

TYPE_ nvarchar(255),

USER_ID_ nvarchar(255),

TASK_ID_ nvarchar(64),

PROC_INST_ID_ nvarchar(64),

primary key (ID_)

);

create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);

create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);

create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);

create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);

create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);

create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);

create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);

create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);

create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);

create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);

create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);

create unique index ACT_UNIQ_HI_BUS_KEY on ACT_HI_PROCINST (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;

create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);

create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);

create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);

create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);

create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_);

----------------------------------------------------------------------------------------------------------------

2、拷贝 activiti 工程文件到机器的 C:\根下

3、修改activiti.cfg.xml 中的数据库信息

4、拷贝 java7

5、拷贝 tomcat6.0

6、设置 JAVA_HOME 和 Path 环境变量

7、用tomcat\bin\service.bat 把 tomcat 做成 windows 服务

8、启动服务

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report

前一篇：centos 常用命令（备忘）

后一篇：WIN下visual svn 自动备份与迁移实现办法

新浪BLOG意见反馈留言板　欢迎批评指正