question: public void testInsert5 ( ) throws SQLException { statement . execute ( "INSERT INTO " + DatabaseCreator . TEST_TABLE5 + " SELECT 1 as testId, 2 as testValue " + "UNION SELECT 2 as testId, 3 as testValue " + "UNION SELECT 3 as testId, 4 as testValue" ) ; ResultSet r = statement . executeQuery ( "SELECT COUNT(*) FROM " + DatabaseCreator . TEST_TABLE5 ) ; r . next ( ) ; assertEquals ( "Should be 3 rows" , 3 , r . getInt ( 1 ) ) ; r . close ( ) ; }
target:  InsertFunctionalityTest#testInsert5(). Inserts multiple rows using UNION ALL