2 Replies Latest reply on Mar 22, 2012 11:58 AM by h-igel-cs

    JTA  and Container Managed Transactions in JBoss 7.1.0

    meervanderj

      When i started to develop the application i tried to use the container managed transactions using EJB3.

      I am using JBoss 7.1.0 but my lazy loading is giving exceptions beacaus the Hibernate session is already closed.

      In the logging i searched for the transaction statements bij there is no transaction started.

       

      Can somebody help me what i do wrong

       

      The  error :

      failed to lazily initialize a collection of role: com.narrowconnect.prototype.data.dataobjects.CategoryBean.subCategories, no session or session was closed

       

      The logging

       

      02:44:06,617 DEBUG [com.narrowconnect.prototype.data.facade.CategoryFacade] (http--127.0.0.1-8080-1) getAllCategories()

      02:44:06,939 DEBUG [com.narrowconnect.prototype.data.dao.CategoryDAO] (http--127.0.0.1-8080-1) getAllCategories()

      02:44:06,988 DEBUG [org.hibernate.internal.SessionImpl] (http--127.0.0.1-8080-1) Opened session at timestamp: 13296158469

      02:44:06,989 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,989 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,990 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] (http--127.0.0.1-8080-1) Looking for a JTA transaction to join

      02:44:06,990 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] (http--127.0.0.1-8080-1) Unable to join JTA transaction

      02:44:06,990 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,991 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,992 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,992 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:06,995 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,000 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,001 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,001 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,001 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,001 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,010 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http--127.0.0.1-8080-1) Obtaining JDBC connection

      02:44:07,013 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http--127.0.0.1-8080-1) Obtained JDBC connection

      02:44:07,030 DEBUG [org.hibernate.SQL] (http--127.0.0.1-8080-1) select categorybe0_.id as id0_, categorybe0_.message as message0_, categorybe0_.shortmessage as shortmes3_0_ from Category categorybe0_

      02:44:07,064 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 0

      02:44:07,067 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#1]

      02:44:07,067 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,068 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,071 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,071 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,072 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 1

      02:44:07,072 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#2]

      02:44:07,072 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,072 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,072 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,072 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,073 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 2

      02:44:07,073 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#3]

      02:44:07,073 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,073 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,073 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,074 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,074 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 3

      02:44:07,074 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#4]

      02:44:07,074 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,074 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,075 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,075 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,075 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 4

      02:44:07,075 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#5]

      02:44:07,075 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,075 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,076 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,076 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,076 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 5

      02:44:07,076 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result row: EntityKey[com.narrowconnect.prototype.data.dataobjects.CategoryBean#6]

      02:44:07,077 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,077 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,077 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,077 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,077 DEBUG [org.hibernate.loader.Loader] (http--127.0.0.1-8080-1) Result set row: 6

      02:44:07,087 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http--127.0.0.1-8080-1) Releasing JDBC connection

      02:44:07,087 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http--127.0.0.1-8080-1) Released JDBC connection

      02:44:07,088 DEBUG [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http--127.0.0.1-8080-1) HHH000163: Logical connection releasing its physical connection

      02:44:07,088 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,089 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,089 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#1]

      02:44:07,090 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,090 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,094 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,094 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,095 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,095 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,096 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#1]

      02:44:07,096 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,096 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#2]

      02:44:07,096 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,096 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,096 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,097 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,097 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,097 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,097 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#2]

      02:44:07,098 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,098 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#3]

      02:44:07,098 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,098 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,098 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,098 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,099 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,099 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,099 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#3]

      02:44:07,099 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,099 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#4]

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,100 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,101 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#4]

      02:44:07,101 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,101 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#5]

      02:44:07,101 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,101 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,101 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,102 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,102 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,102 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,102 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#5]

      02:44:07,102 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,102 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Resolving associations for [com.narrowconnect.prototype.data.dataobjects.CategoryBean#6]

      02:44:07,103 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,103 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,103 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,103 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,103 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,104 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,104 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http--127.0.0.1-8080-1) Done materializing entity [com.narrowconnect.prototype.data.dataobjects.CategoryBean#6]

      02:44:07,104 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,116 DEBUG [org.hibernate.engine.internal.StatefulPersistenceContext] (http--127.0.0.1-8080-1) Initializing non-lazy collections

      02:44:07,117 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,117 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http--127.0.0.1-8080-1) Aggressively releasing JDBC connection

      02:44:07,117 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,511 ERROR [com.narrowconnect.prototype.webservices.ExceptionHandling] (http--127.0.0.1-8080-1) failed to lazily initialize a collection of role: com.narrowconnect.prototype.data.dataobjects.CategoryBean.subCategories, no session or session was closed

      02:44:07,643 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      02:44:07,643 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http--127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

       

       

      The code snippets :

       

      CategoryFacade

       

      /**

      * @author jeroen

      *

      */

      @Stateful

      @TransactionManagement(TransactionManagementType.CONTAINER)

      public class CategoryFacade {

       

          private static Logger logger = LoggerFactory

                  .getLogger(CategoryFacade.class);

       

          @Inject

          CategoryDAO categoryDAO;

       

          @Inject

          SubCategoryDAO subCategoryDAO;

       

          /**

           * Returns all catagories

           *

           * @return

           */

          @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)

          public List<CategoryTO> getAllCategories() {

              if (logger.isDebugEnabled()) {

                  logger.debug("getAllCategories()");

              }

              List<CategoryTO> result = CategoryTransformator

                      .transfromToListCategoryTO(categoryDAO.getAllCategories());

              // If null result the returns an empty set

              if (result == null) {

                  result = new ArrayList<CategoryTO>();

              }

              return result;

          }

       

       

      CategoryDAO

       

       

      /**

      * DAO Class for Category

      *

      * @author jeroen

      *

      */

      @Stateful(name="CategoryDAO")

      @TransactionAttribute(MANDATORY)

      public class CategoryDAO {

         

          private static Logger logger = LoggerFactory.getLogger(CategoryDAO.class);

       

         

          @PersistenceContext(unitName = "NarrowConnect", type=PersistenceContextType.TRANSACTION)

          EntityManager entityManager;

         

          /**

           * Get all catagories

           *

           * @return List<CategoryTO>

           */

          @SuppressWarnings("unchecked")

          public List<Category> getAllCategories(){

             

              if ( logger.isDebugEnabled() ){

                  logger.debug("getAllCategories()");

              }

             

              Query query = entityManager.createNamedQuery(CategoryBean.QUERY_GET_ALLCATEGORIES);

              List<Category> result = (List<Category>) query.getResultList();

              return result;

          }

       

      }

       

       

      CategoryBean.class

       

      @Entity

      @Table(name = "Category")

      @NamedQueries({

              @NamedQuery(name = "getAllCategories", query = "SELECT c FROM CategoryBean c"),

              @NamedQuery(name = "getMyCatagories", query = "SELECT DISTINCT s.category FROM SubCategoryBean s JOIN s.users u WHERE u.username = :userName") })

      public class CategoryBean implements Serializable, Category {

       

          public final static String QUERY_GET_ALLCATEGORIES = "getAllCategories";

          public final static String QUERY_GETMYCATAGORIES = "getMyCatagories";

          public final static String P_USERID = "userName";

       

          /**

           *

           * VersionNumber

           *

           */

          private static final long serialVersionUID = 20111312112050L;

       

          /**

           * Get column ID (primary key), GeneratedValue determines that the field

           * value is determined else where is will not be specificly given

           */

          @Id

          @GeneratedValue(strategy = GenerationType.IDENTITY)

          private long id;

       

          @Column(name = "shortmessage")

          private String ShortMessage;

       

          @Column(name = "message")

          private String Message;

       

          // bi-directional many-to-one association to SubCategory

          @OneToMany(mappedBy = "category")

          private List<SubCategoryBean> subCategories;

        • 1. Re: JTA  and Container Managed Transactions in JBoss 7.1.0
          meervanderj

          When i tried the "jboss-as-login" example withe the container managed transactions then the following occures in the logging :

           

          22:29:59,517 INFO  [com.arjuna.ats.arjuna] (http--127.0.0.1-8080-1) ARJUNA012163: Starting service com.arjuna.ats.arjuna.recovery.ActionStatusService on port 4713

          22:29:59,518 INFO  [com.arjuna.ats.arjuna] (http--127.0.0.1-8080-1) ARJUNA012337: TransactionStatusManagerItem host: 127.0.0.1 port: 4713

          22:29:59,520 INFO  [com.arjuna.ats.arjuna] (http--127.0.0.1-8080-1) ARJUNA012170: TransactionStatusManager started on port 4713 and host 127.0.0.1 with service com.arjuna.ats.arjuna.recovery.ActionStatusService

           

          This doesn't occure when i use my application.

          How can i start the TransactionStatusManager ??

          • 2. Re: JTA  and Container Managed Transactions in JBoss 7.1.0
            h-igel-cs

            I had a similiar issue with as 7.1.1. my application worked with 6.1 without problems. These days I got some lazy-loading problems at some of my WebMethods:

            org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: de.cosys.solutions.entity.PurchaseOrder.items, no session or session was closed

            Here is the reference-field. I think it looks very simple

             

            @OneToMany(cascade=CascadeType.ALL)

            @JoinColumn(name="purchaseorderid")

            private Set<PurchaseOrderItem>items = new HashSet<PurchaseOrderItem>();

             

            The WebMethod performs only selects and no inserts. So I annoted the method with

            @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)

            In 6.1 this works fine. But in 7.1 I got the lazy problems. After removing the annotation it works with 7.1.1.

             

            I don't know if this a change in specification or...

            1 of 1 people found this helpful