My question is very simple. Is there a way to configure a JDBC action connector to call a database stored procedure? It seems quite strange to me that doing this is so straight forward with JDBC event connector but not possible with it's 'action' brother...
If it's not possible, what workaround would you suggest? Using select/insert/update JDBC action connectors can not be the way, my JDBC action should involve several queries.
I'm on WODM 8.0. The data source I'm needing to call the procedure on refers to a MySQL database.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
4 replies Latest Post - 2013-01-08T11:55:01Z by WBE
Pinned topic JDBC action connector calling a procedure
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-08T11:55:01Z at 2013-01-08T11:55:01Z by WBE
WBE 11000073WC99 Posts
Re: JDBC action connector calling a procedure2013-01-08T11:50:37Z in response to WBEOk, thanks for the answer. I'll find another way.
Do you think procedure call JDBC action connector will be implemented in future releases? IMHO its missing is quite a flaw, do you agree?