troubleshooting Question

JAVA update a batch of records

Avatar of cookiejar
cookiejarFlag for United States of America asked on
Java
4 Comments1 Solution242 ViewsLast Modified:
In the following update method, I am looping through a list and updating one record at a time.  Is this more efficient as a batch update?  If not how should I rewrite the method to do a batch update?

private static final String UPDATE_TEMP_string_format = "update %s set code = '%s', count = %d, tier3_eval_text = '%s', " where item_id = %d ;





public void updateItems(List<ItemVO> Items, String TableName)
            throws DataAccessException
    {
        final Connection connection = SqlUtil.getCurrentConnection();

        for (final ItemVO Item : Items)
        {
            String sqlString = String.format(UPDATE_TEMP_string_format,
                   TableName, Item.getCode(), Item.getCount()
                              Item.getItem_Id;
                     

            try (PreparedStatement statement = connection
                    .prepareStatement(sqlString))
            {

                if (statement.executeUpdate() == 1)
                {
                    connection.commit();
                }
            }
            catch (final SQLException sqlException)
            {
                throw new DataAccessException(sqlException);
            }

        }

    }
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros