c 连接mysql 变卡,使用C ++连接器的C ++ MySQL连接bad_alloc

Trying to build a simple mysql connection, but getting a bad_alloc and I can't figure out how to solve this, even looking at similar posts

here is my code

#include

#include

#include

#include

#include

#include

#include "mysql_connection.h"

#include "cppconn\driver.h"

#include "cppconn\statement.h"

#include "cppconn\connection.h"

#include "cppconn\exception.h"

#include "cppconn\prepared_statement.h"

#include "cppconn\statement.h"

using namespace std;

using namespace sql;

int main()

{

Driver *driver;

Connection *conn;

Statement *stmt;

driver = get_driver_instance();

conn = driver->connect("127.0.0.1:3306", "root", "root"); // breaks here

stmt = conn->createStatement();

stmt->execute("USE mydb");

return 0;

}

I'm using mysql-connector-c++-1.1.7

mysqlcppconn.lib is used as a dependencies

mysqlcppconn.dll is located in the same dir as the .exe is.

Here is the error Exception thrown at 0x000007FEFD39A06D in MysqlConn.exe: Microsoft C++ exception: std::bad_alloc at memory location 0x000000000014F5D0.

Thanks

解决方案

I also had this error. In my case I am compiling using VS2015 in Windows.

First time I choose compile static version of the MySQL lib. Then later I decided to compile the dynamic version. This time the error bad_alloc at memory went off.

The solution is rolling back the CPPCONN_PUBLIC_FUNC= configuration.

Go to project Property Pages, under C++ > Preprocessor > Preprocessor Definitions and remove the item CPPCONN_PUBLIC_FUNC=".