[jbpm-issues] [JBoss JIRA] Updated: (JBPM-2522) sql syntax error when removing processdefinition

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 Assignee: Tom Baeyens Fix For: jBPM 4.2 Original Estimate: 4 hours Remaining Estimate: 4 hours 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); }