Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 289163

Summary: use of reserved SQL keywords in JUnit tests cause tests to fail on Symfoware platform
Product: z_Archived Reporter: Dies Koper <dieskun>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: CLOSED DUPLICATE QA Contact:
Severity: normal    
Priority: P4 CC: eclipselink.orm-inbox, tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Whiteboard:
Attachments:
Description Flags
patch addressing most of the issues none

Description Dies Koper CLA 2009-09-10 21:16:59 EDT 
Some of JPA's JUnit tests use SQL reserved keywords in table and column names.
Symfoware DB does not accept these keywords as table or column names unless enclosed in double quotes.
The keywords in the JUnit tests that are currently causing issues are LANGUAGE, VALUE, DOMAIN and SEQUENCE.
Comment 1 Dies Koper CLA 2009-09-15 09:06:00 EDT 
ROLE too.
Comment 2 Tom Ware CLA 2009-09-15 13:37:51 EDT 
Created attachment 147233 [details]
patch addressing most of the issues
Comment 3 Tom Ware CLA 2009-09-15 14:13:37 EDT 
I have checked in a number of changes for this bug.

In general, I have changed names instead of quoting:

LANGUAGE became LANG
VALUE became VAL
DOMAIN and ROLE have been renamed to strings that are appropriate to the model

Some changes have been made related to SEQUENCE, but these changes are a little more indepth.  More changes will be made as the changes for bug 288715 are reviewed.
Comment 4 Tom Ware CLA 2009-09-17 09:20:28 EDT 
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

This bug is set to future because it is to help with the construction of SymfowarePlatform which is not currently scheduled to go into any particular release.
Comment 5 Tom Ware CLA 2010-02-23 10:35:07 EST 
Remaining changes for this issue being handled under main Symfoware contribution

*** This bug has been marked as a duplicate of bug 288715 ***
Comment 6 Eclipse Webmaster CLA 2022-06-09 10:31:50 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink