Jdbc insert snap account as auto commit is enabled
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2023 02:45 AM
Hi,
The pipeline sends the record to JDBC INSERT snap, under JDBC INSERT Snap account has auto commit is enabled and batch size is 60. if 180 records are streamed into JDBC INSERT Snap and there was an error in 140th record, how many records JDBC INSERT SNAP sending?
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2023 03:25 AM
anyone can please respond on these.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2023 03:44 AM
Hi,
Only the current executing batch will be rolled back if the Snap fails. In another words in your case it will be inserted 120 records.
You can always check the official documentation:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2391441629/Generic+Database+Account
BR,
Pero M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2023 04:04 AM
thank you @pmancevski
