6 Replies Latest reply on Sep 11, 2013 4:03 PM by jane_lj

    PreparedStatement.executBatch()

    jane_lj Novice

      Hi,

       

      We have the View Model VDB which created in Teiid Designer deployed into Teiid JBoss server, this VDB supports the updates feature by writing FOR EACH ROW procedure for INSERT.

       

      When we test the INSERT, we want to insert 2 rows, so we use PreparedStatement.executBatch() against this VM VDB, but we found my translator got two calls for INSERT, not one batch INSERT call.

       

      Looks like Teiid Designer transformation procedure splits the batch all into 2 INSERT calls, is that true?

       

      If yes, how to make the procedure send the batch INSERT call to my translator, not split them?

       

      Thanks.