Questions tagged [batch-updates]

171 questions
19
votes
3 answers

Swift Core Data Batch Updating creating duplicate records instead of overwriting

It seems like my NSPredicate isn't working when updating Core Data records. When doing a fetch request, the same NSPredicate works with no issues. When I do a Batch Update, it just creates new duplicate records instead of overwriting the existing…
The Nomad
  • 7,155
  • 14
  • 65
  • 100
10
votes
1 answer

REDIS/jedis update scores of all members in a sorted set

What's the best way to increment a medium size sorted set in REDIS? (Preferably with java driver JEDIS) Set has about 100-200K records in it. I want to increment their score by a given double number. before 1 a 2 b 3 c after (increment by 1) 2 a 3…
Onur Günduru
  • 451
  • 4
  • 14
8
votes
4 answers

How to store java.util.ArrayList in Postgresql using Spring

I am trying to do a batch-insert of a collection of beans. One of the properties of the bean is an ArrayList. The batch update fails with the exception: Can't infer the SQL type to use for an instance of java.util.ArrayList. Use setObject() with an…
Mono Jamoon
  • 4,437
  • 17
  • 42
  • 64
8
votes
1 answer

Verifying success for spring JDBC batch update

I am using Spring JDBCTemplate batchUpdate to insert data in a batch. I want to verify if the data is successfully inserted. JDBCTemplate batchUpdate returns an int[][], so which is the right way to verify that the data is inserted? This link says…
Ayushi
  • 405
  • 1
  • 9
  • 19
7
votes
0 answers

Collection view cells won't reload after move

I am using a UICollectionView to display players in various positions on a field. Each cell contains labels showing the player's name and the position name. The locations in the view are determined by a custom layout that reads the position…
7
votes
2 answers

INSERT Batch, and if duplicate key Update in codeigniter

Is there any way of performing in batch Insert query and if the key already exists, UPDATE that row in codeigniter? I have gone through the documentation and found only insert_batch and update_batch. But how to update the row with duplicate key in…
Sandesh Sharma
  • 1,064
  • 5
  • 16
  • 32
6
votes
2 answers

Spring JdbcTemplate batchUpdate handling exceptions

Currently our code uses batchUpdate method of JdbcTemplate to do batch Insertion. My question is in case of any exception in one of the update how to handle it (suppose just by adding the log) and continue with the next update sql statements? Also…
minil
  • 6,895
  • 16
  • 48
  • 55
6
votes
3 answers

What does this BatchUpdateException mean?

I'm getting this BatchUpdateException from a stmt.executeBatch() statement: BatchUpdateException: A resultset was created for update The internet does not have any information on this exception message. What does it mean? The traceback doesn't…
Björn Lindqvist
  • 19,221
  • 20
  • 87
  • 122
5
votes
1 answer

Does executeBatch() also clear the list of commands?

The documentation of Statement.executeBatch() is not clear on this, but I assume that calling it will empty the Statement object's current list of SQL commands in the same way as clearBatch() does. I'm also assuming the same is true for…
Roland
  • 7,525
  • 13
  • 61
  • 124
5
votes
3 answers

What's the formula for Welford's Algorithm for Variance/Std with Batch Updates?

I want to extend Welford's online algorithm to be able to be updated with multiple numbers (in batch) instead of just one at a time: https://en.wikipedia.org/wiki/Algorithms_for_calculating_variance I tried to update the algorithm from the wiki page…
Seb
  • 370
  • 2
  • 14
5
votes
2 answers

How to update multiple cells via the Google Sheets API?

I'm trying to update and get some results from google sheets, it's working but slow. I need to batchUpdate and get the data. This is my script foreach ($import_cels as $celu => $valoare) { $range_ins = $celu; $valueRange->setValues(["values"…
Malasuerte94
  • 1,454
  • 3
  • 14
  • 18
5
votes
0 answers

Section headers "bounce" when UITableView is reloaded

I have a UITableView which under goes a batch update when the state of app changes. The change can effect a number of rows/sections or only one section (but 1 or more rows). I've noticed that when under going a single section update (which may…
MadProgrammer
  • 343,457
  • 22
  • 230
  • 366
5
votes
1 answer

Ember Data bulk saves to server

Ember Data is moving fast from version to version and the method for saving data has been changing along with it. Right now with version 1.0.0-beta.8.2a68c63a the proper method is to update a record and then do a record.save() to trigger a PUT…
Cory Schulz
  • 319
  • 5
  • 15
4
votes
1 answer

batch updates using Entity Framework

Can anyone suggest me how to deal with batch updates using Entity Framework? For ex: Updating a field for a list (List) of between 100 and 1000 Id's, which the primary key. Calling each update separately seem to be to much overhead and takes a long…
3
votes
5 answers

C# batch update to database using Stored Procedure

I want to run my update stored procedure to update just two columns in a table(this table is having many other columns as well). Currently I have implemented as follows - foreach (Object obj in customCollection) { string[] updatedValues =…
inutan
  • 10,558
  • 27
  • 84
  • 126
1
2 3
11 12