c++ mysql connection bad_alloc using c++ connector

Question

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 <iostream>
#include <stdlib.h>
#include <sstream>
#include <memory>
#include <string>
#include <stdexcept>

#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

mysqlcppconn.lib is used as a dependencies and it is located in the same dir as the .exe is -- A .lib file is used in the build process and has nothing to do with where the exe is located. It seems you aren't aware of what components are used to build your application and which components are involved in running your app. Maybe the MySql DLLs that you're supposed to be using at runtime are not compatible with your executable? — PaulMcKenzie
– PaulMcKenzie, Commented Aug 23, 2016 at 12:55
sorry, I meant .dll, I'll fix this. I followed this introduction and used dymanic instead of statis build dev.mysql.com/doc/connector-cpp/en/… according to this I don't need any mysql dlls anymore I guess? :( — abdoe
– abdoe, Commented Aug 23, 2016 at 12:56
Well, you need to make sure that the DLL's (it seems they use the C++ standard library), are compatible with your compiler's version of the standard library. In other words,if those DLL's were created using VS 2013, and you're using another version of Visual Studio, then there will be runtime issues. If it's a static library, the same thing applies. The static library must be built with the same compiler, compiler options, etc. as your application. — PaulMcKenzie
– PaulMcKenzie, Commented Aug 23, 2016 at 12:58
I used this connector mysql-connector-c++-1.1.7-winx64.msi with library machine type x64. Could you kindly let me know what I can do to check what you suggested? — abdoe
– abdoe, Commented Aug 23, 2016 at 13:01
hmm okay, yes I'm using vs2015 But I wonder whiy i can find no information about a dll for visual studio 2015, I cant be the only one having this troubles. Maybe I'm the only one not aware of this , so ;) — abdoe
– abdoe, Commented Aug 23, 2016 at 13:05

AStopher · Accepted Answer · 2018-05-15 00:36:42Z

1

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=".

edited May 15, 2018 at 0:36

AStopher

4,60112 gold badges52 silver badges75 bronze badges

answered Feb 8, 2018 at 2:09

Renato Aloi

3202 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Victor Mwenda · Accepted Answer · 2017-08-24 12:22:15Z

0

I had the same error on linux.

The error was : I was using g++-4.8 to build the project

The issue lies on the version of the build tools (gcc,msvs,clang) used to build the project

answered Aug 24, 2017 at 12:22

Victor Mwenda

1,84121 silver badges18 bronze badges

Collectives™ on Stack Overflow

c++ mysql connection bad_alloc using c++ connector

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related