I was working on some data migration tasks. Remote database is MySQL running on Amazon RDS. To improve the speed, I firstly imported data into my local MySQL instance on Windows, then restored the data to remote database. But when application started, it couldn’t find any table. This is because Hibernate is looking for table names with different cases.
In Java code, entities are annotated like below:
1 2 3
When data was imported locally, the table names had become to lower-case, like
user, but not
User that Hibernate was looking for.