Batch Processing with Transaction Types

, ,
1

Hi Team,

Can anyone help me understand if we can use BatchInsert or BatchUpdate with the Transaction type as NO transaction in the connection configuration.

Thanks in advance.

2

Hi Priyanka,

this will not be possible.

From the JDBC Adapter Users Guide:


Note: For BatchInsertSQL services, you must use a LOCAL_TRANSACTION
connection. If you do not use LOCAL_TRANSACTION, you will not see a list of
tables in the Tables tab. Also, you may not see an error message until you reload
metadata values or check the error log. For instructions for creating a
LOCAL_TRANSACTION connection, see “Configuring JDBC Adapter Connections”
on page 79. For information about reloading metadata values, see “Reloading
Adapter Values” on page 146.

Note: For BatchUpdateSQL services, you must use a LOCAL_TRANSACTION
connection. If you do not use LOCAL_TRANSACTION, you will not see a list of
tables in the Tables tab. Also, you may not see an error message until you reload
metadata values or check the error log. For instructions for creating a
LOCAL_TRANSACTION connection, see “Configuring JDBC Adapter Connections”
on page 79. For information about reloading metadata values, see “Reloading
Adapter Values” on page 146.

Regards,
Holger

3

No and you have to depend on LOCAL_TRANSACTION AS connection as it involves these templates internally deal transactional based commit/rollback.

HTH,
RMG