Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I don't think hibernate provides a way to manage the mappings the way you're describing. You can create your own <code>UserType</code> (<a href="https://community.jboss.org/wiki/Java5EnumUserType" rel="nofollow">https://community.jboss.org/wiki/Java5EnumUserType</a>) but every time you add a new enum value you will have to change the logic in the <code>UserType</code> to map the new field as well.</p> <p>The alternative will be to convert this into a one to many relationship. Your point is basically that if you want to add more fields you will have to change the signature of <code>listEntities</code> but also you will have to modify your table.</p> <p>So, instead you can create a table that will contain your entity types and have a @OneToMany` relationship to it from your entity. For example:</p> <p>Define your flags as required:</p> <pre><code>public enum Flags { EDITABLE, REVIEW_NEEDED, ACTIVE } </code></pre> <p>Create a one-to-many relationship to <code>EntityType</code>:</p> <pre><code>@Entity @Table( name="entity" ) public class Entity implements Serializable { @OneToMany(mappedBy = "entity") public Set&lt;EntityType&gt; getEntityTypes() { return entityTypes; } </code></pre> <p>And a many-to-one to <code>Entity</code>:</p> <pre><code>@Entity @Table( name="entityType" ) public class EntityType implements Serializable { @Id private Integer id; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "ENTITY_ID") private Entity entity; @Enumerated(EnumType.STRING) private Flag entityType; ... } </code></pre> <p>PD: Please note the code is just an example and is not complete or tested.</p>
    singulars
    1. This table or related slice is empty.
    1. POMap some boolean properties as enum Set in Hibernate
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEduardo Sanchez-Ros
    1. USEduardo Sanchez-Ros
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't consider the need of creating a relation for that. I'll just check if I can achieve something with the `EnumUserType`. Thanks!
      singulars
      1. PO
      1. USXtreme Biker
    2. COPotentially you could achieve it with `EnumUserType` but every time you add a new flag you will have to change the database to add a new boolean, the mapping in the user type and add a new value to your enumeration whereas the other approach you won't have to change the database at all, just add new enumerations
      singulars
      1. PO
      1. USEduardo Sanchez-Ros
    3. COWhat it really matters here is maintaining the interface as it is. Once that achieved I only want to tell hibernate that enum matches the boolean values. I just want to be able to save some new enum value in the `Set` and have the corresponding boolean value set to 1. Changing the mapping itself to add new values is not a problem, it's not going to be something usual.
      singulars
      1. PO
      1. USXtreme Biker
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload