Hi all, i need to use EntityManagerFactory y EntityManager outside of an EJB, in fact i need to use them inside of a simple Pojo. The below class is a simple pojo that load a collection from the DB and return that collection in form of StecItem[] array. Now when i run this code i get the following error:
java.sql.SQLException: You cannot set autocommit during a managed transaction!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:482)
....
....
.......
Any help will be appreciated.
public class CargaNomencladores {
public static SelectItem[] cargaNomenclador(String nomencladorClassName)
{
EntityManagerFactory emf = Persistence.createEntityManagerFactory("jsfTest");
EntityManager em = emf.createEntityManager();
Query query = em.createQuery("select n from " + nomencladorClassName + "n");
List tempNomencladorRl = query.getResultList();
int size = tempNomencladorRl.size();
SelectItem[] nomencladorSelectItem = new SelectItem[size];
for (int i=0; i<size;i++){
SelectItem si = new SelectItem(tempNomencladorRl.get(i),tempNomencladorRl.get(i).getValor());
nomencladorSelectItem= si;
}
em.close();
emf.close();
return nomencladorSelectItem;
}
}
