1
0
-1

i am reading the developer guide Store Form Field Data to Multiple Tables

i would like to know if the Bean Shell Form Binder will manage the transaction to multiple tables? in this guide, there are three tables to store, including:

workflow form binder :store to 

form data: store to form id "user"

JDBC: store to dir_user

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I believe it is transactional but it might depend on the configuration of the underlying database. Did you try it out? If you really need to, you could try the solution in How can I create a DB Transaction with Joget BeanShell Script.

      1. nxliu

        thanks, i understand your solution to set transaction by code , but we may encounter some cases need to reuse form binder to store data  as in the developer guide Store Form Field Data to Multiple Tables .

        transaction is hard to try, only in rare cases like network down or database down after first table update succeed, so i would like to know if there is quick answer here 

      CommentAdd your comment...