The database table data cannot be obtained normally in centos.

 

Recently, the customer requested to install the application under centos, so they had the opportunity to get in touch with centos. By the way, they also learned about the general centos operations and MySQL.

Currently, the entire technical framework uses JSF (richfaces, facelets) + spring + JPA (openjpa). Instead of using database-dependent triggers or stored procedures, all business logic is executed on the Web server, therefore, you do not need to worry about porting the database. However, a system that runs normally in Windows cannot obtain table content in Linux. Because of database initialization, it was initially reflected in a few table data that needs to be manually maintained, but eventually found that it was originally caused by Case sensitivity issues!

Procedure:

1. In Windows, use the mysql client tool "navicat" to export the current database to the bsmf. SQL file. Note: In the exported. SQL file, all table names are in lower case.

2. Copy the exported. SQL file to Linux and import it to the required database.

3. Start the Web server and access the service. Problem: many tables cannot be accessed.

4. Run the "show tables;" command in MySQL to find that the table names are repeated. The duplicate table names are case-sensitive, and the uppercase table names are the same as the corresponding entity bean names. Problem Found: The table name is case-insensitive and the data cannot be accessed.

This article was migrated from other blogs.