Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/Schema Generation/Appending strings to CREATE TABLE statements"
< EclipseLink | UserGuide | JPA | Advanced JPA Development | Schema Generation
| Line 4: | Line 4: | ||
|eclipselink=y | |eclipselink=y | ||
|eclipselinktype=JPA | |eclipselinktype=JPA | ||
| − | |||
| − | |||
}} | }} | ||
| Line 13: | Line 11: | ||
>>>>>> THIS PAGE IS IN PROGRESS. PLEASE SEE DISCUSSION PAGE. <<<<<< | >>>>>> THIS PAGE IS IN PROGRESS. PLEASE SEE DISCUSSION PAGE. <<<<<< | ||
===Example=== | ===Example=== | ||
| − | + | Assuming it has an ID annotated, an <tt>eclipselink-orm.xml</tt> file containing... | |
<pre><entity class="Comment"> | <pre><entity class="Comment"> | ||
<table name="DDL_COMMENT" creation-suffix="COMMENT='User Comment Table'"/> | <table name="DDL_COMMENT" creation-suffix="COMMENT='User Comment Table'"/> | ||
</entity></pre> | </entity></pre> | ||
| − | + | ...results in the following creation statement: | |
<pre> | <pre> | ||
CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table' | CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table' | ||
</pre> | </pre> | ||
| − | + | If it is coupled with the following persistence property... | |
<pre><property name="eclipselink.ddl.default-table-suffix" value="engine=InnoDB"/></pre> | <pre><property name="eclipselink.ddl.default-table-suffix" value="engine=InnoDB"/></pre> | ||
| − | + | it results in the following creation statement: | |
<pre> | <pre> | ||
CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table' engine=InnoDB | CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table' engine=InnoDB | ||
Revision as of 11:53, 1 February 2011
EclipseLink JPA
| EclipseLink | |
| Website | |
| Download | |
| Community | |
| Mailing List • Forums • IRC • mattermost | |
| Issues | |
| Open • Help Wanted • Bug Day | |
| Contribute | |
| Browse Source |
Appending Strings to CREATE TABLE Statements
>>>>>> THIS PAGE IS IN PROGRESS. PLEASE SEE DISCUSSION PAGE. <<<<<<
Example
Assuming it has an ID annotated, an eclipselink-orm.xml file containing...
<entity class="Comment"> <table name="DDL_COMMENT" creation-suffix="COMMENT='User Comment Table'"/> </entity>
...results in the following creation statement:
CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table'
If it is coupled with the following persistence property...
<property name="eclipselink.ddl.default-table-suffix" value="engine=InnoDB"/>
it results in the following creation statement:
CREATE TABLE DDL_COMMENT (ID INTEGER) COMMENT='User Comment Table' engine=InnoDB
