Bug 777834 (SOA-360) - The jBPM does not work with PostgreSQL/Oracle - constraint violations
Summary: The jBPM does not work with PostgreSQL/Oracle - constraint violations
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-360
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation, JBossESB
Version: 4.2 CR1
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.2 CR3
Assignee: Joshua Wulf
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-01-23 13:48 UTC by Jiri Pechanec
Modified: 2014-10-19 22:59 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-02-07 04:10:55 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 777576 0 urgent CLOSED QE BLOCKERS (links to all blocked QE tests) 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-360 0 None None None Never

Internal Links: 777576

Description Jiri Pechanec 2008-01-23 13:48:40 UTC 
Affects: Documentation (Ref Guide, User Guide, etc.), Release Notes
Date of First Response: 2008-02-04 07:47:31
project_key: SOA

See JBESB-1511
Comment 1 Jiri Pechanec 2008-01-23 13:48:47 UTC 
Link: Added: This issue depends JBESB-1511
Comment 2 Jiri Pechanec 2008-01-23 13:49:08 UTC 
Link: Added: This issue related SOA-84
Comment 3 Mark Little 2008-02-04 12:47:31 UTC 
The ESB issue will be closed soon, leaving this as a docs issue only.

Josh, please look at Kevin's comment in JBESB-1511 for an indication of what we need to document in the notes.
Comment 4 Mark Little 2008-02-04 12:47:49 UTC 
Affects: Added: [Documentation (Ref Guide, User Guide, etc.), Release Notes]
Comment 5 Kevin Conner 2008-02-05 16:22:36 UTC 
The ESB issue has been closed but we still need to document this as a symptom of the optimistic locking.
Comment 6 Joshua Wulf 2008-02-07 02:28:50 UTC 
 JBPM operations fail with constraint violation exceptions using Oracle/PostgreSQL

When the server is under load JBPM operations have been observed to fail with a constraint violation exception when using Oracle or PostgreSQL. This has not been observed with MySQL. We've made calls to JBPM from the SOA server asynchronous and JBPM should retry these failures. It is a consequence of JBPM's optimistic locking policy.

   Further Information: http://jira.jboss.com/jira/browse/JBESB-1511.
Note You need to log in before you can comment on or make changes to this bug.