Bug 340329 - Enhance CREATE TABLE statement with prefix
Summary: Enhance CREATE TABLE statement with prefix
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-17 11:30 EDT by Xu XIANG CLA
Modified: 2022-06-09 10:03 EDT (History)
7 users (show)

See Also:
adrian.goerler: iplog+

Attachments
patch for create table prefix (45.50 KB, patch)
2011-03-17 11:33 EDT, Xu XIANG CLA 		adrian.goerler: iplog+
Details | Diff
enhancement proposal (78.17 KB, patch)
2011-03-28 10:24 EDT, Adrian Goerler CLA 		adrian.goerler: iplog+
Details | Diff
Show Obsolete (1) View All 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 Xu XIANG CLA 2011-03-17 11:30:26 EDT 
Build Identifier: 

Similar to the the feature request Bug 214519 (suffix enhancement) I would like to request the enhancement of CREATE TABLE statement with prefix. 
EclipseLink internally already uses prefix for e.g. CREATE TEMPORARY TABLE. For certain database platform I need to use prefix to perform specific table creation.

For this purpose I prepared a patch. In next days I will try to attach a corresponding test case.

Thanks and best regards

Reproducible: Always
Comment 1 Xu XIANG CLA 2011-03-17 11:33:25 EDT 
Created attachment 191431 [details]
patch for create table prefix
Comment 2 Adrian Goerler CLA 2011-03-28 10:24:06 EDT 
Created attachment 192007 [details]
enhancement proposal

Proposal:
Allow to overwrite "CREATE TABLE" with persistence-unit specific keywords using the property "eclipselink.ddl.table-creation-prefix". Additionally, allow overriding this in eclipselink-orm.xml using the attribute creation-prefix on all table mappings.

Test CORE-SRG, JPA-SRG and WDF: OK 
Dedicated test in DDLGenerationJUnitTestSuite (OK)
Comment 3 Adrian Goerler CLA 2011-03-28 10:25:35 EDT 
I assume the comment https://bugs.eclipse.org/bugs/show_bug.cgi?id=214519#c10
also applies here.
Comment 4 Adrian Goerler CLA 2011-04-01 11:48:58 EDT 
This discussion is associated with this ticket:

http://dev.eclipse.org/mhonarc/lists/eclipselink-dev/msg05607.html
Comment 5 Eclipse Webmaster CLA 2022-06-09 10:03:48 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink