Hi All,
Would it be a good idea to introduce the update functionality to the JDBC
output operator in Apache Apex Malhar library.
The following are possible approaches:
1. Accept a update query from the user with place holders for values.
Example: *update tableName set a = ?, b = ? where c = ? and d > ?*. Here
"?" will be provided by the user as java expressions which will be
evaluated from the incoming tuple.
2. Another option is to accept in some configuration format (json / xml)
the following and formulate the query in the operator. This can become
arbitrarily complex.
1. update clause columns
2. update clause expressions
3. where clause columns
4. where clause expressions
I am thinking about going ahead with 1. Please let me know if any other
option is possible and whether such a functionality already exists in some
other class.
Thanks.
-Bhupesh
