Run a direct SQL native query without JPA repository

NativeQuery.java

package com.innovatm.database;

// ...

@Component
public class NativeQuery {

   @Autowired
   private JpaTransactionManager jpaTransactionManager;
   
   public NativeQuery() {
     EntityManagerFactory emf = this.jpaTransactionManager.getEntityManagerFactory();
     EntityManager em = emf.createEntityManager();
     
     // prepare query
     Query query = em.createNativeQuery("INSERT INTO \"public\".\"my_table\" VALUES (?)");
     query.setParameter(1, 1000);
     
     // execute query inside a transaction
     em.getTransaction().begin();
     query.executeUpdate();
     em.getTransaction().commit();
     
     // free up EntityManager
     em.close();
   }

}