cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Call atom in B1IF

former_member390407
Contributor
0 Kudos

Dear colleagues!

I use SAP Business One Integration Framework version 1.22.10. I'm developing a scenario which prepare data and insert ot to the SQL data storage. So, here is the question: is it possible to cache an opened SQL connection to use it in SQL Call atoms in for-each flow, or those atoms will always open and close SQL connections when they are called?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

For all adapter calls (http, sql, ...) it is the same concept. A connection stays open, so also for JDBC calls. Means not only in this particular instance flow in for-each, but for all message-processings of this step and even for other scenario steps that are using the same connection.

If you want to optimize the described processing, please check if its possible to compile all sql-statements in 1 xform atom (concatinated by 😉 and after the xform, just have 1 jdbc call to handover all sql statements together. This avoids the for-each construct and multiple adpater calls.

Answers (0)