MySQL table name is not case sensitive setting method

After mysql is installed under windows system, it is not sensitive to the case of table names by default, but under linux, some systems need to be set manually. Log in as root, open and modify /etc/my.cnf; under the [mysqld] node, add a line: lower_case_table_names=1.

Restart mysql service service mysql restart

Pit:

Error creating bean with name 'sysJobController': Unsatisfied dependency expressed through field ' jobService'; nested exception is

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysJobServiceImpl': Invocation of init method failed;

nested exception is org.quartz.JobPersistenceException: Couldn't check for existence of job: Table 'ry.QRTZ_JOB_DETAILS' doesn't exist [See nested exception:



 java.sql.SQLSyntaxErrorException: Table'ry.QRTZ_JOB_DETAILS' doesn't exist]

< p> In fact, there is this table, but it is very depressing to report this error. The reason is that it is case sensitive

Error creating bean with name 'sysJobController': Unsatisfied dependency expressed through field 'jobService'; nested exception is

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysJobServiceImpl': Invocation of init method failed;

nested exception is org.quartz.JobPersistenceException: Couldn't check for existence of job: Table 'ry.QRTZ_JOB_DETAILS' doesn't exist [See nested exception:



 java.sql.SQLSyntaxErrorException: Table'ry.QRTZ_JOB_DETAILS' doesn't exist]

< p>