1 Reply Latest reply on Jul 21, 2008 7:07 AM by Sebastian Herold

    JBPM Deployment Process SQL error

    Albrecht Olivier Newbie


      I am workin with JBPM 3.2 and mysql 4.1
      My schena of database is created by JBPM's script

      I did not change the JBPM script or database.
      I am tying to deploy my process with ant script :

      <target name="deploy.process" depends="jarizer">
       <taskdef name="deployprocess" classname="org.jbpm.ant.DeployProcessTask">
       <fileset dir="D:\java\jbpm-jpdl-3.2.GA" >
       <include name="**\*.jar"/>
      jbpmcfg="${PATH_PROJET}\bin\hibernate.cfg.xml" process="${PATH_PROJET}\jar\process.jar">

      During this deployment a error occurs :

      [deployprocess] /* named HQL query GraphSession.findLatestProcessDefinitionQuery */ select
      [deployprocess] top ? processdef0_.ID_ as ID1_0_,
      [deployprocess] processdef0_.NAME_ as NAME3_0_,
      [deployprocess] processdef0_.DESCRIPTION_ as DESCRIPT4_0_,
      [deployprocess] processdef0_.VERSION_ as VERSION5_0_,
      [deployprocess] processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_,
      [deployprocess] processdef0_.STARTSTATE_ as STARTSTATE7_0_
      [deployprocess] from
      [deployprocess] JBPM_PROCESSDEFINITION processdef0_
      [deployprocess] where
      [deployprocess] processdef0_.NAME_=?
      [deployprocess] order by
      [deployprocess] processdef0_.VERSION_ desc
      [deployprocess] 14:52:59,424 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
      [deployprocess] 14:52:59,424 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCR' at line 1
      [deployprocess] org.hibernate.exception.SQLGrammarException: could not execute query
      [deployprocess] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
      [deployprocess] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      D:\projets\test\jar\build.xml:53: couldn't deploy process archives : couldn't find process definition 'test1'

      I don't understand why because on my jar file the processdefinition.xml is define.

      Is somebody can help me, i don't what to change because it seems to come from my hibernate config file what comes from JBoss ?