IBM Sterling Transformation Extender

 View Only

 JDBC Connection

Akhi Singh's profile image
Akhi Singh posted Thu August 28, 2025 05:06 PM
Can I reuse one JDBC connection to run multiple SQL statements in an ITX Map?
 
The requirement is to first run a select query. Based on the results of this query and the source input, we need to insert several entries into a table. Once these inserts are completed, we must update the status in another table.
Rex Chan's profile image
Rex Chan posted Sat August 30, 2025 03:12 PM

There is no setting for JDBC connection. Connection pool is shared by concurrent threads.  So I don't know if ITX can guarantee the same connection.

However there is a map setting for each output card.  By default it's "Map".  The other option is "Card".

With "Map", a failed operation will result in a rollback with all the output cards in the map.

Here is the link regarding the scope option.

https://www.ibm.com/docs/en/ste/11.0.2?topic=settings-scope

Related Content