Change spring jpa existing table column type

Question

I'm using spring boot and jpa and I have an existing table with attribute as VARCHAR 255:

@Column(name = "description")
private String description;

I tried to change it to longtext with no success:

@Column(name = "description", columnDefinition = "longtext")
private String description;

My configuration in the application.properties file regarding Hibernate ddl is set to update:

spring.jpa.hibernate.ddl-auto = update

Is it possible to change VARCAR 255 to longtext? if it does, How do I do it?

Thanks, Avi

As far I know you have to do it manually by mySQL workbench or something else. Property type are not changed if it is defined once. So do it manually! — Avijit Barua, Aug 11 '19 at 12:41

score 3 · Answer 1 · answered Aug 12 '19 at 07:20

3

spring.jpa.hibernate.ddl-auto=update

will not do following changes

Refer here for more details

answered Aug 12 '19 at 07:20

MyTwoCents

this doesn't answer the question "how to update field type?". This could have been a comment. – nayakasu Mar 16 '23 at 11:55

score 1 · Answer 2 · answered Aug 11 '19 at 13:35

1

spring-data-jpa ddl ‘update’ will not change exist colums，neither update nor delete.

answered Aug 11 '19 at 13:35

steven.tong

1

then what will? – Henrik Varga Aug 20 '22 at 11:16
1

I mean how do we update the tables for existing entities for example if we delete a field from a JPA Entity or change the type of it it won't be represented in the database – Henrik Varga Aug 20 '22 at 11:21

score 1 · Answer 3 · answered Dec 01 '22 at 11:15

I also faced the same issue Your current configuration won't update

The best way to do this is through migrations using flyway Documentation : https://flywaydb.org/documentation/

you can write sql queries in your project and alter the same column in your entity.

3 Answers3