sql syntax error when removing processdefinition ------------------------------------------------ Key: JBPM-2522 URL: https://jira.jboss.org/jira/browse/JBPM-2522 Project: jBPM Issue Type: Bug Security Level: Public (Everyone can see) Components: Runtime Engine Affects Versions: jBPM 4.1 Environment: checked on latest jbpm4 trunk source files Reporter: Sofie Ravyts When calling repositoryService.deleteDeployment(deploymentId); I get the following sql syntax error: "Unknown column 'myprocess' in 'where clause'" This is the sql statement that gets executed: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=myprocess-4 There should be quotes around myprocess-4 to fix the sql statement => see ProcessDefinitionQueryImpl: if (deploymentId!=null) { appendWhereClause("idProperty.deployment.dbid = "+deploymentId+" ", hql); } should be (imho) if (deploymentId!=null) { appendWhereClause("idProperty.deployment.dbid = '"+deploymentId+"' ", hql); } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira