Hello,

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">
 <classpath>
 <fileset dir="D:\java\jbpm-jpdl-3.2.GA" >
 <include name="**\*.jar"/>
 </fileset>
 </classpath>
 </taskdef>
 <deployprocess>

jbpmcfg="${PATH_PROJET}\bin\hibernate.cfg.xml" process="${PATH_PROJET}\jar\process.jar">

 </deployprocess>
 </target>

During this deployment a error occurs :

Hibernate:
[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)
...
BUILD FAILED
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 ?

Thank's

Olivier