• centos下mysql中table大小写改为不敏感


    项目由win系统部署到linux系统下,启动项目报错如下:

    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecg-boot.QRTZ_LOCKS' doesn't exist
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
            at com.mysql.jdbc.Util.getInstance(Util.java:372)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2034)
            at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52)
            at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeQuery(HikariPreparedStatementProxy.java)
            at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)
    

    其实一看提示信息就感觉差不多了,QRTZ_LOCKS是大写,但是数据库中是小写qrtz_locks。 其实就是linux 表名不区分大小写,解决办法。

    vi /etc/my.cnf 
    在 [mysqld] 节中添加: 
    lower_case_table_names=1
    

    然后重启MySQL(在根目录下运行命令即可):

    systemctl restart mysql
    

    就可以了。

  • 相关阅读:
    SPOJ LCS2
    SPOJ NSUBSTR
    1977: [BeiJing2010组队]次小生成树 Tree
    2002: [Hnoi2010]Bounce 弹飞绵羊
    P3690 【模板】Link Cut Tree (动态树)
    P2093 [国家集训队]JZPFAR
    2648: SJY摆棋子
    HDU 2966 In case of failure
    bzoj 一些题目汇总
    BZOJ3653谈笑风生——可持久化线段树+dfs序
  • 原文地址:https://www.cnblogs.com/eternityz/p/12243373.html
Copyright © 2020-2023  润新知