cancel
Showing results for 
Search instead for 
Did you mean: 

Support for Sybase Database

hrabe
Champ in-the-making
Champ in-the-making
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.
11 REPLIES 11

hrabe
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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.