Styjun

Can you feel passing through the sound barrier in an F-16?

Why did this happen to Thanos's ships at the end of "Avengers: Endgame"?

Does the benefit of the Flames of Phlegethos feat that allows rerolls of fire damage affect its final benefit?

Why doesn't the Falcon-9 first stage use three legs to land?

(Why) May a Beit Din refuse to bury a body in order to coerce a man into giving a divorce?

Were there 486SX revisions without an FPU on the die?

Can I switch to third-person while not in 'town' in Destiny 2?

What is the evidence on the danger of feeding whole blueberries and grapes to infants and toddlers?

Have only girls been born for a long time in this village?

Why we don't have vaccination against all diseases which are caused by microbes?

When translating the law, who ensures that the wording does not change the meaning of the law?

Church Booleans

Most practical knots for hitching a line to an object while keeping the bitter end as tight as possible, without sag?

How does turbine efficiency compare with internal combustion engines if all the turbine power is converted to mechanical energy?

Natural Pattern

Was this pillow joke on Friends intentional or a mistake?

How to avoid using System.String with Rfc2898DeriveBytes in C#

IndexOptimize - Configuration

What is the hex versus octal timeline?

Can you be convicted for being a murderer twice?

How to "know" if I have a passion?

Do ability scores have any effect on casting Wish spell

Why is my Earth simulation slower than the reality?

Was Switzerland really impossible to invade during WW2?

How to use the discriminator of single table inheritance in a unicity constraint?

Single Table Inheritance in DjangoRails Single Table InheritanceHibernate, single table inheritance and using field from superclass as discriminator columnSingle Table Inheritance or Class Table Inheritance?Single Table Inheritance QueryCan I remove the discriminator column in a Hibernate single table inheritance?Can a single table inheritance entity extend a class table inheritance entity?JPA Query for collection map join tablePostgreSQL table inheritance and constraintsOneToMany Relationship with 3 entity class using JPA and spring boot

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm setting up the account activation and password recovery on my application. In both case an email is sent with a link containing a token.

I need to make sure previous tokens become invalid when a new one is sent. In other words, a new link sent by email make the previous link obsolete.

I'm using the same table for all types of tokens. The unicity constraint should be on the duo email-tokenType.

So I tried to use the SINGLE_TABLE inheritance strategy like this :

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "TOKEN_TYPE")
public abstract class UserToken 

 @EmbeddedId
 private UserTokenIdentity userTokenIdentity;

 private String token;



@Embeddable
public class UserTokenIdentity 

 private String email;

 private String tokenType;


@Entity
@DiscriminatorValue("A")
public class ActivationToken extends UserToken 



@Entity
@DiscriminatorValue("P")
public class ResetPasswordToken extends UserToken 

The problem is i can't do that because of the following error :

Caused by: org.hibernate.DuplicateMappingException: Table [user_token] contains physical column name [token_type] referred to by multiple physical column names: [tokenType], [TOKEN_TYPE]

That's because i used the field in primary key AND as discriminator for the inheritance. I don't know why but it seems to not be allowed.

Can you give me your opinion on how should I do this ?

I'm using liquibase to create manually the database.

Thank you

spring-boot spring-data-jpa single-table-inheritance liquibase-hibernate

share|improve this question

edited Mar 27 at 16:54

flodor2

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

add a comment | 

0

I'm setting up the account activation and password recovery on my application. In both case an email is sent with a link containing a token.

I need to make sure previous tokens become invalid when a new one is sent. In other words, a new link sent by email make the previous link obsolete.

I'm using the same table for all types of tokens. The unicity constraint should be on the duo email-tokenType.

So I tried to use the SINGLE_TABLE inheritance strategy like this :

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "TOKEN_TYPE")
public abstract class UserToken 

 @EmbeddedId
 private UserTokenIdentity userTokenIdentity;

 private String token;



@Embeddable
public class UserTokenIdentity 

 private String email;

 private String tokenType;


@Entity
@DiscriminatorValue("A")
public class ActivationToken extends UserToken 



@Entity
@DiscriminatorValue("P")
public class ResetPasswordToken extends UserToken 

The problem is i can't do that because of the following error :

Caused by: org.hibernate.DuplicateMappingException: Table [user_token] contains physical column name [token_type] referred to by multiple physical column names: [tokenType], [TOKEN_TYPE]

That's because i used the field in primary key AND as discriminator for the inheritance. I don't know why but it seems to not be allowed.

Can you give me your opinion on how should I do this ?

I'm using liquibase to create manually the database.

Thank you

spring-boot spring-data-jpa single-table-inheritance liquibase-hibernate

share|improve this question

edited Mar 27 at 16:54

flodor2

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

add a comment | 

I'm setting up the account activation and password recovery on my application. In both case an email is sent with a link containing a token.

I need to make sure previous tokens become invalid when a new one is sent. In other words, a new link sent by email make the previous link obsolete.

I'm using the same table for all types of tokens. The unicity constraint should be on the duo email-tokenType.

So I tried to use the SINGLE_TABLE inheritance strategy like this :

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "TOKEN_TYPE")
public abstract class UserToken 

 @EmbeddedId
 private UserTokenIdentity userTokenIdentity;

 private String token;



@Embeddable
public class UserTokenIdentity 

 private String email;

 private String tokenType;


@Entity
@DiscriminatorValue("A")
public class ActivationToken extends UserToken 



@Entity
@DiscriminatorValue("P")
public class ResetPasswordToken extends UserToken 

The problem is i can't do that because of the following error :

Caused by: org.hibernate.DuplicateMappingException: Table [user_token] contains physical column name [token_type] referred to by multiple physical column names: [tokenType], [TOKEN_TYPE]

That's because i used the field in primary key AND as discriminator for the inheritance. I don't know why but it seems to not be allowed.

Can you give me your opinion on how should I do this ?

I'm using liquibase to create manually the database.

Thank you

spring-boot spring-data-jpa single-table-inheritance liquibase-hibernate

share|improve this question

edited Mar 27 at 16:54

flodor2

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "TOKEN_TYPE")
public abstract class UserToken 

 @EmbeddedId
 private UserTokenIdentity userTokenIdentity;

 private String token;



@Embeddable
public class UserTokenIdentity 

 private String email;

 private String tokenType;


@Entity
@DiscriminatorValue("A")
public class ActivationToken extends UserToken 



@Entity
@DiscriminatorValue("P")
public class ResetPasswordToken extends UserToken 

Caused by: org.hibernate.DuplicateMappingException: Table [user_token] contains physical column name [token_type] referred to by multiple physical column names: [tokenType], [TOKEN_TYPE]

share|improve this question

edited Mar 27 at 16:54

flodor2

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

share|improve this question

edited Mar 27 at 16:54

flodor2

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges

asked Mar 27 at 15:48

flodor2flodor2

2277 bronze badges