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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...