As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
db=mssql jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.url=jdbc:sqlserver://10.0.9.30;DatabaseName=test jdbc.username=sa jdbc.password=123465$
db=h2 jdbc.driver=org.h2.Driver jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000 jdbc.username=sa jdbc.password=
<br><bean id="mssqlDataSource" class="org.apache.commons.dbcp.BasicDataSource"><br> <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" /><br> <property name="url" value="jdbc:jtds:sqlserver://localhost/activiti" /><br> <property name="username" value="sa" /><br> <property name="password" value="sa" /><br> <property name="defaultAutoCommit" value="false" /><br> </bean><br> <bean id="transactionManager"<br> class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><br> <property name="dataSource" ref="mssqlDataSource" /><br> </bean><br><br> <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"><br> <property name="dataSource" ref="mssqlDataSource" /><br> <property name="transactionManager" ref="transactionManager" /><br> <property name="databaseSchemaUpdate" value="false" /><br> <property name="jobExecutorActivate" value="true" /><br> <property name="customFormTypes"><br> <list><br> <ref bean="userFormType" /><br> </list><br> </property><br> </bean><br><br> <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"<br> destroy-method="destroy"><br> <property name="processEngineConfiguration" ref="processEngineConfiguration" /><br> </bean><br>
create table ACT_GE_PROPERTY (<br> NAME_ nvarchar(64),<br> VALUE_ nvarchar(300),<br> REV_ int,<br> primary key (NAME_)<br>);<br><br>insert into ACT_GE_PROPERTY<br>values ('schema.version', '5.7', 1);<br><br>insert into ACT_GE_PROPERTY<br>values ('schema.history', 'create(5.7)', 1);<br><br>insert into ACT_GE_PROPERTY<br>values ('next.dbid', '1', 1);<br><br>create table ACT_GE_BYTEARRAY (<br> ID_ nvarchar(64),<br> REV_ int,<br> NAME_ nvarchar(255),<br> DEPLOYMENT_ID_ nvarchar(64),<br> BYTES_ image,<br> primary key (ID_)<br>);<br><br>create table ACT_RE_DEPLOYMENT (<br> ID_ nvarchar(64),<br> NAME_ nvarchar(255),<br> DEPLOY_TIME_ datetime,<br> primary key (ID_)<br>);<br><br>create table ACT_RU_EXECUTION (<br> ID_ nvarchar(64),<br> REV_ int,<br> PROC_INST_ID_ nvarchar(64),<br> BUSINESS_KEY_ nvarchar(255),<br> PARENT_ID_ nvarchar(64),<br> PROC_DEF_ID_ nvarchar(64),<br> SUPER_EXEC_ nvarchar(64),<br> ACT_ID_ nvarchar(255),<br> IS_ACTIVE_ tinyint,<br> IS_CONCURRENT_ tinyint,<br> IS_SCOPE_ tinyint,<br> COMPUTED_KEY_ AS ( CASE WHEN BUSINESS_KEY_ IS NULL THEN ID_ ELSE BUSINESS_KEY_ END ),<br> primary key (ID_)<br>);<br><br>create table ACT_RU_JOB (<br> ID_ nvarchar(64) NOT NULL,<br> REV_ int,<br> TYPE_ nvarchar(255) NOT NULL,<br> LOCK_EXP_TIME_ datetime,<br> LOCK_OWNER_ nvarchar(255),<br> EXCLUSIVE_ bit,<br> EXECUTION_ID_ nvarchar(64),<br> PROCESS_INSTANCE_ID_ nvarchar(64),<br> RETRIES_ int,<br> EXCEPTION_STACK_ID_ nvarchar(64),<br> EXCEPTION_MSG_ nvarchar(4000),<br> DUEDATE_ datetime NULL,<br> REPEAT_ nvarchar(255),<br> HANDLER_TYPE_ nvarchar(255),<br> HANDLER_CFG_ nvarchar(4000),<br> primary key (ID_)<br>);<br><br>create table ACT_RE_PROCDEF (<br> ID_ nvarchar(64),<br> CATEGORY_ nvarchar(255),<br> NAME_ nvarchar(255),<br> KEY_ nvarchar(255),<br> VERSION_ int,<br> DEPLOYMENT_ID_ nvarchar(64),<br> RESOURCE_NAME_ nvarchar(4000),<br> DGRM_RESOURCE_NAME_ nvarchar(4000),<br> HAS_START_FORM_KEY_ tinyint,<br> primary key (ID_)<br>);<br><br>create table ACT_RU_TASK (<br> ID_ nvarchar(64),<br> REV_ int,<br> EXECUTION_ID_ nvarchar(64),<br> PROC_INST_ID_ nvarchar(64),<br> PROC_DEF_ID_ nvarchar(64),<br> NAME_ nvarchar(255),<br> PARENT_TASK_ID_ nvarchar(64),<br> DESCRIPTION_ nvarchar(4000),<br> TASK_DEF_KEY_ nvarchar(255),<br> OWNER_ nvarchar(64),<br> ASSIGNEE_ nvarchar(64),<br> DELEGATION_ nvarchar(64),<br> PRIORITY_ int,<br> CREATE_TIME_ datetime,<br> DUE_DATE_ datetime,<br> primary key (ID_)<br>);<br><br>create table ACT_RU_IDENTITYLINK (<br> ID_ nvarchar(64),<br> REV_ int,<br> GROUP_ID_ nvarchar(64),<br> TYPE_ nvarchar(255),<br> USER_ID_ nvarchar(64),<br> TASK_ID_ nvarchar(64),<br> primary key (ID_)<br>);<br><br>create table ACT_RU_VARIABLE (<br> ID_ nvarchar(64) not null,<br> REV_ int,<br> TYPE_ nvarchar(255) not null,<br> NAME_ nvarchar(255) not null,<br> EXECUTION_ID_ nvarchar(64),<br> PROC_INST_ID_ nvarchar(64),<br> TASK_ID_ nvarchar(64),<br> BYTEARRAY_ID_ nvarchar(64),<br> DOUBLE_ double precision,<br> LONG_ numeric(19,0),<br> TEXT_ nvarchar(4000),<br> TEXT2_ nvarchar(4000),<br> primary key (ID_)<br>);<br><br>create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);<br>create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);<br>create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);<br>create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);<br>CREATE UNIQUE INDEX ACT_UNIQ_RU_BUS_KEY ON ACT_RU_EXECUTION (PROC_DEF_ID_, COMPUTED_KEY_);<br><br>alter table ACT_GE_BYTEARRAY<br> add constraint ACT_FK_BYTEARR_DEPL <br> foreign key (DEPLOYMENT_ID_) <br> references ACT_RE_DEPLOYMENT (ID_);<br><br>alter table ACT_RU_EXECUTION<br> add constraint ACT_FK_EXE_PARENT <br> foreign key (PARENT_ID_) <br> references ACT_RU_EXECUTION (ID_);<br> <br>alter table ACT_RU_EXECUTION<br> add constraint ACT_FK_EXE_SUPER <br> foreign key (SUPER_EXEC_) <br> references ACT_RU_EXECUTION (ID_);<br> <br>alter table ACT_RU_IDENTITYLINK<br> add constraint ACT_FK_TSKASS_TASK <br> foreign key (TASK_ID_) <br> references ACT_RU_TASK (ID_);<br> <br>alter table ACT_RU_TASK<br> add constraint ACT_FK_TASK_EXE<br> foreign key (EXECUTION_ID_)<br> references ACT_RU_EXECUTION (ID_);<br> <br>alter table ACT_RU_TASK<br> add constraint ACT_FK_TASK_PROCINST<br> foreign key (PROC_INST_ID_)<br> references ACT_RU_EXECUTION (ID_);<br> <br>alter table ACT_RU_TASK<br> add constraint ACT_FK_TASK_PROCDEF<br> foreign key (PROC_DEF_ID_)<br> references ACT_RE_PROCDEF (ID_);<br> <br>alter table ACT_RU_VARIABLE <br> add constraint ACT_FK_VAR_EXE <br> foreign key (EXECUTION_ID_) <br> references ACT_RU_EXECUTION (ID_);<br><br>alter table ACT_RU_VARIABLE<br> add constraint ACT_FK_VAR_PROCINST<br> foreign key (PROC_INST_ID_)<br> references ACT_RU_EXECUTION(ID_);<br><br>alter table ACT_RU_VARIABLE <br> add constraint ACT_FK_VAR_BYTEARRAY <br> foreign key (BYTEARRAY_ID_) <br> references ACT_GE_BYTEARRAY (ID_);<br> <br>alter table ACT_RU_JOB <br> add constraint ACT_FK_JOB_EXCEPTION <br> foreign key (EXCEPTION_STACK_ID_) <br> references ACT_GE_BYTEARRAY (ID_);<br> <br>create table ACT_HI_PROCINST (<br> ID_ nvarchar(64) not null,<br> PROC_INST_ID_ nvarchar(64) not null,<br> BUSINESS_KEY_ nvarchar(255),<br> PROC_DEF_ID_ nvarchar(64) not null,<br> START_TIME_ datetime not null,<br> END_TIME_ datetime,<br> DURATION_ numeric(19,0),<br> START_USER_ID_ nvarchar(255),<br> START_ACT_ID_ nvarchar(255),<br> END_ACT_ID_ nvarchar(255),<br> SUPER_PROCESS_INSTANCE_ID_ nvarchar(64),<br> COMPUTED_KEY_ AS ( CASE WHEN BUSINESS_KEY_ IS NULL THEN ID_ ELSE BUSINESS_KEY_ END )<br> primary key (ID_),<br> unique (PROC_INST_ID_)<br>);<br><br>create table ACT_HI_ACTINST (<br> ID_ nvarchar(64) not null,<br> PROC_DEF_ID_ nvarchar(64) not null,<br> PROC_INST_ID_ nvarchar(64) not null,<br> EXECUTION_ID_ nvarchar(64) not null,<br> ACT_ID_ nvarchar(255) not null,<br> ACT_NAME_ nvarchar(255),<br> ACT_TYPE_ nvarchar(255) not null,<br> ASSIGNEE_ nvarchar(64),<br> START_TIME_ datetime not null,<br> END_TIME_ datetime,<br> DURATION_ numeric(19,0),<br> primary key (ID_)<br>);<br><br>create table ACT_HI_TASKINST (<br> ID_ nvarchar(64) not null,<br> PROC_DEF_ID_ nvarchar(64),<br> TASK_DEF_KEY_ nvarchar(255),<br> PROC_INST_ID_ nvarchar(64),<br> EXECUTION_ID_ nvarchar(64),<br> NAME_ nvarchar(255),<br> PARENT_TASK_ID_ nvarchar(64),<br> DESCRIPTION_ nvarchar(4000),<br> OWNER_ nvarchar(64),<br> ASSIGNEE_ nvarchar(64),<br> START_TIME_ datetime not null,<br> END_TIME_ datetime,<br> DURATION_ numeric(19,0),<br> DELETE_REASON_ nvarchar(4000),<br> PRIORITY_ int,<br> DUE_DATE_ datetime,<br> primary key (ID_)<br>);<br><br>create table ACT_HI_DETAIL (<br> ID_ nvarchar(64) not null,<br> TYPE_ nvarchar(255) not null,<br> PROC_INST_ID_ nvarchar(64) not null,<br> EXECUTION_ID_ nvarchar(64) not null,<br> TASK_ID_ nvarchar(64),<br> ACT_INST_ID_ nvarchar(64),<br> NAME_ nvarchar(255) not null,<br> VAR_TYPE_ nvarchar(255),<br> REV_ int,<br> TIME_ datetime not null,<br> BYTEARRAY_ID_ nvarchar(64),<br> DOUBLE_ double precision,<br> LONG_ numeric(19,0),<br> TEXT_ nvarchar(4000),<br> TEXT2_ nvarchar(4000),<br> primary key (ID_)<br>);<br><br>create table ACT_HI_COMMENT (<br> ID_ nvarchar(64) not null,<br> TYPE_ nvarchar(255),<br> TIME_ datetime not null,<br> USER_ID_ nvarchar(255),<br> TASK_ID_ nvarchar(64),<br> PROC_INST_ID_ nvarchar(64),<br> ACTION_ nvarchar(255),<br> MESSAGE_ nvarchar(4000),<br> FULL_MSG_ image,<br> primary key (ID_)<br>);<br><br>create table ACT_HI_ATTACHMENT (<br> ID_ nvarchar(64) not null,<br> REV_ integer,<br> USER_ID_ nvarchar(255),<br> NAME_ nvarchar(255),<br> DESCRIPTION_ nvarchar(4000),<br> TYPE_ nvarchar(255),<br> TASK_ID_ nvarchar(64),<br> PROC_INST_ID_ nvarchar(64),<br> URL_ nvarchar(4000),<br> CONTENT_ID_ nvarchar(64),<br> primary key (ID_)<br>);<br><br>create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);<br>create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);<br>create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);<br>create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);<br>create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);<br>create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);<br>create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);<br>create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);<br>CREATE UNIQUE INDEX ACT_UNIQ_HI_BUS_KEY ON ACT_HI_PROCINST (PROC_DEF_ID_, COMPUTED_KEY_);<br><br>create table ACT_ID_GROUP (<br> ID_ nvarchar(64),<br> REV_ int,<br> NAME_ nvarchar(255),<br> TYPE_ nvarchar(255),<br> primary key (ID_)<br>);<br><br>create table ACT_ID_MEMBERSHIP (<br> USER_ID_ nvarchar(64),<br> GROUP_ID_ nvarchar(64),<br> primary key (USER_ID_, GROUP_ID_)<br>);<br><br>create table ACT_ID_USER (<br> ID_ nvarchar(64),<br> REV_ int,<br> FIRST_ nvarchar(255),<br> LAST_ nvarchar(255),<br> EMAIL_ nvarchar(255),<br> PWD_ nvarchar(255),<br> PICTURE_ID_ nvarchar(64),<br> primary key (ID_)<br>);<br><br>create table ACT_ID_INFO (<br> ID_ nvarchar(64),<br> REV_ int,<br> USER_ID_ nvarchar(64),<br> TYPE_ nvarchar(64),<br> KEY_ nvarchar(255),<br> VALUE_ nvarchar(255),<br> PASSWORD_ image,<br> PARENT_ID_ nvarchar(255),<br> primary key (ID_)<br>);<br><br>alter table ACT_ID_MEMBERSHIP <br> add constraint ACT_FK_MEMB_GROUP <br> foreign key (GROUP_ID_) <br> references ACT_ID_GROUP (ID_);<br><br>alter table ACT_ID_MEMBERSHIP <br> add constraint ACT_FK_MEMB_USER <br> foreign key (USER_ID_) <br> references ACT_ID_USER (ID_);<br> <br>– OPTIONAL USER <br>INSERT INTO ACT_ID_USER VALUES ('bandy','1','bandy','bandy','gibsosmat@example.com','bandy',NULL);<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('admin','1','Admin','security-role');<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('engineering','1','Engineering','assignment');<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('management','1','Management','assignment');<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('marketing','1','Marketing','assignment');<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('sales','1','Sales','assignment');<br>INSERT INTO ACT_ID_GROUP (ID_,REV_,NAME_,TYPE_) VALUES ('user','1','User','security-role');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','admin');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','engineering');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','management');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','marketing');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','sales');<br>INSERT INTO ACT_ID_MEMBERSHIP VALUES ('bandy','user');<br>
