com.mysql.jdbc.PacketTooBigException

  [plaintext]
1
2
Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4513915 > 4194304).
You can change this value on the server by setting the max_allowed_packet' variable.

Ubuntu 数据库查询不存在

原因

Mybatis查询表名大小写是不固定的。

一般的系统是不区分表名称的大小写的。但是Ubuntu下MySQL是区分大小写的。需额外设置:

查询

Default is:

  [plaintext]
1
2
3
4
5
6
7
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 0     |
+------------------------+-------+

解决方式

编辑 my.cnf：

  [plaintext]
1
vi /etc/mysql/my.cnf

在 [mysqld] 下添加以下行：

  [plaintext]
1
lower_case_table_names=1

重启 MySQL：

  [plaintext]
1
/etc/init.d/mysql restart
  [plaintext]
1
2
3
4
5
6
7
8
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 1     |
+------------------------+-------+
2 rows in set (0.00 sec)