nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Support for Sybase Database

hrabe

fyi, start with sybase support following http://docs.codehaus.org/display/ACT/How+to+add+support+for+new+databases guidlines. I'm in contact with Bernd Rücker to provide CI asap.

Find more posts tagged with

Comments

hrabe

Who had the idea of a unique constraint on a nullable column? For each database there is a given workaround expect Sybase.

frederikherema1

Wich column are you reffering to?

hrabe

searching for workaround for h2 expression

alter table ACT_RU_EXECUTION
    add constraint ACT_UNIQ_RU_BUS_KEY
    unique(PROC_DEF_ID_, BUSINESS_KEY_);

alter table ACT_HI_PROCINST
    add constraint ACT_UNIQ_HI_BUS_KEY
    unique(PROC_DEF_ID_, BUSINESS_KEY_);

hrabe

Found a solution for Sybase 15:

create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION
(case when BUSINESS_KEY_ is null then ('pk-' + ID_) else ('bk-' + BUSINESS_KEY_) end, PROC_DEF_ID_);

But next problem raises on ant task 'create.db.schema' cause of the sql autocommit default which is false. Sybase can not create a functional index on a multi-statement transaction. The autocommit could be set over the specific db properties file which can lead to an undefined db state if one transaction cause an error.

The CycleDbSqlSessionFactory#dbSchemaCreate() must also be able to switch the autocommit mode.

Another option is to use mutiple sql files each executes in one transaction.

Feedback?

bernd_ruecker

By the way: The same problem one of our customers experienced on Informix. The nullable but unique business key seems to get a problem on some databases…

The Autocommit-Mode sounds reasonable 🙂

hrabe

Scripts for Sybase 15

activiti.sybase.create.sql

