Bug 547953 - SQL Anywhere pessimistic locking is broken
Summary: SQL Anywhere pessimistic locking is broken
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 10
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-05 09:45 EDT by Martin Krause CLA
Modified: 2022-06-09 10:10 EDT (History)
0 users

See Also:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Krause CLA 2019-06-05 09:45:59 EDT 
Bugfix 462511 has changed the locking behaviour for Sybase by using
"FOR UPDATE AT ISOLATION SERIALIZABLE"
instead of
"HOLDLOCK"

This also changed the behaviour of the derived SQLAnywherePlatform class.

But it seams that SQL Anywhere does not support the "AT ISOLATION" phrase.

Locking a record with pessimistic locking now leads to the error:
[SAP][JDBC Driver][SQL Anywhere]Syntax error at 'AT' in row 1
Comment 1 Eclipse Webmaster CLA 2022-06-09 10:10:22 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink