1 Reply Latest reply on Aug 14, 2005 5:39 AM by Ronald van Kuijk

    when i change database to oracle9i,the JBPM's example websal

    Huang Linchuan Newbie

      Error info as follows:
      ........................................
      ......................................
      16:28:57,171 INFO [STDOUT] Hibernate: select taskinstan0_.ID_ as ID1_, taskinst
      an0_.NAME_ as NAME2_26_, taskinstan0_.DESCRIPTION_ as DESCRIPT3_26_, taskinstan0
      _.ACTORID_ as ACTORID4_26_, taskinstan0_.CREATE_ as CREATE5_26_, taskinstan0_.ST
      ART_ as START6_26_, taskinstan0_.END_ as END7_26_, taskinstan0_.DUEDATE_ as DUED
      ATE8_26_, taskinstan0_.PRIORITY_ as PRIORITY9_26_, taskinstan0_.ISCANCELLED_ as
      ISCANCE10_26_, taskinstan0_.ISSIGNALLING_ as ISSIGNA11_26_, taskinstan0_.ISBLOCK
      ING_ as ISBLOCKING12_26_, taskinstan0_.TASK_ as TASK13_26_, taskinstan0_.TOKEN_
      as TOKEN14_26_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN15_26_, taskinstan0_.TAS
      KMGMTINSTANCE_ as TASKMGM16_26_ from JBPM_TASKINSTANCE taskinstan0_ where taskin
      stan0_.ACTORID_=? and (taskinstan0_.END_ is null) and taskinstan0_.ISCANCELLED_=
      false

      16:28:57,171 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
      16:28:57,171 ERROR [JDBCExceptionReporter] ORA-00904: "FALSE": invalid identifier

      16:28:57,171 ERROR [TaskMgmtSession] org.hibernate.exception.SQLGrammarException
      : could not execute query


      ................................
      ...........................

      can somebody help me? I found that the column JBPM_TaskInstance.ISCancelled_ is number datatype,that is Number(1).Here the sql printed above is ".......ISCancelled_=false" ,of course it is wrong.But why the problem occurs?