[JBoss JIRA] Created: (JBPM-2522) sql syntax error when removing processdefinition
by Sofie Ravyts (JIRA)
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
15 years, 2 months
[JBoss JIRA] Created: (JBPM-2036) StaleObjectStateException when timer firing leads to process end and timer has 'repeat' attribute set
by Martin Putz (JIRA)
StaleObjectStateException when timer firing leads to process end and timer has 'repeat' attribute set
-----------------------------------------------------------------------------------------------------
Key: JBPM-2036
URL: https://jira.jboss.org/jira/browse/JBPM-2036
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: jBPM 3.3.1 GA, jBPM-3.2.5.SP1
Reporter: Martin Putz
Assignee: Alejandro Guizar
Fix For: jBPM 3.2.6 GA
With the following timer definition on a state node
<state name='state1'>
<timer name='timer-to-end-with-repeat' duedate='1 second' repeat='5 seconds'>
<action class='org.jbpm.scheduler.exe.TimerDbTest$Signal' />
</timer>
<transition name='to_end' to='end'/>
</state>
and the action class execute() method being
public void execute(ExecutionContext executionContext) throws Exception {
executionContext.leaveNode();
}
leads to:
2009-02-10 21:38:45,404 16508 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (JbpmJobExecutor:127.0.0.1:1:) Could not synchronize database state with session
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.job.Timer#86]
at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1769)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2412)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:226)
at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:131)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:197)
at org.jbpm.svc.Services.close(Services.java:243)
at org.jbpm.JbpmContext.close(JbpmContext.java:133)
at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:194)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:61)
If 'repeat' is not set, the process finishes just fine.
--
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
15 years, 2 months