Dear all, I am trying to update some columns in a DB using a Query Da

octavianp over 9 years ago

Dear all,

I am trying to update some columns in a DB using a Query Database Smart Service Task and I need to use the IN wildcard for the WHERE clause. Typically in my mind it should look like this UPDATE mytable SET row = 0 WHERE id IN (ac!oneVariable). The ac!oneVariable is a number(integer) MULTIPLE came from a process variable updated in a User Task. By implementing the above mentioned approach I get some weird alerts which I think are generated from hibernate : There was a problem executing the SQL query. SQL Message : [Ljava.lang.Long; cannot be cast to java.lang.Long Problem: An error occurred in executing an Activity Class.

I also tried to "inject" the contents of the pv!oneVariable in a text activity class having value: joinarray(pv!oneVariable, '","') but without any success.

Could you please help me with the best practices with this regard?

Thanks in advance,
Octavian

Discussion posts and replies are publicly visible

Parents

0 sureshrk over 9 years ago

1. Create Process Variable
idList(Text, Multiple)

2. Create Activity Variable
ac!ids(Text)

3. Set activity Variable(ac!ids) to below definition
= "," & joinarray (pv!idList, ",") & ","

4. Add Query like one below
SELECT idColumn, nameColumn, descColumn FROM table1 WHERE INSTR(ac!ids, CONCAT(',', idColumn, ',')) > 0

5. Use the same logic (where clause) for update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sureshrk over 9 years ago

1. Create Process Variable
idList(Text, Multiple)

2. Create Activity Variable
ac!ids(Text)

3. Set activity Variable(ac!ids) to below definition
= "," & joinarray (pv!idList, ",") & ","

4. Add Query like one below
SELECT idColumn, nameColumn, descColumn FROM table1 WHERE INSTR(ac!ids, CONCAT(',', idColumn, ',')) > 0

5. Use the same logic (where clause) for update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data