[jboss-user] [JBoss jBPM] - Re: Problem using mysql

jcv do-not-reply at jboss.com
Tue Apr 24 12:56:54 EDT 2007


I found my error, but i dont know howto solve it.
The problem is that hibernate is generation this query

  | select top ? job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_, job0_.DUEDATE_ as DUEDATE4_26_, job0_.PROCESSINSTANCE_ as PROCESSI5_26_, job0_.TOKEN_ as TOKEN6_26_, job0_.TASKINSTANCE_ as TASKINST7_26_, job0_.ISSUSPENDED_ as ISSUSPEN8_26_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_26_, job0_.LOCKOWNER_ as LOCKOWNER10_26_, job0_.LOCKTIME_ as LOCKTIME11_26_, job0_.EXCEPTION_ as EXCEPTION12_26_, job0_.RETRIES_ as RETRIES13_26_, job0_.NAME_ as NAME14_26_, job0_.REPEAT_ as REPEAT15_26_, job0_.TRANSITIONNAME_ as TRANSIT16_26_, job0_.ACTION_ as ACTION17_26_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_26_, job0_.GRAPHELEMENT_ as GRAPHEL19_26_, job0_.NODE_ as NODE20_26_, job0_.CLASS_ as CLASS2_26_ 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
  | 

and MySQL doenst use SELECT TOP.

I've already changed WEB-INF/classes/hibernate.cfg.xml and add    
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
  | 
 where else do i need to change it??

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

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



More information about the jboss-user mailing list