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

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

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

Mon, 29 December 2008 04:51

Eclipse User

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

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

Mon, 29 December 2008 07:49

Eclipse User

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.

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

Mon, 29 December 2008 09:29

Eclipse User

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

Previous Topic:	Dali JPA Tools 2.1 now available for download
Next Topic:	Converting from Hibernate composite-element mapping

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 03:06:11 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter