Change database type from HSQLDB to MySQL - table names too long

Support
,
#1

Hi all,

In a project with many entities, I’m trying to change the database engine from HSQLDB to MySQL.

The blocking problem is that MySQL refuse some table names because names are too long.

How I can manage the change?

Do I need to change all table names by hand in the Entity designer (field “Table”) ?
It is the above sufficient or there is another method to follow ?

Thank you for any help.

Ivano C.

#2

Hi Ivano,

In one way or another, you have to provide table names suitable for your database.
You can do it by using entity designer in Studio or by editing @Table annotation in entity classes directly.
After that, Studio will generate DDL scripts to create your database schema.

1 Like