[jboss-user] [JBoss Seam] - Using EntityManager out of EJBs components

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; } } View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4108688#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...