troubleshooting Question

JAVA update a batch of records

Avatar of cookiejar
cookiejarFlag for United States of America asked on
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()

            try (PreparedStatement statement = connection

                if (statement.executeUpdate() == 1)
            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