Questions tagged [batch-updates]
171 questions
0
votes
1 answer
How can I get auto increment values in batch update query (Java,MySQL)?
I am using Spring-Jdbc template(first timer) to create MySql repository. I have tables that use AutoIncrement columns as primary key.
I wonder if there a way to get newly generated Ids (autoInc) with each successful batch create statement?
Any…
Panks
- 601
- 1
- 11
- 20
-1
votes
1 answer
How to enable rewriteBatchStatements when using gcp cloud sql proxy?
We have a microservice deployed on GKE that connects to mysql db instance on GCP through cloud sql proxy. We are using spring jdbctemplate.batchUpdate to execute batch insert/update statements.
When I append rewriteBatchStatements=true to jdbc url…
user3577810
- 71
- 5
-1
votes
1 answer
Batch Update to Delete, Copyto, and then rename a Google Sheet in Javascript in a web request
Within a SQL Server 2017 Integration Services project, using the CozyRoc REST Connection Manager, I'm trying to use their JavaScript Task to Delete a Sheet in one Google Spreadsheet then copy the same-named Sheet from another Spreadsheet into that…
Karen Grube
- 1
- 1
-1
votes
1 answer
Is Session.Save sending a request to the database?
I have to improve the performance of a very slow code and I am pretty new to Hibernate. I have studied carefully the code and concluded that the issue is that it has a large set of entities to load and update/insert. To translate the algorithm to a…
Lajos Arpad
- 64,414
- 37
- 100
- 175
-1
votes
1 answer
Batch Update an array in mongoose object
My Schema is as below. A student can participate in any no. of events.and each Event can have any number of students.
Student{
name:String,
age:Number,
.
.
.,
events:{
type:
[
{type:Schema.ObjectId,
ref:'Event'}
…
sabari
- 2,595
- 5
- 28
- 44
-1
votes
2 answers
Window batch script to truncate leading zeros in a text file and write to a new file
Kindly help with a windows batch script that will remove the leading zeroes in a text file and write to a new file without the zeroes.
Input file format
0265952076
0263097520
0578361217
0266127789
0505834686
0578361190
Output…
user3798582
- 1
- 1