[jboss-user] [JBoss jBPM] - Re: Getting SQLGrammarException when installing jBPM BPEL 1.

[alex.guizar@jboss.com]

The query looks good to me:

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

so the problem must lie in the combination of database, JDBC driver and Hibernate dialect. Use org.hibernate.dialect.OracleDialect for Oracle 8 and earlier, org.hibernate.dialect.Oracle9Dialect for Oracle 9 and 10. If you are already doing so, please tell us your database/driver versions and connection settings.

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

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