[jboss-user] [JBoss jBPM] - Oracle Error Keyword from missing

[AJanz]

i got an error using oracle with jbpm

the statement is 


  | select 
  |  job0_.ID_ as ID1_25_,
  |  job0_.VERSION_ as VERSION3_25_,
  |  job0_.DUEDATE_ as DUEDATE4_25_,
  |  job0_.PROCESSINSTANCE_ as PROCESSI5_25_,
  |  job0_.TOKEN_ as TOKEN6_25_,
  |  job0_.TASKINSTANCE_ as TASKINST7_25_,
  |  job0_.ISSUSPENDED_ as ISSUSPEN8_25_,
  |  job0_.ISEXCLUSIVE_ as ISEXCLUS9_25_,
  |  job0_.LOCKOWNER_ as LOCKOWNER10_25_,
  |  job0_.LOCKTIME_ as LOCKTIME11_25_,
  |  job0_.EXCEPTION_ as EXCEPTION12_25_,
  |  job0_.RETRIES_ as RETRIES13_25_,
  |  job0_.NAME_ as NAME14_25_,
  |  job0_.REPEAT_ as REPEAT15_25_,
  |  job0_.TRANSITIONNAME_ as TRANSIT16_25_,
  |  job0_.ACTION_ as ACTION17_25_,
  |  job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_25_,
  |  job0_.GRAPHELEMENT_ as GRAPHEL19_25_,
  |  job0_.NODE_ as NODE20_25_,
  |  job0_.CLASS_ as CLASS2_25_ 
  | from 
  |  JBPM_JOB job0_
  | where (job0_.LOCKOWNER_ is null
  |  or job0_.LOCKOWNER_=?) 
  |  and job0_.RETRIES_>0
  |  and job0_.DUEDATE_<=? 
  |  and job0_.ISSUSPENDED_<>1 
  |  order by job0_.DUEDATE_ asc	

i could execute it from a database client. no problem

but under jbpm i got

ORA-00923- FROM keyword not found where expected-

what may i have done wrong? 



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

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