<br>create table ACT_GE_PROPERTY (<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; VALUE_ varchar(300) NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; primary key (NAME_)<br>);<br><br>insert into ACT_GE_PROPERTY<br>values ('schema.version', '5.1', 1);<br><br>insert into ACT_GE_PROPERTY<br>values ('schema.history', 'create(5.1)', 1);<br><br>insert into ACT_GE_PROPERTY<br>values ('next.dbid', '1', 1);<br><br>create table ACT_GE_BYTEARRAY (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DEPLOYMENT_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; BYTES_ image NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RE_DEPLOYMENT (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DEPLOY_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RU_EXECUTION (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; BUSINESS_KEY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; PARENT_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ varchar(64)&nbsp; NULL,<br>&nbsp;&nbsp;&nbsp; SUPER_EXEC_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; ACT_ID_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; IS_ACTIVE_ bit,<br>&nbsp;&nbsp;&nbsp; IS_CONCURRENT_ bit,<br>&nbsp;&nbsp;&nbsp; IS_SCOPE_ bit,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RU_JOB (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; TYPE_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; LOCK_EXP_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; LOCK_OWNER_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; EXCLUSIVE_ bit,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PROCESS_INSTANCE_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; RETRIES_ integer NULL,<br>&nbsp;&nbsp;&nbsp; EXCEPTION_STACK_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; EXCEPTION_MSG_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DUEDATE_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; REPEAT_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; HANDLER_TYPE_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; HANDLER_CFG_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_ID_GROUP (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; TYPE_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_ID_MEMBERSHIP (<br>&nbsp;&nbsp;&nbsp; USER_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; GROUP_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; primary key (USER_ID_, GROUP_ID_)<br>);<br><br>create table ACT_ID_USER (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; FIRST_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; LAST_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; EMAIL_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; PWD_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RE_PROCDEF (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; CATEGORY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; KEY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; VERSION_ integer NULL,<br>&nbsp;&nbsp;&nbsp; DEPLOYMENT_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; RESOURCE_NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DGRM_RESOURCE_NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; HAS_START_FORM_KEY_ bit,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RU_TASK (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DESCRIPTION_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; TASK_DEF_KEY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; ASSIGNEE_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PRIORITY_ integer NULL,<br>&nbsp;&nbsp;&nbsp; CREATE_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RU_IDENTITYLINK (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; GROUP_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; TYPE_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; USER_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; TASK_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_RU_VARIABLE (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer&nbsp; NULL,<br>&nbsp;&nbsp;&nbsp; TYPE_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; TASK_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; BYTEARRAY_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; DOUBLE_ float NULL,<br>&nbsp;&nbsp;&nbsp; LONG_ numeric&nbsp; NULL,<br>&nbsp;&nbsp;&nbsp; TEXT_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; TEXT2_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_HI_PROCINST (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; BUSINESS_KEY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; START_TIME_ datetime NOT NULL,<br>&nbsp;&nbsp;&nbsp; END_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; DURATION_ numeric NULL,<br>&nbsp;&nbsp;&nbsp; START_USER_ID_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; START_ACT_ID_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; END_ACT_ID_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_),<br>&nbsp;&nbsp;&nbsp; unique (PROC_INST_ID_)<br>);<br><br>create table ACT_HI_ACTINST (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; ACT_ID_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; ACT_NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; ACT_TYPE_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; ASSIGNEE_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; START_TIME_ datetime NOT NULL,<br>&nbsp;&nbsp;&nbsp; END_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; DURATION_ numeric NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_HI_TASKINST (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; TASK_DEF_KEY_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; DESCRIPTION_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; ASSIGNEE_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; START_TIME_ datetime NOT NULL,<br>&nbsp;&nbsp;&nbsp; END_TIME_ datetime NULL,<br>&nbsp;&nbsp;&nbsp; DURATION_ numeric NULL,<br>&nbsp;&nbsp;&nbsp; DELETE_REASON_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br><br>create table ACT_HI_DETAIL (<br>&nbsp;&nbsp;&nbsp; ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; TYPE_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ varchar(64) NOT NULL,<br>&nbsp;&nbsp;&nbsp; TASK_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; ACT_INST_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; NAME_ varchar(255) NOT NULL,<br>&nbsp;&nbsp;&nbsp; VAR_TYPE_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; REV_ integer NULL,<br>&nbsp;&nbsp;&nbsp; TIME_ datetime NOT NULL,<br>&nbsp;&nbsp;&nbsp; BYTEARRAY_ID_ varchar(64) NULL,<br>&nbsp;&nbsp;&nbsp; DOUBLE_ float NULL,<br>&nbsp;&nbsp;&nbsp; LONG_ numeric NULL,<br>&nbsp;&nbsp;&nbsp; TEXT_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; TEXT2_ varchar(255) NULL,<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<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 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><br>alter table ACT_GE_BYTEARRAY<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_BYTEARR_DEPL<br>&nbsp;&nbsp;&nbsp; foreign key (DEPLOYMENT_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RE_DEPLOYMENT;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_EXE_PROCINST<br>&nbsp;&nbsp;&nbsp; foreign key (PROC_INST_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_EXE_PARENT<br>&nbsp;&nbsp;&nbsp; foreign key (PARENT_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_EXE_SUPER<br>&nbsp;&nbsp;&nbsp; foreign key (SUPER_EXEC_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_ID_MEMBERSHIP<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_MEMB_GROUP<br>&nbsp;&nbsp;&nbsp; foreign key (GROUP_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_ID_GROUP;<br><br>alter table ACT_ID_MEMBERSHIP<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_MEMB_USER<br>&nbsp;&nbsp;&nbsp; foreign key (USER_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_ID_USER;<br><br>alter table ACT_RU_IDENTITYLINK<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_TSKASS_TASK<br>&nbsp;&nbsp;&nbsp; foreign key (TASK_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_TASK;<br><br>alter table ACT_RU_TASK<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_TASK_EXE<br>&nbsp;&nbsp;&nbsp; foreign key (EXECUTION_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_TASK<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_TASK_PROCINST<br>&nbsp;&nbsp;&nbsp; foreign key (PROC_INST_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_TASK<br>&nbsp; add constraint ACT_FK_TASK_PROCDEF<br>&nbsp; foreign key (PROC_DEF_ID_)<br>&nbsp; references ACT_RE_PROCDEF;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_VAR_EXE<br>&nbsp;&nbsp;&nbsp; foreign key (EXECUTION_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_VAR_PROCINST<br>&nbsp;&nbsp;&nbsp; foreign key (PROC_INST_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_RU_EXECUTION;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_VAR_BYTEARRAY<br>&nbsp;&nbsp;&nbsp; foreign key (BYTEARRAY_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_GE_BYTEARRAY;<br><br>alter table ACT_RU_JOB<br>&nbsp;&nbsp;&nbsp; add constraint ACT_FK_JOB_EXCEPTION<br>&nbsp;&nbsp;&nbsp; foreign key (EXCEPTION_STACK_ID_)<br>&nbsp;&nbsp;&nbsp; references ACT_GE_BYTEARRAY;<br><br>create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION<br>&nbsp; (case when BUSINESS_KEY_ is null then ('pk-' + ID_) else ('bk-' + BUSINESS_KEY_) end, PROC_DEF_ID_);<br><br>create unique index ACT_UNIQ_HI_BUS_KEY on ACT_HI_PROCINST<br>&nbsp;&nbsp; (case when BUSINESS_KEY_ is null then ('pk-' + ID_) else ('bk-' + BUSINESS_KEY_) end, PROC_DEF_ID_);<br>

activiti.sybase.drop.sql

<br>drop index ACT_RU_EXECUTION.ACT_IDX_EXEC_BUSKEY;<br>drop index ACT_RU_TASK.ACT_IDX_TASK_CREATE;<br>drop index ACT_RU_IDENTITYLINK.ACT_IDX_IDENT_LNK_USER;<br>drop index ACT_RU_IDENTITYLINK.ACT_IDX_IDENT_LNK_GROUP;<br>drop index ACT_HI_PROCINST.ACT_IDX_HI_PRO_INST_END;<br>drop index ACT_HI_PROCINST.ACT_IDX_HI_PRO_I_BUSKEY;<br>drop index ACT_HI_ACTINST.ACT_IDX_HI_ACT_INST_START;<br>drop index ACT_HI_ACTINST.ACT_IDX_HI_ACT_INST_END;<br>drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_PROC_INST;<br>drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_ACT_INST;<br>drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_TIME;<br>drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_NAME;<br><br>alter table ACT_GE_BYTEARRAY<br>&nbsp; drop constraint ACT_FK_BYTEARR_DEPL;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp; drop constraint ACT_FK_EXE_PROCINST;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp; drop constraint ACT_FK_EXE_PARENT;<br><br>alter table ACT_RU_EXECUTION<br>&nbsp; drop constraint ACT_FK_EXE_SUPER;<br><br>alter table ACT_ID_MEMBERSHIP<br>&nbsp; drop constraint ACT_FK_MEMB_GROUP;<br><br>alter table ACT_ID_MEMBERSHIP<br>&nbsp; drop constraint ACT_FK_MEMB_USER;<br><br>alter table ACT_RU_IDENTITYLINK<br>&nbsp; drop constraint ACT_FK_TSKASS_TASK;<br><br>alter table ACT_RU_TASK<br> drop constraint ACT_FK_TASK_EXE;<br><br>alter table ACT_RU_TASK<br> drop constraint ACT_FK_TASK_PROCINST;<br><br>alter table ACT_RU_TASK<br> drop constraint ACT_FK_TASK_PROCDEF;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp; drop constraint ACT_FK_VAR_EXE;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp; drop constraint ACT_FK_VAR_PROCINST;<br><br>alter table ACT_RU_VARIABLE<br>&nbsp; drop constraint ACT_FK_VAR_BYTEARRAY;<br><br>alter table ACT_RU_JOB<br>&nbsp; drop constraint ACT_FK_JOB_EXCEPTION;<br><br>drop table ACT_GE_PROPERTY;<br>drop table ACT_GE_BYTEARRAY ;<br>drop table ACT_RE_DEPLOYMENT;<br>drop table ACT_RU_EXECUTION;<br>drop table ACT_ID_GROUP;<br>drop table ACT_ID_MEMBERSHIP;<br>drop table ACT_ID_USER;<br>drop table ACT_RU_JOB;<br>drop table ACT_RE_PROCDEF;<br>drop table ACT_RU_TASK;<br>drop table ACT_RU_IDENTITYLINK;<br>drop table ACT_RU_VARIABLE;<br>drop table ACT_HI_PROCINST;<br>drop table ACT_HI_ACTINST;<br>drop table ACT_HI_TASKINST;<br>drop table ACT_HI_DETAIL;<br>

To support these scripts is it necessary to add autocommit="true" at sql on target name="create.db.schema"

transconnect

Hi all,

I have ported activiti 5.5 to Sybase Adaptive Server Anywhere (>= Rel 9). But i'm not familar with Maven and though a have not followed the tips explained in the wiki. If subject of interest, I can post these scripts here.

But my problem was, that the Sybase JDBC driver jConnect does not Support JDBC-conform BLOB/CLOB access.
Though I have changed all mybatis mappings like that:

<br>jdbcType=BLOB, typeHandler=org.apache.ibatis.type.ByteArrayTypeHandler<br>
Another problem is, that the used alias name membership refers to a reserved word. Though I have changed this to membershp to solve the problem.

In the global mappings.xml I have added the type handlers

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <typeHandlers><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <typeHandler javaType="_byte[]" jdbcType="LONGVARBINARY" handler="org.apache.ibatis.type.ByteArrayTypeHandler"/><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <typeHandler javaType="string"&nbsp; jdbcType="LONGVARCHAR"&nbsp;&nbsp; handler="org.apache.ibatis.type.StringTypeHandler"/><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </typeHandlers><br>

With best regards, Torsten

hrabe

Patches for version 5.5 attached to http://jira.codehaus.org/browse/ACT-726

@Torsten
- How you solve the constraint problem with nullable columns?
- How you find the problem with the reserved key word membership? All maven tests run successfully on sybase.

I used the sybase sql type image instead of blob/clob. So no changes to the mapping are necessary.

transconnect

Hi hrabe,

How you solve the constraint problem with nullable columns?

No problem on ASA using
create index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_);create index ACT_UNIQ_HI_BUS_KEY on ACT_HI_PROCINST (PROC_DEF_ID_, BUSINESS_KEY_);

How you find the problem with the reserved key word membership? All maven tests run successfully on sybase.

After startup, some action (I think the deployment of BARs) failed with an error message pointing to a problem with reserved words.

I used the sybase sql type image instead of blob/clob. So no changes to the mapping are necessary.

I used also Image-Type in the database column in ASA. But the mybatis configuration uses Blob/Clob, the jConnect driver does not support. Dou You have used jConnect or jTDS? On ASA jTDS does not work, only jConnect.

hrabe

No problem on ASA using
create index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_);create index ACT_UNIQ_HI_BUS_KEY on ACT_HI_PROCINST (PROC_DEF_ID_, BUSINESS_KEY_);

You have to a use unique index. So you did not solve the constraint problem with nullable columns.

How you find the problem with the reserved key word membership?

Membership is only on ASA a reserved keyword not on ASE.

jConnect driver does not support

I used jTDS. On ASE jTDS works.

Do you need to use ASA?

transconnect

Hi hrabe,

You have to a use unique index. So you did not solve the constraint problem with nullable columns.

You are right, this is not accurate. But I have assumed, Activiti works fine on other DBs, though the Java code is working and no unique constraint violation will occur.

Do you need to use ASA?

Yes, we have OEMed that DB in our products.