@Override @Transactional(timeout = 2) public String executeSelectSql(String sql) { checkTestMode(); log.info("started: " + sql); EntityManager em = persistence.getEntityManager(); Query query = em.createNativeQuery(sql); query.getResultList(); log.info("finished: " + sql); return "Done"; }
@Override @Transactional(timeout = 2) public String executeUpdateSql(String sql) { checkTestMode(); log.info("started: " + sql); EntityManager em = persistence.getEntityManager(); Query query = em.createNativeQuery(sql); query.executeUpdate(); log.info("finished: " + sql); return "Done"; }
protected void removeQueuedItems(List<FtsQueue> list) { try (Transaction tx = persistence.createTransaction()) { EntityManager em = persistence.getEntityManager(); for (int i = 0; i < list.size(); i += DEL_CHUNK) { StringBuilder sb = new StringBuilder("delete from SYS_FTS_QUEUE where ID in ("); List<FtsQueue> sublist = list.subList(i, Math.min(i + DEL_CHUNK, list.size())); for (int idx = 0; idx < sublist.size(); idx++) { sb.append("?"); if (idx < sublist.size() - 1) sb.append(", "); } sb.append(")"); DbTypeConverter converter = persistence.getDbTypeConverter(); Query query = em.createNativeQuery(sb.toString()); for (int idx = 0; idx < sublist.size(); idx++) { query.setParameter(idx + 1, converter.getSqlObject(sublist.get(idx).getId())); } query.executeUpdate(); } tx.commit(); } }
@Override public void clearScheduledTasks() { Transaction tx = persistence.createTransaction(); try { EntityManager em = persistence.getEntityManager(); Query query = em.createNativeQuery("delete from SYS_SCHEDULED_EXECUTION"); query.executeUpdate(); query = em.createNativeQuery("delete from SYS_SCHEDULED_TASK"); query.executeUpdate(); tx.commit(); } finally { tx.end(); } }
EntityManager em = persistence.getEntityManager(storeName); SequenceSupport sequenceSupport = getSequenceSupport(sequence); Query query = em.createNativeQuery(sequenceSupport.sequenceExistsSql(sequenceName)); List list = query.getResultList(); if (list.isEmpty()) { query = em.createNativeQuery(sequenceSupport.createSequenceSql(sequenceName, sequence.getStartValue(), sequence.getIncrement())); query.executeUpdate();