Java ExecuteBatch() inserts only 1 row

You are creating a new PreparedStatement in each loop. Each statement only gets one batch added to it, and only the last statement gets executed.

Move ps = conn.prepareStatement("INSERT INTO NK_EVENT_DATA VALUES(?,?,?,?,?,?,?); outside the loop.