1. how can I batchUpdate with a query that requires 2 parameters and only one of them is stored in a list stackoverflow.comI 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.orgApr 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.orgJdbcTemplate.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.orgJDBC 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.orgI 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.orgProblem 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.orgProblem 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.orgHelp 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.orgJdbcTemplate.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.orgjdbcTemplate.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.orgi'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.orgHi 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.orgUsing 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.orgUse 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.orgJdbcTemplate 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.orgBatchUpdate 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.orgMay 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.orgJdbcTemplate 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.orgJdbcTemplate.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.orgJdbcTemplate 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.orgSeparate 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.orgI 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.orgI 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.orgproblem 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.orgBatchUpdate 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 ... |