I have a SFSB with this factory:
| @Factory("userSubscriptions") | public void getUserSubscriptions() { | userSubscriptions = em.createQuery("FROM Subscription s WHERE s.user.sign=:sign ORDER BY s.prio") | .setParameter("sign", getCurrentUser().getSign()) | .getResultList(); | } This collection is used as value for a datatable and works fine. When I click a button in which triggers an action in which userSubscriptions is accessed again I get: | 2007-08-30 09:22:49,843 INFO [org.hibernate.event.def.DefaultLoadEventListener] Error performing load command | org.hibernate.exception.GenericJDBCException: Cannot open connection | Caused by: org.jboss.util.NestedSQLException: Transaction is not active: To me "Cannot open connection" indicates some problem with the database but thats not possible since I do a lot of other db operations. I think I can get around this problem by doing the transactions manually but do I really want to do that? I've had a lot of problems with this in my application so any tips would be most appreciated =). View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079448#4079448 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079448 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user