public class ManageKennzahl {

private static EntityManagerFactory factory;
EntityManager em = null;
private static List<String> kNFormelZPs = new ArrayList<>();


/**
 * @param args
 */
public static void main(String[] args) {
    try {
        factory = Persistence.createEntityManagerFactory("migration");

    } catch (Throwable ex) {
        System.err.println("Failed to create sessionFactory object." + ex);
        throw new ExceptionInInitializerError(ex);
    }
    ManageKennzahl mk = new ManageKennzahl();

    mk.getKNFormelZPsFromKennzahl();
    mk.getKNFormelNPsFromKennzahl();
    mk.convert();
}

/**
 *
 */
private List<String> getKNFormelZPsFromKennzahl() {
    em = factory.createEntityManager();
    try {

        List<Kennzahl> kNFormelZPSs = em.createQuery("Select i From Kennzahl i ", Kennzahl.class).getResultList();
        for (Kennzahl kNFormelZPS : kNFormelZPSs) {
            String FormelZPs = kNFormelZPS.getFormelZPseudo();
            aquaQidbKNFormelZPs.add(FormelZPs);
        }

    } catch (HibernateException e) {
        e.printStackTrace();
    } finally {
        em.close();
    }
    return kNFormelZPs;
}



private void convert() {
    Kennzahl kn = new Kennzahl();
    em = factory.createEntityManager();
    for (String fomelZPs : kNFormelZPs) {
        em.getTransaction().begin();
        kn.setFormelZGL1(fomelZPs + "new");
        em.persist(kn);
        em.getTransaction().commit();
    }
}
}

private void convert() {
Kennzahl kn = new Kennzahl();
em = factory.createEntityManager();
for (Kennzahl qidbKennzahl : aqidbKennzahlen) {
  qidbKennzahl.setFormelZGL1(qidbKennzahl .getFormelZPseudo() + " test");
  em.merge(aquaQidbKennzahl);
  }
em.getTransaction().commit();
}