on 11-08-2017 10:07 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.