//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: void executeInsertStatement(java.sql.Connection paramConnection, String paramString, java.util.List<Object[]> paramList) throws Exception internal virtual void executeInsertStatement(Connection paramConnection, string paramString, IList <object[]> paramList) { if (paramList.Count == 0) { return; } PreparedStatement preparedStatement = null; try { StringBuilder stringBuilder = null; if (logger.DebugEnabled) { stringBuilder = (new StringBuilder("INSERT: ")).Append(paramString).Append("\n\tInserting ").Append(paramList.Count).Append(" rows"); } preparedStatement = paramConnection.prepareStatement(paramString); foreach (object[] arrayOfObject in paramList) { if (logger.TraceEnabled) { stringBuilder.Append("\n\tRow values:"); } for (sbyte b = 0; b < arrayOfObject.Length; b++) { object @object = convertValues(paramConnection, arrayOfObject[b]); if (logger.TraceEnabled) { stringBuilder.Append("\n\t\t[").Append(b).Append("] => "); if (@object == null) { stringBuilder.Append("(null)"); } else { stringBuilder.Append(@object + " (" + @object.GetType() + ")"); } } preparedStatement.setObject(b + 1, @object); } if (logger.TraceEnabled) { stringBuilder.Append("\n\tEnd of Row values:"); } preparedStatement.addBatch(); } if (logger.DebugEnabled) { logger.debug(stringBuilder); } preparedStatement.executeBatch(); paramConnection.commit(); preparedStatement.close(); } catch (SQLException sQLException) { if (preparedStatement != null) { preparedStatement.close(); } throw new Exception(sQLException); } }