[jboss-user] [JBoss jBPM] - JBPM Deployment Process SQL error

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