How do I specify a partial index using Hibernate / JPA annotations? E.g. an index with a "where" constraint:


As you can see, this is necessary to express a constraint whereby only a single entry in a table can have a particular boolean flag set to true.

If this is not possible using regular JPA annotations, how can I instruct Hibernate to run custom SQL at table-creation time? I can find documentation on running custom SQL for queries, but nothing for the actual schema generation.

You don't have this possibility. That's why you should use FlywayDB and define incremental migration scripts instead of the HBM2DDL tool which is not meant for production systems.

Thanks, but how is this possible if you want to use Envers? The documentation says to use hibernate.hbm2ddl.auto to generate the Envers tables: http://docs.jboss.org/hibernate/orm/5.2 ... tml#envers

It also mentions an alternative of using EnversSchemaGenerator, but this class does not exist anymore.

Is the idea to use HBM2DDL in development, then export the schema, and then run that using FlywayDB or Dropwizard?

The last sentence is exactly what you should be doing. You can use the HBMDDL initially to generate the first DDL script, and then you can use incremental migration scripts to update it progressively.