Stack Overflow
Stack Overflow

Questions tagged [batch-updates]

171 questions
0
votes
1 answer

How to execute multiple update queries using jooq execute or batch execute without code generation?

I am using JOOQ ( 3.10. 5 ) to update records in ORACLE table without jooq auto code generation in below ways Approach 1- Using DSL execute by using plain SQL String dslContext.execute("update author set first_name = 'updateTest-111111' where id = 1…
codiacTushki
  • 750
  • 1
  • 9
  • 22
0
votes
0 answers

How do I force Windows Update to get Updates from Microsoft via a bat or vbs file

I'm a Tier 1 remote tech for a large company. Our Windows PC s are managed and updates are pushed to users. These updates are verified secured via a 3rd party before they are sent to users. This often means that users only get major updates and…
Shadowheart411
  • 25
  • 3
0
votes
2 answers

Batch Update Bigquery results into google sheets(about 50k results)

I am trying to use Script editor(Apps script) to stream BigQuery results into google sheets. I'm following these [document][1] . The issue I have, the data doesn't load fully, it hangs. I have a large number of rows(more than 12 rows). I think I…
user17243359
  • 55
  • 6
0
votes
0 answers

JAVA SQL Batch updates best way

I have a service that updates multiple tables through multiple services with in a transaction boundary, if one of them fails everything need to be rolled back. One of these SQL update has around 2k+ records to update and its done in two batches 1000…
SBB
  • 17
  • 1
  • 8
0
votes
0 answers

update query in a for loop using batch updates and threads

i have the following code. it fetch data from a table in database.then for each item in that data list it checks a condition and base on that updates a column in that table. i know batch updates will help in such situations. and also async…
reza
  • 27
  • 7
0
votes
1 answer

Python + Google Sheet | How to Update specific cells

I'm learning how to use Google Sheet API and Python. Firstly, I need to update specific cells in Google Sheet, not a range of cells. I could use update_cell(), but each update will take up a Write Request, which is not…
user2741620
  • 305
  • 2
  • 7
  • 21
0
votes
0 answers

Update, Insert and delete in one spring boot PUT Request jdbcTemplate

In a Put Request the JSON file should be checked for all entries and this should be compared with the database. I have a variable that has the last database entry, e.g. the database has two entries, but there are three entries in the JSON file. In…
DevQuixel
  • 1
0
votes
0 answers

Tensorflow. Batch Tensor modify an entry (tensor)

I am following the example: https://www.tensorflow.org/tutorials/structured_data/time_series. In my case I have a sensor which collect the data every hour. This one has not being really reliable during the last months and I have lost some data. To…
Luz
  • 1
0
votes
0 answers

Google Slides API batchUpdate memory exhausted

I am attempting to do 25 or so text replacement updates via the batchUpdate() function for Google Slides in PHP. I continue to receive the following error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 260050944 bytes) Here is…
Gurnzbot
  • 3,742
  • 7
  • 36
  • 55
0
votes
1 answer

JMeter Groovy SQL Batch Update very slow

Hi I am trying to update multiple MYSQL Tables from data set in DB. I am updating 3 tables using batch if I update a single row it works fine and update records in all 3 tables within 1-2seconds but if I fetch 3 records and update then suddenly it…
Sandeep Sharma
  • 109
  • 2
  • 15
0
votes
1 answer

Update in Batches Never Finishes

as a follow up on my question original question posted here UPDATE in Batches Does Not End and Remaining Data Does Not Get Updated If you use the logic below you'll see that update never finishes. Let me know if you have any ideas why... Table 1 IF…
Data Engineer
  • 795
  • 16
  • 41
0
votes
1 answer

UPDATE in Batches Does Not End and Remaining Data Does Not Get Updated

I need to update a table in batches, but it does not work. I tried 2 options below. Both of the options update the first 10 rows but the update is still running. But only 10 rows remain updated. Seems like update never finishes and count shows…
Data Engineer
  • 795
  • 16
  • 41
0
votes
2 answers

Batch Update: connection.commit() at the very end, with setAutoCommit(false), but data doesn't get rolled back

My Java JDBC call for a Batch-Update is structured as conn.setAutoCommit(false); for (int i = 0; i < items.size(); i++) { //... ps.addBatch(); } ps.executeBatch(); // Suppose an exception happens right before a Commit if (someCondition) …
gene b.
  • 10,512
  • 21
  • 115
  • 227
0
votes
1 answer

How do I batch update a sqlite database with a single table

I have some questions in my work. I'm writing an information management system that displays information from a database. One of the features in the software is the ability to export the displayed information as EXCEL, and then the user can modify…
Two chuai pocket
  • 1
  • 1
0
votes
1 answer

Google sheets API Batch Update

Could someone please post an example of using Google's batchUpdateValuesRequest to set multiple value on a google sheet? I am just trying to understand how to change values in a google sheet. I can successfully authenticate (and read data from a…
219CID
  • 340
  • 5
  • 15
1 2 3
…
11 12