Eclipse Community Forums: EclipseLink » how to extend the DDL output (indexes, ..)

Help

Home

Home » Eclipse Projects » EclipseLink » how to extend the DDL output (indexes, ..)

Show: Today's Messages :: Show Polls :: Message Navigator

how to extend the DDL output (indexes, ..) [message #384364]

Mon, 29 December 2008 09:51

Neuhauser Bernhard

Messages: 4
Registered: July 2009

Junior Member

Hi,

Is it possible to create indexes using EclipseLink?

I know that JPA 1 does not support Indexes, but as far as im aware of,
it should be part of JPA 2. In Hibernate it was possible using the
proprietary @Index annotation.

Whats best practice to create indexes or maybe also other RDBMS features
like triggers?

Or is the ddl generation output more like some kind of template which
will never see a production database?

regards,
Bernhard

Report message to a moderator

Re: how to extend the DDL output (indexes, ..) [message #384367 is a reply to message #384364]

Mon, 29 December 2008 12:49

Tom Eugelink

Messages: 810
Registered: July 2009

Senior Member

Personally I think a database is more important that the mapping layer, so I never let it generate my tables; database first, mapping second. There are things, like triggers, that probably never will be supported through JPA (since the language dialects between databases differ way to much).

That said, I still hope that there will be a better trigger support on JPA level; the @PreSave annotation and friends have some issues.

Report message to a moderator

Re: how to extend the DDL output (indexes, ..) [message #385168 is a reply to message #384364]

Mon, 29 December 2008 14:29

Gordon Yorke

Messages: 78
Registered: July 2009

Member

Specifing the index through annotation is not in the Public Draft of JPA
2.0 and I do not expect it to be part of the Specification. The only way
to specify index currently is to provide a "columnDefinition" to the
@Column annotation.
When designing a database one should consider the DDL generation of JPA to
be a helpful tool. DDL generation from JPA should not be considered a
replacement for thorough database design.

--Gordon

Report message to a moderator

Previous Topic:	Dali JPA Tools 2.1 now available for download
Next Topic:	ddl-generation separator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 29 02:06:55 GMT 2017

.:: Contact :: Home ::.