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

Bug 340329

Summary:

Enhance CREATE TABLE statement with prefix

Product:

z_Archived

Reporter:

Xu XIANG <xu.xiang>

Component:

Eclipselink

Assignee:

Project Inbox <eclipselink.foundation-inbox>

Status:

NEW ---

QA Contact:

Severity:

enhancement

Priority:

CC:

adrian.goerler, christopher.delahunt, eclipselink.foundation-inbox, konstantin.schwed, krum.tsvetkov, reiner.singer, sabine.heider

Version:

unspecified

Flags:

adrian.goerler: iplog+

Target Milestone:

---

Hardware:

All

OS:

All

Whiteboard:

Attachments:

Description	Flags
patch for create table prefix	adrian.goerler: iplog+
enhancement proposal	adrian.goerler: iplog+

Description Xu XIANG

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

2011-03-17 11:33:25 EDT

Created attachment 191431 [details]
patch for create table prefix

Comment 2 Adrian Goerler

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

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

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

2022-06-09 10:03:48 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink