-
1. Re: JDBC Translator | Queries on batch commit and Update Count
shawkins Dec 23, 2014 8:07 AM (in response to shiveeta.mattoo)1 of 1 people found this helpful> 1. Segregation of batch execution and commit mode in JDBC Translator
Without an enhancement or a significant translator override, you'd have to proxy your driver to control the setAutoCommit and batch logic.
> Is there any specific reason to perform this? Can we change this to stick to the expected standard behaviour?
I think the code there is simply out of date. It should handle the batch case differently, can you log an issue?
-
2. Re: JDBC Translator | Queries on batch commit and Update Count
shiveeta.mattoo Dec 23, 2014 8:50 AM (in response to shawkins)Thank you Steven for prompt response.
>1. We are integrating with multiple databases, so proxying each and every driver may not work out very well for our use-case.
>2. I will log the issue for the Update count behaviour. Would it also be addressing the segregation of batch execution and commit as part of the batch code refactor ?
-
3. Re: JDBC Translator | Queries on batch commit and Update Count
shiveeta.mattoo Dec 24, 2014 6:59 AM (in response to shiveeta.mattoo)Please confirm if I should log issue only for update Count behaviour or also on the batch execution and commit segregation.
Thanks a lot for your help.
-
4. Re: JDBC Translator | Queries on batch commit and Update Count
shawkins Dec 27, 2014 6:36 PM (in response to shiveeta.mattoo)You can a bug for the update count and an enhancement request for the commit behavior.
-
5. Re: JDBC Translator | Queries on batch commit and Update Count
shiveeta.mattoo Dec 28, 2014 11:32 AM (in response to shawkins)Thank you Steven. Will log the same.