Often times I'm updating a large amount of records with a batch SQL script, and a lot of times I run into this error: DataIntegrityViolationException: Prepared or callable statement has more than 2000 parameter.
So to help me to update with only the allowed number of parameters I've created a method that will split a List of objects into sublists based on the max number of records you want. And then I would pass each sublist to the batch update method.
nice example and visit http://www.javaproficiency.com/2015/05/java-arraylist-examples.html
ReplyDeleteYou are probably an expert in this field, I just recently began to study the topic of programming. It turned out to be not so complicated. But still this deal requires patience and attention. For me, I found a good informative blog, which reveals the whole point about how to split a string in java https://explainjava.com/split-string-java/. It really helped me. Information on the Internet is too much, among the garbage, I managed to find a really valuable manuscript.
ReplyDeleteThank you very much !
ReplyDelete