Hi, Ooh, it's been a little while since I've seen a 2d array parameter ;) Anyways, I don't have a response as I haven't been involved with DbUtils for a little bit, but I wanted to ask that you prepend your subject lines with the name of the component in question, e.g. [DbUtils] Batch Update ;)
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Adkins Kendall [mailto:[EMAIL PROTECTED] >Sent: Tuesday, March 02, 2004 10:11 AM >To: '[EMAIL PROTECTED]' >Subject: Batch Update > >Has any consideration been given to adding batch update capability? For >instance, the following method could be added to the QueryRunner class: > >/** > * Execute a batch of SQL INSERT, UPDATE, or DELETE queries. > * > * @param conn The connection to use to run the query. > * @param sql The SQL to execute. > * @param params An array of query replacement parameters. > * @return The number of rows updated per statement. > * @throws SQLException > */ >public int[] batchUpdate(Connection conn, String sql, Object[][] params) > throws SQLException { > PreparedStatement stmt = null; > int[] rows = null; > try { > stmt = this.prepareStatement(conn, sql); > > for(int i = 0; i < params.length; i++) { > this.fillStatement(stmt, params[i]); > stmt.addBatch(); > } > rows = stmt.executeBatch(); > } catch (SQLException e) { > this.rethrow(e, sql, params); > } finally { > DbUtils.close(stmt); > } > return rows; >} > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
