1 Reply Latest reply on Dec 8, 2006 4:23 AM by Joshua Jackson

    Persistence difference between Jboss 4.0.5 and 4.0.4GA

    Yoav Al Newbie

      Hello all,

      I have a WebApp that call an EJB3 that get some data from database.
      I use the Jboss default database.

      I used to work on Jboss 4.0.5 and every thing work fine,
      I?ve changed the server to jboss 4.0.4GA and now I get an exception.
      Here is the exception I get:


      2006-12-07 18:29:02,599 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.mobimate.items.model.Item (no alias) -> item0_
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( FromClause{level=1} item item0_ ) )
      2006-12-07 18:29:02,599 DEBUG [com.mobimate.items.ejb.ItemManagerBean] EJB:fillTableWithItems() put some items in table...
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 231, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 232, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 233, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 234, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 235, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 236, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 237, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 238, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 239, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 240, using strategy: org.hibernate.id.MultipleHiLoPerTableGenerator
      2006-12-07 18:29:02,599 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: from com.mobimate.items.model.Item
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
       \-[QUERY] 'query'
       \-[SELECT_FROM] 'SELECT_FROM'
       \-[FROM] 'from'
       \-[RANGE] 'RANGE'
       \-[DOT] '.'
       +-[DOT] '.'
       | +-[DOT] '.'
       | | +-[DOT] '.'
       | | | +-[IDENT] 'com'
       | | | \-[IDENT] 'mobimate'
       | | \-[IDENT] 'items'
       | \-[IDENT] 'model'
       \-[IDENT] 'Item'
      
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.mobimate.items.model.Item (no alias) -> item0_
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( FromClause{level=1} item item0_ ) )
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
      2006-12-07 18:29:02,615 DEBUG [org.jboss.ejb3.entity.ManagedEntityManagerFactory] ************** closing entity managersession **************
      2006-12-07 18:29:02,615 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
      2006-12-07 18:29:02,630 DEBUG [com.mobimate.web.items.ItemList] EJB:getItems() javax.ejb.EJBException: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: JPA-QL compliance requires select clause [from com.mobimate.items.model.Item]
      2006-12-07 18:29:02,630 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/helloweb-web].[jsp]] Servlet.service() for servlet jsp threw exception
      



      apparently there have been made changes in the serer,
      but what am i missing ?

      thanks