[jboss-user] [JBoss Seam] - Re: Odd Transactional Exception on WebLogic 9.2

[neilac333]

So here is something interesting!

I added some more debug statements to my code and found this:


  | 15 Feb 2008 15:39:19,847: DEBUG com.myapp.persistence.QueryServiceImpl - Executed query
  | 15 Feb 2008 15:39:19,847: DEBUG com.myapp.persistence.QueryServiceImpl - Ending method getCategories with 29 categories.
  | 15 Feb 2008 15:39:21,499: DEBUG com.myapp.persistence.QueryServiceImpl - Starting method getCategories
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.engine.query.QueryPlanCache - located HQL query plan in cache (from Category)
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.engine.query.QueryPlanCache - located HQL query plan in cache (from Category)
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.engine.query.HQLQueryPlan - find: from Category
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.engine.QueryParameters - named parameters: {}
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
  | 15 Feb 2008 15:39:21,499: DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
  | 15 Feb 2008 15:39:21,569: DEBUG org.hibernate.util.JDBCExceptionReporter - Cannot open connection [???]
  | java.sql.SQLException: Transaction BEA1-02FE63ADA554FEA2ACBA not active anymore. tx status = Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException]
  | 


Put a bit more succinctly, the getCategories method actually works!  I see the categories themsleves listed as they should be in the log.  But for some reason, the getCategories method gets called again, and it is that second call that generates the exception I described originally.

Any insight into why this might happen is greatly appreciated.

Thanks.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4129777#4129777

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4129777