0 Replies Latest reply on Nov 12, 2008 11:02 AM by ravi kumar

    problem integration with seam,jbpm,mysql using jboss tools

    ravi kumar Newbie
      Hai all..

               I am new to seam and jbpm .. Iam using JEMS as my server..
       
               jbpm is successfully integrated into my JEMS server i tested simple application given in the jbpm suit it is successfully deloyed with out errors..

      If i combined with seam framework it is giving Exception saying that jbpmcontext null..

      Here is the my version of software used:-java 1.5.0_15
                                                JEMS 1.2.1 CR4
                                                Eclipse 3
                                                seam 2_1_1.0.3
                                                JBPM 3.2.2
                                                 MySQL 5.0

      It is giving following errors:In the log

      2008-11-12 15:26:34,226 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
      2008-11-12 15:26:34,226 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL:
         
            select ti
            from org.jbpm.taskmgmt.exe.TaskInstance as ti
            where ti.actorId in ( :actorIds )
              and ti.isSuspended != true
              and ti.isOpen = true
         
       
      2008-11-12 15:26:34,226 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select taskinstan0_.ID_ as ID1_142_, taskinstan0_.VERSION_ as VERSION3_142_, taskinstan0_.NAME_ as NAME4_142_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_142_, taskinstan0_.ACTORID_ as ACTORID6_142_, taskinstan0_.CREATE_ as CREATE7_142_, taskinstan0_.START_ as START8_142_, taskinstan0_.END_ as END9_142_, taskinstan0_.DUEDATE_ as DUEDATE10_142_, taskinstan0_.PRIORITY_ as PRIORITY11_142_, taskinstan0_.ISCANCELLED_ as ISCANCE12_142_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_142_, taskinstan0_.ISOPEN_ as ISOPEN14_142_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_142_, taskinstan0_.ISBLOCKING_ as ISBLOCKING16_142_, taskinstan0_.TASK_ as TASK17_142_, taskinstan0_.TOKEN_ as TOKEN18_142_, taskinstan0_.PROCINST_ as PROCINST19_142_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_142_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_142_ from JBPM_TASKINSTANCE taskinstan0_ where (taskinstan0_.ACTORID_ in (?)) and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
      2008-11-12 15:26:34,226 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
      2008-11-12 15:26:34,226 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
      2008-11-12 15:26:34,226 DEBUG [org.jbpm.persistence.db.DbPersistenceService] creating hibernate session
      2008-11-12 15:26:34,226 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 5023677621149696
      2008-11-12 15:26:34,241 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@8095c6, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@1919c1f{ url=null ,addedOrder=0}
      2008-11-12 15:26:34,241 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
      2008-11-12 15:26:34,241 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
      2008-11-12 15:26:34,241 DEBUG [org.hibernate.SQL]
          select
              processdef0_.ID_ as ID1_119_,
              processdef0_.NAME_ as NAME3_119_,
              processdef0_.DESCRIPTION_ as DESCRIPT4_119_,
              processdef0_.VERSION_ as VERSION5_119_,
              processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_119_,
              processdef0_.STARTSTATE_ as STARTSTATE7_119_
          from
              JBPM_PROCESSDEFINITION processdef0_
          where
              processdef0_.NAME_=?
          order by
              processdef0_.VERSION_ desc limit ?
      2008-11-12 15:26:34,241 INFO  [STDOUT] Hibernate:
          select
              processdef0_.ID_ as ID1_119_,
              processdef0_.NAME_ as NAME3_119_,
              processdef0_.DESCRIPTION_ as DESCRIPT4_119_,
              processdef0_.VERSION_ as VERSION5_119_,
              processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_119_,
              processdef0_.STARTSTATE_ as STARTSTATE7_119_
          from
              JBPM_PROCESSDEFINITION processdef0_
          where
              processdef0_.NAME_=?
          order by
              processdef0_.VERSION_ desc limit ?
      2008-11-12 15:26:34,288 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
      2008-11-12 15:26:34,288 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
      2008-11-12 15:26:34,288 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
      2008-11-12 15:26:34,288 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select processdef0_.ID_ as ID1_119_, processdef0_.NAME_ as NAME3_119_, processdef0_.DESCRIPTION_ as DESCRIPT4_119_, processdef0_.VERSION_ as VERSION5_119_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_119_, processdef0_.STARTSTATE_ as STARTSTATE7_119_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
      java.sql.SQLException: Unknown type '16 in column 4 of 6 in binary-encoded result set.


      Please help its urgent..

      with regards..

      RaviKumar