+11in my fmw file there are many number of rows updating using database transformer. after thousands of rows fme hangs and not responding. i suspect this happens because database updater not comming after some interval i think. how to pass the value for commit transaction. or did database updater committing by default after some rows?
please tell me how to pass the commit/ transaction value to database updater ?
Best answer by david_r
I'm not sure that's possible. But you could consider using a Sampler to sample "away" the first N features and then pass only the NotSampled to the DatabaseUpdater.
I'm not sure that's possible. But you could consider using a Sampler to sample "away" the first N features and then pass only the NotSampled to the DatabaseUpdater.
+11@david_r But how sampler will help me. I wanted after 2000 rows updates , there should be commit.
Perhaps you wanted to increase the commit interval from 1000 to 2000?
As far as I can tell, that's not possible using the DatabaseUpdater.
+1While I'm not sure about the source of the hang, I can confirm that the transaction size is not controllable within the DatabaseUpdater transformer (the Oracle writer has a default transaction size of 1000 features, for what it's worth). Please Report a Problem and reference PR#80690 to be notified of improvements to the DatabaseUpdater interface.
To gain access to advanced writer settings like transaction size, consider replacing your DatabaseUpdater with a regular Oracle writer, set to UPDATE mode.
If the hang still persists I recommend filing a bug report with as much data, workspaces, and log files that you can share.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
