2015 年 3月 30 日随笔档案 - Neil_Ling

mysql命令

摘要： 1、查询mysql timeout相关的变量值 SHOW VARIABLES LIKE "%timeout%" 2、可以插入部分字段的值（id字段自增） INSERT into weightTB(date,weightNum) values('2015-03-23 16:30:21','www')； 3、创建表 String createTB_sql = "CREATE TABLE "... 阅读全文

posted @ 2015-03-30 16:52 Neil_Ling 阅读(134) 评论(0) 推荐(0)

The last packet successfully received from the server was 2,926,157 milliseconds ago. The last packet sent successfully to the server was 2,926,158 milliseconds ago. is longer than the server configured value of 'wait_timeout'. 解决办法

摘要： Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 2,926,157 milliseconds ago. The last packet sent successfully to the ser... 阅读全文

posted @ 2015-03-30 16:11 Neil_Ling 阅读(1462) 评论(0) 推荐(0)

BAE hibernate c3p0数据库连接池

摘要：根据BAE官方文档：bae是不支持连接池的，但今天试验却能实现hibernate c3p0连接池，避免mysql连接超时 hibernate主配置文件hibernate.cfg.xml代码 org.hibernate.dialect.MySQL5Dialect jdbc:mysql://sqld.duapp.com:4050/数据库名 ... 阅读全文

posted @ 2015-03-30 16:09 Neil_Ling 阅读(490) 评论(0) 推荐(0)

Neil_Ling

公告