Stack Overflow
Stack Overflow

Questions tagged [batch-updates]

171 questions
1
vote
2 answers

NHibernate - Update selected fields of multiple rows with fixed value

How can I convert following SQL query to NHibernate? UPDATE MyTable SET Field1 = "NewValue1", Field2 = "NewValue2" WHERE Field3 = FilterValue Assume that MyTable contains huge records and above statement affects good percentage of it. It have 50…
Amit Joshi
  • 15,448
  • 21
  • 77
  • 141
1
vote
1 answer

Phoenix use jdbcTemplate to batchUpdate while column contain sequence

i'm using phoenix combine with jdbcTemplate to insert data to Hbase. Phoenix4.7.0 Hbase 1.1.2 One of the column(id) in the table is generated monotonically with a sequence,in general,i use "jdbcTemplate.execute(sql)" method to insert data. For…
Z.xie
  • 11
  • 5
1
vote
2 answers

JDBI I want to bulk update using some thing like bulk insert with creating object

I have to batch update using JDBI same like batch insert with out creating object.Any one know the process please let me know .Remember not using object like mapping column to object's attribute
user6479381
  • 11
  • 1
  • 2
1
vote
1 answer

Creating Batch update in Classic ASP and ADO

I have an ASP form that brings in a number of records that I want to modify and then update. Currently, the updates take place as one-at-a-time update through DLL's that simply build a SQL statement and call the database for each record. Now, I…
CrystalBlue
  • 11
  • 1
1
vote
1 answer

Batch updates with Sequel gem

I need to do multiple updates on a PostgreSQL database at once. To make it faster, I would like to avoid continually changing context between my ruby application and the database. I've learned about the #update_sql method, however my strategy to…
fotanus
  • 19,618
  • 13
  • 77
  • 111
1
vote
0 answers

NSBatchUpdateRequest changes not reflected in MagicalRecord

I have tried to do a NSBatchUpdateRequest to change a property of several thousands NSManagedObject entities. The changes are made in the database, but when I use Magicalrecord to retrieve the updated data, I get back the old data. All the…
Drag0ndust
  • 55
  • 4
1
vote
1 answer

Sybase large update in batch

I need to do large update in sybase. Table1 has column a, b, c, e, f, around 9 million records. Table2 has column a, e, f, around 500000 records. The bellow update sql failed due to syslog full update table1 set e = table2.e, f = table2.f from…
Alex Tang
  • 115
  • 1
  • 4
  • 12
1
vote
1 answer

jdbcTemplate.batchUpdate issue

How to convert this to return a jdbcTemplate.batchUpdate? It needs to be executed to several tables. @Override public int delete(int id) { String sql = "update user set deleted=1 where user_id = ?"; Object[] params = new…
Abacab
  • 13
  • 3
1
vote
1 answer

Spring-Integration using Jdbc-Templates, for operations such as batch-Updates?

This question is regarding "Spring Integration" using JdbcTemplates and not usual Spring with JdbcTemplates (for which several examples are available on the web). I have been following up with documentations and examples for Spring-Integration with…
linuxeasy
  • 6,269
  • 7
  • 33
  • 40
1
vote
1 answer

How to properly perform batch updates on an array

For UITableViews, the order of insertion, deletion and move operations does not matter inside an update block because they are not performed until -endAnimations is called, and then, they are performed as a batch update. Let's say I have 3 arrays: …
Christian Schnorr
  • 10,768
  • 8
  • 48
  • 83
1
vote
1 answer

How can I fix java.sql.BatchUpdateException?

I write a java program that connect to mysql db with jdbc.It inserts records to mysql. The sql is this: INSERT INTO my_schema.my_table VALUES ('AMERICAN', '97', '1995-08-28 00:00:00', '10', '1995-08-28 00:00:00', '10', 'United States Dollar',…
CompEng
  • 7,161
  • 16
  • 68
  • 122
1
vote
0 answers

Updating Large Amount of Data to MySQL Database

I am using an API service from a provider. The API usage looks like - https://api.thesite.com/getTable1Records?offset=0 https://api.thesite.com/getTable2Records?offset=0 https://api.thesite.com/getTable3Records?offset=0 (NOT the real…
Tun Zarni Kyaw
  • 2,099
  • 2
  • 21
  • 27
1
vote
1 answer

running batch statements in Oracle: sendBatch() vs executeBatch()

I'm writing Java code to execute a batch of insert statements into an Oracle database. I've seen in some of the documentation (http://docs.oracle.com/cd/B28359_01/java.111/b31224/oraperf.htm) that I can use sendBatch() or executeBatch() to do this.…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
1
vote
1 answer

i want to save multi records from a form

I am trying save batch record from form and save to database. I got sample from Advanced Example it is a widgets. this. example only add record without save it I add a save bottom under widget and form top of widget. add code for add or update ,I…
maryam
  • 584
  • 9
  • 26
1
vote
2 answers

Is Hibernate batching updates

So this my maiden question so here it goes... The idea is I am doing a large number of update statements to a database table. In sql it would be a simple update table_name set col1 = 123 where col2 = 456 and col1 is null . Since there are millions…
Michael Sampson
  • 369
  • 1
  • 6
  • 19
1 2 3
…
11 12