嵌入式 mysql_free_version出现长时间不操作会自动关闭连接解决方法（有代码）

最新推荐文章于 2021-06-01 15:17:45 发布

ToPDCA

最新推荐文章于 2021-06-01 15:17:45 发布

阅读量819

点赞数

分类专栏：嵌入式

本文链接：https://blog.csdn.net/skdkjzz/article/details/17510203

版权

嵌入式专栏收录该内容

928 篇文章 16 订阅

订阅专栏

每次在使用数据库的时候就去尝试连接数据，如果连接失败则关闭数据库，重新初始化：

void *joseph_db_connect(void *in)
{
//to connect the db
MYSQL_DB_JOSEPH *db = in;
int res = 0;
char value = 1;

db->conn_ptr = mysql_real_connect(db->conn_ptr, db->db_host,\
db->db_user, db->db_pass, db->db_name, 0, NULL, 0);

mysql_options(db->conn_ptr, MYSQL_OPT_RECONNECT, (char *)&value);

        if (db->conn_ptr) {
           // printf("Connection success %d\n",EXIT_SUCCESS);
        } else {
            printf("DB connection failed ERROR %s\n", mysql_error(db->conn_ptr));
        }
return db;

}

int jrm_test_db_connect(void * in)
{
  int mysql_connect_err = 0;
  MYSQL_DB_JOSEPH *db = (MYSQL_DB_JOSEPH *)in;
  mysql_connect_err = mysql_ping(db->conn_ptr);
  eric_print("mysql_connect_err %d\n", mysql_connect_err);
  if(mysql_connect_err !=0)
  {
   eric_print("mysq client connected is done\n");
   jrm_db_close(db);
   jrm_db_init();
   return -1;
  }

return 1;

}

void *get_jrm_db_ptr(void)
{
MYSQL_DB_JOSEPH *db = &joseph_db;

if ( jrm_test_db_connect(db) < 0)
{
  eric_print("The db is colse connected\n");

  db = &joseph_db;
}
else
  eric_print("The db is connected ok\n");

return db;

}