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

[Olivier.ch]

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#4089718

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