cancel
Showing results for 
Search instead for 
Did you mean: 

Proxy2JDBC: Unable to create double Delete-Statement when new value occurs

Former Member
0 Kudos

Hi, we hav a JDBC-Receiver channel where we have following structure:

<Statement1> (will be an Insert)

<Statement21> (Delete Statement 2 with key Statement1.field1)

<Statement31> (Delete Statement 3 with key Statement1.field1)

<Statement41> (Delete Statement 4 with key Statement1.field1)

<Statement51> (Delete Statement 5 with key Statement5.field2)

<Statement2>

<Statement3>

<Statement4>

<Statement5>

where the <Statement51>(Delete Statement 5 with key Statement5.field2) is the hard one because i have no idea on how to do this mapping. For each occurance of Statement5.field2 a single Delete-Statement <Statement51> shuld be created.

Can someone help please?!

br

P.S. UPDATE_INSERT is not working properly, therefore these single Statements for Insert & Delete!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Solved

stefan_grube
Active Contributor
0 Kudos

Without knowing the source payload, it is not possible to give you advise.