Spring, hibernate type mapping based on different database

Question

I have something like this for defining the hibernate type mapping in the entity class:

@Entity
@Table(name = "TEST_TABLE")
public class Test {

     @Type( type = "jsonb" )
     @Column(name = "CONTENT_FILES")
     private List<ContentFile> contentFiles;

}

which map an entity field to a custom defined hibernate type jsonb for supporting PostgreSQL DB.

I would like to change the mapping to another hibernate custom type json for supporting MSSQL DB.

Can I support both mappings in the same entity class?

I tried to use the @Profile annotation but it doesn't work.

@Profile("pgsql")
@Type( type = "jsonb" )
@Profile("mssql")
@Type( type = "json" )
@Column(name = "CONTENT_FILES")
private List<ContentFile> contentFiles;

Are you planning to connect your application to two different databases at the same time ?@Peter Chau — Lahiru Wijesekara
– Lahiru Wijesekara, Commented Jul 2, 2019 at 11:03
That is why the JPA spec allows an orm.xml in which you can override these things for a specific database. — M. Deinum
– M. Deinum, Commented Jul 2, 2019 at 14:21
@LahiruWijesekara I would like to connect only one of the database, based on the profile settings. — Peter Chau
– Peter Chau, Commented Jul 3, 2019 at 9:42
You can try out below solution and share your results@PeterChau — Lahiru Wijesekara
– Lahiru Wijesekara, Commented Jul 4, 2019 at 11:33

Lahiru Wijesekara · Accepted Answer · 2019-07-04 04:58:57Z

1

json and jsonb both data types are almost identical according to the PostgreSQL documentation.Therefor you don't have to maintain two different data types to keep json in MSSQL and in PostgreSQL . Please refer to below link of PostgreSQL documentation.

answered Jul 4, 2019 at 4:58

Lahiru Wijesekara

6721 gold badge10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring, hibernate type mapping based on different database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related