question: private StringBuffer prepareOptimizedInsertStatement ( OneRowChange oneRowChange ) { StringBuffer stmt ; stmt = new StringBuffer ( ) ; stmt . append ( "INSERT INTO " ) ; stmt . append ( conn . getDatabaseObjectName ( oneRowChange . getSchemaName ( ) ) + "." + conn . getDatabaseObjectName ( oneRowChange . getTableName ( ) ) ) ; stmt . append ( " ( " ) ; printColumnSpec ( stmt , oneRowChange . getColumnSpec ( ) , null , null , PrintMode . NAMES_ONLY , ", " ) ; stmt . append ( ") VALUES (" ) ; boolean firstRow = true ; for ( ArrayList < ColumnVal > oneRowValues : oneRowChange . getColumnValues ( ) ) { if ( firstRow ) { firstRow = false ; } else stmt . append ( ", (" ) ; printColumnSpec ( stmt , oneRowChange . getColumnSpec ( ) , null , oneRowValues , PrintMode . PLACE_HOLDER , " , " ) ; stmt . append ( ")" ) ; } return stmt ; }
target:  Build prepare statement for optimized inserts : <br> INSERT INTO table1 VALUES (...) ; INSERT INTO table1 VALUES (...) ; ... would translate into<br> INSERT INTO table1 VALUES (...), (...), ...