5 Replies Latest reply on Jul 21, 2005 2:09 PM by Manfred Moser

    Oracle mapping or dialect issue (column not found)

    brittm Novice

      I'm porting a large application from Postgres to Oracle. I've begun to get Oracle errors indicating 'column not found' on some API calls. The following query is being generated by Hibernate and causes the error:

      select
      taskinstan0_.ID_ as ID1_,
      ...
      taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM16_26_
      from
      JBPM_TASKINSTANCE taskinstan0_
      where
      taskinstan0_.TOKEN_=? and (taskinstan0_.END_ is null) and taskinstan0_.ISCANCELLED_=false


      manually running the query with the last phrase changed to
      taskinstan0_.ISCANCELLED_=0

      enables the query to be run. I've noticed that the Oracle create scripts that were generated have naturally created these 'booleans' as number fields. Does anyone recognize this issue?

      Thanks,
      -Britt