batch-updates
Jdbc batched updates good key retrieval strategy
I insert alot of data into a table with a autogenerated key using the batchUpdate functionality of JDBC. Because JDBC doesn\'t say anything about batchUpdate and getAutogeneratedKeys I need some datab[详细]
2023-03-31 06:52 分类:问答jdbc batch insert and query vs single inserts with gernerated key
I want to insert alot of rows into a table that generates the keys automatically. JDBC doesn\'t guarantee that getting the generated keys will work on a batch update.[详细]
2023-03-12 14:30 分类:问答Using SQL to batch update columns based on position in resulting sort operation?
My brain decided to stop working this morning.I need a MySQL and SQLite compatible query that will allow me to batch update the \"display_order\" column of a table based on sorting by another column.[详细]
2023-03-08 10:01 分类:问答Oracle Batch Insert w/No Primary Key Missing Inserts
I\'m trying to insert over 100,000 records into an Oracle 9i table with no primary key using the ojdbc14.jar driver and Spring\'s SimpleJdbcTemplate batchUpdate method.Here\'s my code snippet:[详细]
2023-02-27 01:09 分类:问答performance issue while calling batchUpdate by java to update multiple rows on mysql 8
I met performance issue with batchUpdate for multiple rows on mysql 8 by using java. There are more than 400,000 rows in the table , I was trying to update a col开发者_如何学Goumn by it\'s id.[详细]
2022-12-07 20:10 分类:问答