Jdbc Adapter Update with restrictions

, ,
1

Hi,
I’d like to create a JDBC UPDATE adapter capable of updating only the input fields that are different from null. In this way it would be possible to reuse the adapter in different situations… I know it sound strange and maybe it’s not a programming best pratice but would WM able to do it?
Is it possible to perform this operation with a standard update or do I need to create a dynamic adapter?

Thanks!!
Fabrizio

2

You would need to create a dynamic adapter as you then have complete control over the SQL. The update adapter would update update each field you define in the adapter regardless if it is null or not. The other possibilty is to create a stored procedure and invoke that.