[ODE-741] Improve hibernate_sequence queries for Oracle

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.3, 2.0-beta2
• Fix Version/s: 1.3.4
• Component/s: BPEL Runtime
• Assignee: Rafal Rusin
• Reporter: Rafal Rusin
• Created: 17/Dec/09 16:06
• Updated: 11/Feb/10 18:41
• Resolved: 11/Feb/10 16:13

Description

Currently, HObject generator is set to native, which under Oracle runs a lot of queries:
SELECT hibernate_sequence.NEXTVAL FROM DUAL;

The generator should be changed to something like seqhilo for group ID allocations.