[JBoss JIRA] Resolved: (JBPM-931) Create indexes for foreign keys in 3.1 branch
by Thomas Diesler (JIRA)
[ http://jira.jboss.com/jira/browse/JBPM-931?page=all ]
Thomas Diesler resolved JBPM-931.
---------------------------------
Fix Version/s: (was: jBPM 3.1.5)
Resolution: Out of Date
resolve out of date
> Create indexes for foreign keys in 3.1 branch
> ---------------------------------------------
>
> Key: JBPM-931
> URL: http://jira.jboss.com/jira/browse/JBPM-931
> Project: JBoss jBPM
> Issue Type: Bug
> Components: Core Engine
> Affects Versions: jBPM 3.1.4, jBPM 3.1.3, jBPM 3.1.2, jBPM 3.1.1, jBPM 3.1
> Reporter: David Lloyd
> Assigned To: Tom Baeyens
>
> Many users are using jBPM 3.1.x and do not have the ability to perform a major upgrade. However 3.1.x suffers from a significant problem in that many foreign keys do not have indexes (this problem was fixed for 3.2.0). This causes queries against these keys to scan the full table. In the case of database which use row locks for both reads and writes, this can lead to deadlock scenarios because many, many rows are locked unnecessarily. Tables are frequently queried by their foreign keys; that's why they exist. Therefore these columns should be indexed.
> (Relates to JBPM-735)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 6 months
[JBoss JIRA] Moved: (JBPM-1228) remove compiler warnings
by Thomas Diesler (JIRA)
[ http://jira.jboss.com/jira/browse/JBPM-1228?page=all ]
Thomas Diesler moved PVM-43 to JBPM-1228:
-----------------------------------------
Project: JBoss jBPM (was: The Process Virtual Machine)
Key: JBPM-1228 (was: PVM-43)
Component/s: PVM
(was: pvm)
> remove compiler warnings
> ------------------------
>
> Key: JBPM-1228
> URL: http://jira.jboss.com/jira/browse/JBPM-1228
> Project: JBoss jBPM
> Issue Type: Task
> Components: PVM
> Reporter: Tom Baeyens
>
> [javac] /qa/services/hudson/hudson_workspace/workspace/jbpm-pvm-jdk5/pvm/src/java/org/jbpm/pvm/internal/ejb/CommandReceiverMDB.java:182: warning: unmappable character for encoding UTF8
> [javac] * control must be performed - see ejb 2.1 ?17.3.5
> [javac] ^
> [javac] /qa/services/hudson/hudson_workspace/workspace/jbpm-pvm-jdk5/pvm/src/java/org/jbpm/pvm/internal/ejb/EnterpriseTimerSession.java:68: warning: unmappable character for encoding UTF8
> [javac] * EJB 2.1 ?22.4.4 If an entity bean is removed, the container must remove
> [javac] ^
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 6 months