Unique « Schema « JPA Q&A

  1. JPA Q&A
  2. Schema
  3. Unique




1. Unique Constraint Not Enforce on SchemaExport of Hibernate    stackoverflow.com

I am quite unsure why my entity class does not create my required table schema 

@Entity
@Table(name = "User")
public class User implements Serializable {
    private Long id;
    ...

2. SchemaExport and unique-key    forum.hibernate.org

I use SchemaExport to generate a mysql table called userandrole. The table has an internalId, which is the PK. It also has a unique key (index) comprising roleName and userName. The interesting thing is that this unique key generated for the table ignores the specified key name (key1). It uses the first column name of the composite key, ie, roleName. I ...

3. Problem Mapping Unique Database Schema    forum.hibernate.org

We have an existing schema that applies the following pattern: Tables A, B, and C all have a one-to-many relationship to Table X. The data model supports this through two columns on Table X: a generic ENTITY_KEY column, and an ENTITY_TYPE column. The ENTITY_KEY is the foreign key value to the parent table (each has surrogate indentity primary keys), and the ...

4. Cannot create unique column using SchemaExport    forum.hibernate.org

5. Generating unique indexs with SchemaExportTask    forum.hibernate.org

hej, Want to generate a unique index with the SchemaExportTask. For example, a table like: --- Resource --- id: long type: String name: String has a primary key consisting of the ID column (taken care of by the id element in the mapping document). What would like to produce (with SchemaExportTask) is a unique index made up of "name,type" pairs. No ...

6. update schema with unique_key    forum.hibernate.org

I have a situation where I need to add an uniqueness constraint to an existing table column. I updated the hbm file and added the unique-key in the right place, then executed a query to the table. The table does not make the adjustment. The only way I can get the table to accept the uniqueness constraint is by dropping it ...