batchUpdate « Database « Spring Q&A





1. how can I batchUpdate with a query that requires 2 parameters and only one of them is stored in a list    stackoverflow.com

I use Spring-JDBC to insert the list of facebook friends for a user in my MySQL database. I have a final Long that contains the user uid and a List that contains ...

2. Chunking, batchUpdate sizes and a single commit    forum.springsource.org

Apr 29th, 2011, 05:33 AM #1 pdjohe@gmail.com View Profile View Forum Posts Private Message Junior Member Join Date Apr 2011 Posts 3 Chunking, batchUpdate sizes and a single commit Suppose you ...

3. JdbcTemplate.batchUpdate Atomikos autocommit interaction    forum.springsource.org

JdbcTemplate.batchUpdate Atomikos autocommit interaction Hello, Given: Code: @Transactional public void insertTrade( Trade t ){ jdbcTemplate.batchUpdate( "insert into TRADE_TABLE(source_tradeid, target_tradeid, num_matches, num_possible_matches, product_type) values (?, ?, ?, ?, ?)", new BatchPreparedStatementSetter() { ...

4. JDBC batchUpdate and CallableStatements    forum.springsource.org

JDBC batchUpdate and CallableStatements In look at batch updates for CallableStatements I found the following information: The ability to make batch updates is the same for CallableStatement objects as it is ...

5. jdbcTemplate batchUpdate Invalid Column Index    forum.springsource.org

I get the following SQL exception when using jdbcTemplate.batchUpdate: Code: org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [INSERT INTO CMOWNER.TAB_ENVIRONMENT_CONFIGURATION (ENVIRONMENT_LABEL, CONFIGURATION_LABEL) VALUES(?, ?)]; nested exception is java.sql.SQLException: Invalid column index ...

6. Problem with JdbcTemplate.batchUpdate() --> Always returning -2    forum.springsource.org

Problem with JdbcTemplate.batchUpdate() --> Always returning -2 Hi All, I am using Spring JDBCTemplate.batchUpdate() with PreparedStatement as shown below Code: String[][] myData = {{"param1", "value1"}, {"param2", "value2"}, {"param3", "value3"}}; String sql ...

7. Problem with JdbcTemplate.batchUpdate()    forum.springsource.org

Problem with JdbcTemplate.batchUpdate() I'm trying to get JdbcTemplate.batchUpdate() to work the way I would expect -- namely, I'd like it to hold off the commit until the whole batch has been ...

8. Help with batchUpdate error    forum.springsource.org

Help with batchUpdate error For some reason, an exception is being thrown on this sql statement, and I can't figure out why. If I execute the exact same statement outside of ...

9. JdbcTemplate.batchUpdate justification request    forum.springsource.org

JdbcTemplate.batchUpdate justification request JdbcTemplate.batchUpdate A few questions... What happens when the batch size is more that the db's allowable batch size. It looks like the code just exits after the first ...





10. jdbcTemplate.batchUpdate performance issues    forum.springsource.org

jdbcTemplate.batchUpdate performance issues I am working with large data loading from one database to another. Using the jdbcTemplates batchUpdate method seems to slow down the process remarkably - is there anybody ...

11. how can i use batchUpdate?    forum.springsource.org

i'm trying to do a bulk update in the db. I need to use batchupdate but i dont know how to build the PreparedStatement using my objects, that i need method. ...

12. batchUpdate with PreparedStatementCreator?    forum.springsource.org

Hi All, I have looked thru the forums for an answer sorry if I missed it... I want to do a batch sql insert statement for 100+K records - controlling the ...

13. Using JdbcTemplate.batchUpdate    forum.springsource.org

Using JdbcTemplate.batchUpdate Hi i am using jdbcTemplate.batcUpdate and i am not very convience that this is the better way of doing this . here is the code: private void updateAnswers(final Map ...

14. Use of JDBC batchUpdate size instead of commitInterval    forum.springsource.org

Use of JDBC batchUpdate size instead of commitInterval Hi everybody, We use spring-batch-1.0.0.m3 to run our jobs for inserting data from flat files into the database tables. We figured out that ...

15. JdbcTemplate batchUpdate and error handling    forum.springsource.org

JdbcTemplate batchUpdate and error handling Hi, Is there a method to get the number of rows actually inserted after an exception on a JdbcTemplate.batchUpdate() ? I'm implementing something that should survive ...

16. BatchUpdate in MySql - Performance    forum.springsource.org

BatchUpdate in MySql - Performance Hello All, I am reading from a file and writing to a database. As I am in the process of creating a prototype to go with ...





17. jdbc batchupdate exception    forum.springsource.org

May 8th, 2008, 01:36 AM #1 praveens18 View Profile View Forum Posts Private Message Junior Member Join Date Jan 2008 Posts 17 jdbc batchupdate exception Hello, In my dao layer, I ...

18. JdbcTemplate batchUpdate() method - Commiting each row    forum.springsource.org

JdbcTemplate batchUpdate() method - Commiting each row Our project decided on using spring's JDBC support classes. And we're using jdbcTemple to perform a batch insert. However the database team reported seeing ...

19. JdbcTemplate.batchUpdate() exception    forum.springsource.org

JdbcTemplate.batchUpdate() exception Hi, I tried to insert records as barch thru JdbcTemplate.batchUpdate() this method and getting exception like: [Teradata JDBC Driver] : HY000 802 : Timeout StatementState.TIMEOUT before receive; nested exception ...

20. JdbcTemplate batchupdate for delete hangs    forum.springsource.org

JdbcTemplate batchupdate for delete hangs Iam calling following function in a loop, the itemNumberList values varies from 300 to 10k , The JDBCHelper splits the list into listof os size 5k ...

21. Separate string and start batchUpdate    forum.springsource.org

Separate string and start batchUpdate I have a string "1;45;67;78". Numbers are the ids of records in the db table that I need to delete. Can I use batchUpdate to delete ...

22. getSimpleJdbcTemplate().batchUpdate()    forum.springsource.org

I have java.util.List of sql query and java.util.List of Object[] parameters How i should persist using getSimpleJdbcTemplate().batchUpdate(sql, parameters) ? I mean to say the sql query and the parameters are dynamic ...

23. StoredProcedure to support batchUpdate api    forum.springsource.org

I cannot find an api in StoredProc class to batch the storedProc call. Can this be not added? for e.g. int[] updateCounts = mystoredProc.updateBatch(batchValues); The only way to achieve batching in ...

24. problem with duplicates inserted when using getSimpleJdbcTemplate().batchUpdate()    forum.springsource.org

problem with duplicates inserted when using getSimpleJdbcTemplate().batchUpdate() Hi all, I'm getting a problem of getting my records inserted twice if I use getSimpleJdbcTemplate().batchUpdate() inside my ItemWriter if i have an an ...

25. BatchUpdate question... How best to insert and update with BatchUpdate    forum.springsource.org

BatchUpdate question... How best to insert and update with BatchUpdate I'm looking for the most efficient way to perform a batchUpdate() without knowing up front whether the items are to be ...