[jboss-user] [JBoss jBPM] - JBPM Deployment Process SQL error
Olivier.ch
do-not-reply at jboss.com
Fri Sep 28 10:14:01 EDT 2007
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
More information about the jboss-user
mailing list