[1] - OK [2] - OK [3] - issue [1] Statement s = con.createStatement(); s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(61,61)"); s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(62,62)"); s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(63,63)"); s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(64,64)"); int[] updCount = s.executeBatch(); [2] PreparedStatement s = con.prepareStatement("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(?,?)"); s.setInt(1, 61); s.setString(2, "61"); s.addBatch(); int[] updCount = s.executeBatch(); [3] PreparedStatement s = con.prepareStatement("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(?,?)"); s.setInt(1, 61); s.setString(2, "61"); s.addBatch(); s.setInt(1, 62); s.setString(2, "62"); s.addBatch(); int[] updCount = s.executeBatch();