MySQL Forums - MySQL Connector/C++

Set up MySQL Connector/C++ with Code::Blocks on Debian (no replies)

Scott Griffith — Sun, 28 Apr 2013 17:20:31 +0000

This post started as a rather silly question (through inexperience) about how to get the connector libraries working. So, as I've made some headway, I thought I'd edit it (heavily) so the information I've gleaned is up here for anybody else who needs it.

So I've been trying to learn how to use C++ and MySQL together. To that end, I have dusted off my C++ reference and installed Code::Blocks and the MySQL Connector/C++ on my Debian Wheezy (64-bit) system. It was a bit rocky at first, but I'm slowly getting somewhere (been a while since I did any coding).

If anybody knows of something I've done wrong, feel free to correct me, and I'll make sure to edit the post summore.

I installed Code::Blocks from the Debian repo.
I then downloaded the GA binary release mysql-connector-c++-1.1.3-linux-debian6.0-x86-64bit.tar.gz from mysql.com, extracted it, and placed the lib and include folders into my /usr/local/ folder under a subfolder called "mysql".

Ok, so that bit was really basic, so if you're lost, I'd suggest taking a look at a decent linux book. Don't know if it's the best, but I've been going through The Linux Bible.

Noticing that the examples are missing from the binary release, I also grabbed the source archives, so I could take a look at the examples. Note that examples.h has some useful #define lines for checking your compiler version so you can use "EXAMPLE_FUNCTION" in a try...catch error outputty-type thing. Again, if you're unfamiliar with try...catch and #define, I'd say go grab a book on C++.

On to Code::Blocks. I created a new console application project, "MySQLTest", using the GNU GCC Compiler, and replaced the "Hello World" code it gave me in main.cpp with the code from standalone_example.cpp, and copied over exmaples.h to the project dir, slapping an include line at the top of main.cpp for it.

The next bit I did was create a global variable in Code::Blocks (Settings/Global Variables), called "mysql", with the base dir being "/usr/local/mysql" (which is probably not all that great, because there's nothing there), the include dir being "/usr/local/mysql/include", and the lib dir being "/usr/local/mysql/lib".

After that I set some build options (Project/Build Options". I selected the root node in the tree on the left of the dialog, and in the "Compiler" tab within "Search Directories" I added "$(#mysql.include)" - thus making use of the global variable I made, and I put "$(#mysql.lib)" as an entry in the "Linker" tab.

Right. So I want to build a static binary, simply because it means I don't have to faff about quite so much if I want to run my program on another machine. And to get this to work, it seems I need to do the following.

In the aforementioned Linker tab, I added "/usr/lib/x86_64-linux-gnu" so that the compiler can find one of the .a files (libmysqlclient.a) needed for the static build. This folder will probably be different if you're not on a 64-bit Debian system like me.

Then in the left pane of the "Linker Settings" tab, I added "libmysqlclient.a" and also "libmysqlcppconn-static.a", which is in the "lib" directory of the connector.

Note that (for me at least) "libmysqlclient.a" needs to be in the list above "libmysqlcppconn-static.a", or you get a ton of linker errors.

And that's it! All I (and probably you if you had to read this post) have to do now is read the manuals on how to use the connector.

- Scott

Error LNK2031, LNK2028, LNK2019, LNK2001 (no replies)

Tay Moore — Sun, 14 Apr 2013 01:56:03 +0000

So I was able to successfully build a program in visual c++ using a command prompt. It was a simple program to read from the database then write to the database based on some variable. So I decided to make it a lot more fancy and add a button. I linked everything up the same as I did before, posted the same code without the cout and cin, but I recieved this code
1>new test mysql.obj : error LNK2031: unable to generate p/invoke for "extern "C" class sql::Driver * __clrcall get_driver_instance(void)" (?get_driver_instance@@$$J0YMPAVDriver@sql@@XZ); calling convention missing in metadata
1>stdafx.obj : error LNK2028: unresolved token (0A00000D) "public: __clrcall sql::SQLString::~SQLString(void)" (??1SQLString@sql@@$$FQAM@XZ) referenced in function "public: virtual __clrcall sql::mysql::MySQL_Savepoint::~MySQL_Savepoint(void)" (??1MySQL_Savepoint@mysql@sql@@$$FUAM@XZ)
1>new test mysql.obj : error LNK2028: unresolved token (0A00001E) "public: __clrcall sql::SQLString::~SQLString(void)" (??1SQLString@sql@@$$FQAM@XZ) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>new test mysql.obj : error LNK2028: unresolved token (0A000035) "public: __clrcall sql::SQLString::SQLString(char const * const)" (??0SQLString@sql@@$$FQAM@QBD@Z) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>new test mysql.obj : error LNK2028: unresolved token (0A000037) "extern "C" class sql::Driver * __clrcall get_driver_instance(void)" (?get_driver_instance@@$$J0YMPAVDriver@sql@@XZ) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>stdafx.obj : error LNK2028: unresolved token (0A000093) "public: virtual int __clrcall sql::mysql::MySQL_Savepoint::getSavepointId(void)" (?getSavepointId@MySQL_Savepoint@mysql@sql@@$$FUAMHXZ) referenced in function "void __clrcall `dynamic initializer for 'const sql::mysql::MySQL_Savepoint::`vftable'''(void)" (???__E??_7MySQL_Savepoint@mysql@sql@@6B@@@YMXXZ@?A0xf283656a@@$$FYMXXZ)
1>stdafx.obj : error LNK2028: unresolved token (0A000094) "public: virtual class sql::SQLString __clrcall sql::mysql::MySQL_Savepoint::getSavepointName(void)" (?getSavepointName@MySQL_Savepoint@mysql@sql@@$$FUAM?AVSQLString@3@XZ) referenced in function "void __clrcall `dynamic initializer for 'const sql::mysql::MySQL_Savepoint::`vftable'''(void)" (???__E??_7MySQL_Savepoint@mysql@sql@@6B@@@YMXXZ@?A0xf283656a@@$$FYMXXZ)
1>new test mysql.obj : error LNK2019: unresolved external symbol "public: __clrcall sql::SQLString::~SQLString(void)" (??1SQLString@sql@@$$FQAM@XZ) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>stdafx.obj : error LNK2001: unresolved external symbol "public: __clrcall sql::SQLString::~SQLString(void)" (??1SQLString@sql@@$$FQAM@XZ)
1>new test mysql.obj : error LNK2019: unresolved external symbol "public: __clrcall sql::SQLString::SQLString(char const * const)" (??0SQLString@sql@@$$FQAM@QBD@Z) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>new test mysql.obj : error LNK2019: unresolved external symbol "extern "C" class sql::Driver * __clrcall get_driver_instance(void)" (?get_driver_instance@@$$J0YMPAVDriver@sql@@XZ) referenced in function "private: void __clrcall newtestmysql::Form1::mysqltest(void)" (?mysqltest@Form1@newtestmysql@@$$FA$AAMXXZ)
1>stdafx.obj : error LNK2019: unresolved external symbol "public: virtual class sql::SQLString __clrcall sql::mysql::MySQL_Savepoint::getSavepointName(void)" (?getSavepointName@MySQL_Savepoint@mysql@sql@@$$FUAM?AVSQLString@3@XZ) referenced in function "void __clrcall `dynamic initializer for 'const sql::mysql::MySQL_Savepoint::`vftable'''(void)" (???__E??_7MySQL_Savepoint@mysql@sql@@6B@@@YMXXZ@?A0xf283656a@@$$FYMXXZ)
1>stdafx.obj : error LNK2019: unresolved external symbol "public: virtual int __clrcall sql::mysql::MySQL_Savepoint::getSavepointId(void)" (?getSavepointId@MySQL_Savepoint@mysql@sql@@$$FUAMHXZ) referenced in function "void __clrcall `dynamic initializer for 'const sql::mysql::MySQL_Savepoint::`vftable'''(void)" (???__E??_7MySQL_Savepoint@mysql@sql@@6B@@@YMXXZ@?A0xf283656a@@$$FYMXXZ)

Any and all help is appreciated.

Connector does not work (no replies)

Yuriy Osipov — Fri, 12 Apr 2013 22:50:25 +0000

I'm try to use this example

http://dev.mysql.com/doc/refman/5.6/en/connector-cpp-examples-complete-example-1.html

I'm download c++ connector, put dll here:
C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\lib
and headers to include

Then i download boost, and add it.

I have create c++ console aplication and try run project, but i have error:

http://img687.imageshack.us/img687/148/54826950.jpg

Please, tell me what am I doing wrong?

Prepared Statements: setInt always 0 (no replies)

Thomas Steiner — Mon, 08 Apr 2013 12:31:01 +0000

Hi!

first of all i have to exuse me for my english! obviously i want to access my database with c++. I downloded the "mysql-connector-c++-1.1.2.tar" and compiled it with cmake and msvc2010. then i copied the example code [*] form the mysql homepage.

After starting the programm, i can connect to my database test and create the table test_table. I can also insert entrys with the prepareStatement, but all entrys have the value 0.

Any ideas on why I can't bind to the prepared statement?

thx for your help

[*]

#include "stdafx.h"

#include "mysql_connection.h"

#include
#include
#include
#include
#include

int _tmain(int argc, _TCHAR* argv[])
{
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;
sql::PreparedStatement *pstmt;

driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "");

con->setSchema("test");

stmt = con->createStatement();
stmt->execute("DROP TABLE IF EXISTS test");
stmt->execute("CREATE TABLE test_table(id INT)");
delete stmt;

/* '?' is the supported placeholder syntax */

pstmt = con->prepareStatement("INSERT INTO test_table(id) VALUES (?)");
for (int i = 1; i <= 10; i++) {
pstmt->setInt(1, i);
pstmt->executeUpdate();
}

delete pstmt;
delete con;

return 0;
}

Access violation in my project, works in new project (1 reply)

Alexander Kesarion — Mon, 08 Apr 2013 15:42:33 +0000

My project compiles fine if I insert some code from the examples, but the program crashes with:
Unhandled exception at 0x552CEB8C (msvcr110d.dll) in comClient.exe: 0xC0000005: Access violation reading location 0x63697274.

If I use the EXACT same code in a new project it works just fine, does exactly what it's supposed to do.

Why isn't it working in my project?

Here's what I'm using:

try {
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;

/* Create a connection */
driver = get_driver_instance();
con = driver->connect("address:port", "user", "pass");
/* Connect to the MySQL test database */
con->setSchema("database");

stmt = con->createStatement();
stmt->execute("TRUNCATE TABLE words");

delete stmt;
delete con;

} catch (sql::SQLException &e) {
cout << "# ERR: SQLException in " << __FILE__;
cout << "(" << __FUNCTION__ << ") on line » " << __LINE__ << endl;
cout << "# ERR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() << " )" << endl;
}

[Note]
Afer setting some breakpoints and using the debugger, it seems the crash happens on:
con = driver->connect("address:port", "user", "pass");

Obviously using a working address, user and pass.

MySQL C++ Connector crashes executing INSERT with BLOB (no replies)

Denis Makarskiy — Thu, 04 Apr 2013 05:51:20 +0000

I've stuck with a problem, trying to insert text as blob value, MySQL C++ connector crashed with exception: "Access violation reading location". I've seen questions like this here, but none has been answered. Here is a code sample:

#include "mysql_connection.h"
#include
#include
#include
#include
#include

#include
#include
#include

using namespace sql;

void main(){
Connection *dbConnection;
Driver *driver;
Connection *con;

driver = get_driver_instance();
con = driver->connect("localhost", "root", "");
Statement *stmt = con->createStatement();
try{
stmt->execute("USE test");
stmt->execute("DROP TABLE blob_test");
stmt->execute("CREATE TABLE blob_test("
"id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,"
"original BLOB NOT NULL);");
char smallBlob[32];

for (char i = 0; i < sizeof(smallBlob); ++i)
{
smallBlob = i;
}
std::istringstream str(smallBlob);
PreparedStatement *pstmt = con->prepareStatement("INSERT INTO blob_test(id, original) VALUES (1, ?)");

pstmt->setBlob( 1, &str);
pstmt->executeUpdate();
}catch(sql::SQLException &e){
std::cerr << "# ERR: " << e.what();
std::cerr << " (MySQL error code: " << e.getErrorCode();
std::cerr << ", SQLState: " << e.getSQLState() << " )" << std::endl;
}
}

Thanks in advance!

MySQL - Connector with Code::Blocks Windows XP 32bit (no replies)

Benedikt Petschl — Sat, 30 Mar 2013 10:22:36 +0000

I have a problem with the connector. The integration from the includes an libs in Code::Blocks works well, compiling too.

But when starting the application, it crashes everytime when open the mysql-connection. I've tried it also with the example-programm from the mysql-website, but the same result.

After consulting google, I guess the problem could be that the "libmysql" from the connector was compiled with Microsoft C++ Express, and so only works in Programms compiled with it, too.

May it help, to compile the connector myself from the source-code with MinGW, or is there, because this is a bit difficult, already an connector works with code::blocks?

Or may my problem be another one?

Thanks for helping!

MySQL C++ Connector won't connect - returns unrecognized or ambiguous flag (no replies)

Warren Burns — Thu, 21 Mar 2013 19:59:19 +0000

I am creating a c++ program that will connect to an existing, live, functioning MySQL dB. I cut-n-pasted the example program in, for verifying being able to get a connection. THAT example code wouldn't compile.... so I reverted to the "complete example" program... which does compile at least. But when I run it in debug mode, it fails on the line where the driver is creating a connection. Here's the code:

//***********************************
#include
#include
#include "mysql_connection.h"
#include
#include
#include
#include

using namespace std;

int main(void)
{
cout << endl;
cout << "Running 'SELECT 'Hello World!' »
AS _message'..." << endl;

try {
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;

/* Create a connection */
printf("before the driver gets created\n");
driver = get_driver_instance();
printf("afer driver gets created before connection\n");
con = driver->connect("tcp://127.0.0.1:3306", "root", "");
printf("after connection created\n");
/* Connect to the MySQL test database */
con->setSchema("test");

etc.
//***************************

The only difference from the "complete example" is in the step that creates the connection from the driver, in that I have changed the pwd to be blank, because there is no pwd on this test database. The step that creates the connection, fails. It displays a window that says "Signal Caught" with text>>

Signal received: ? (Unknown signal)
For program ca2httplistener, pid 3,244

You may discard the signal or forward it and you may continue or pause the process

I am given the choice to Discard and Pause, Discard and Continue, or Forward and Continue. But no matter which choice I take, it displays:

What the heck???

Error in using mysql-connector-c++-1.1.2-linux-glibc2.3-x86-32bit (3 replies)

Basma Emad — Wed, 27 Mar 2013 08:48:53 +0000

I have an error compiling C++ project using mysql-connector-c++-1.1.2-linux-glibc2.3-x86-32bit
i got this error
usr/bin/ld: warning: libmysqlclient.so.18, needed by /root/sources/mysql-connector-c++-1.1.2-linux-glibc2.3-x86-32bit/lib/libmysqlcppconn.so, not found (try using -rpath or -rpath-link)
/root/sources/mysql-connector-c++-1.1.2-linux-glibc2.3-x86-32bit/lib/libmysqlcppconn.so: undefined reference to `mysql_stmt_execute@libmysqlclient_18'

I'm using mysql-connector-c-6.0.2-linux-glibc2.3-x86-32bit
it contains libmysql.so.16
i can't find a source for libmysqlclient.so.18 for Redhat 5

getting segmentation fault in the program (no replies)

arun d — Sun, 03 Mar 2013 00:24:17 +0000

I am getting a segmentation fault sometimes in my application(It comes very rarerly, like once in 300 runs of program. Since it doesnt come always so I cant gdb it).

*** Aborted at 1362124211 (unix time) try "date -d @1362124211" if you are using GNU date ***
PC: @ 0x8ae07b my_stat
*** SIGSEGV (@0x0) received by PID 7495 (TID 0x7f0bbfafe700) from PID 0; stack trace: ***
@ 0x7f0bc28edeaf (unknown)
@ 0x8ae07b my_stat
@ 0x8ac4f1 my_read_charset_file
@ 0x8acf08 init_available_charsets
@ 0x7f0bc1dcb952 __pthread_once_internal
@ 0x8ad28c get_charset_by_csname
@ 0x8b990d mysql_init_character_set
@ 0x8ba9fb mysql_real_connect

I am not sure why I am getting this. Any ideas what it means or if I can use this information to reproduce this.

The application was unable to start correctly (1 reply)

Melvin Stober — Sun, 14 Apr 2013 01:49:57 +0000

I was able to get the program listed here http://dev.mysql.com/doc/refman/5.1/en/connector-cpp-examples-complete-example-1.html to compile and link with VC++ 2012, but the program won't run. Get the error message "The application was unable to start correctly (address here) Click OK to close the application)." I copied libmysql.dll and mysqlcppconn.dll into the same folder as the program executable. I get the same error in both debug and release builds.

I have the MySQL database server running on a different computer than the one I am using to build the application program. I copied libmysql.lib from that other computer so that my program could link. Could that be the problem? I am using the 32-bit version of the server instead of the 64-bit version.

#include Problem! (no replies)

Ivelin Ivanov — Wed, 13 Feb 2013 08:40:10 +0000

I am using MS VS 2008 and I am developing a program, which shall use MySQL server on another PC. I downloaded the MySQL Connector/C++. I included "mysql_connection.h", but the compiler cannot find "".

Pls, help me!

Cannot connect to a MySQL database from a C++ program with MySQL Connector/C++: exception thrown (1 reply)

Pietro Mele — Thu, 07 Feb 2013 11:09:51 +0000

I have a connection problem to a MySQL database from a C++ program:

std::string server, user, password;
SetParams(server, user, password);
boost::shared_ptr conn;
sql::Driver *driver = get_driver_instance();

if(driver == 0) { /* error; never reached */ }

try {
conn.reset(driver->connect(server, user, password));

assert(conn != 0);

if(!conn->isClosed()) // <-- exception thrown
{
// Connection established
}
else {
// Connection failed
}
}
catch (sql::SQLException &e)
{
cerr << e.what << e.getErrorCode() << e.getSQLState() << endl;
}
The sql::Connection::isClosed() function throws this exception:

SQLException: Connection has been closed
MySQL error code: 0
SQLState: HY000
The values for server, user and password are correct (they work connecting from MySQL-Workbench), the DB is up and running.

I do not know where else to look...
Thank you.

Platform:
Linux - OpenSuse 11.4
MySQL 5.x
MySQL Connector/C++ 1.0.5

*** UPDATE ***

The code as shown here works correctly. The problem must be somewhere else in the program...

Limit on result set (no replies)

nima chavoshi — Sun, 23 Dec 2012 19:36:59 +0000

Hi
Is there any limitation about returned resultset on number of returned rows or size of returned rows?
Probably my resultset will be more than 100000 rows.

Thanks

Application getting crashed in windows server 2012 (no replies)

Senthil Murugan — Mon, 17 Dec 2012 21:03:31 +0000

Hi,

My application uses MySQL ODBC Connector version 3.51.27 and my application is written in c++ and uses MySQL connector/c++ to connect to MySQL.The application getting crashed while using the ODBC Connector to execute query in Windows Server 2012.But my application is running fine in all other Windows platform like Windows XP,Windows 7.I changed the ODBC Connector version to 3.51.30 in Windows Server 2012 and Started the application.Now application is running fine but when i enable Connection Pooling it getting crashed.Please help on this to solve the problem

/usr/bin/ld: cannot find -lmysqlcppconn (no replies)

Vusi Sindane — Wed, 12 Dec 2012 08:17:14 +0000

Hi

New in c++ and im trying to connect to mysql database did in java works fine.when to do it in c++ project followed all the instruction from http://planet.mysql.com/entry?id=18341;but it gives me this error.

g++ -o dist/Debug/GNU-Linux-x86/cppapplication_2 build/Debug/GNU-Linux-x86/main.o -L/usr/local/lib -L/usr/local/include/mysql-connector-c++-1.0.5-linux-glibc2.3-x86-32bit -lmysqlcppconn -lmysqlcppconn-static -lmysql -lmysqlclient
/usr/bin/ld: cannot find -lmysqlcppconn
/usr/bin/ld: cannot find -lmysqlcppconn-static
/usr/bin/ld: cannot find -lmysql
/usr/bin/ld: cannot find -lmysqlclient

Please help my boss wants this c++ for what reason i dnt know.

mysqlcppconn.dll Cannot find or open PDB file (no replies)

Rohit Banerjee — Mon, 26 Nov 2012 07:16:37 +0000

I am trying to build a simple MySQL db application in VC++ and have run into a slight problem.

I am using MySQL Connector C++ 1.1.0 and Visual Studio 2012 (Premium if that matters)




// ConsoleApplication1.cpp : Defines the entry point for the console application.


//





#include "stdafx.h"





#include 


#include 


#include 


#include 


#include 


#include 


#include 





/* MySQL Connector/C++ specific headers */


#include 


#include 


#include 


#include 


#include 


#include 


#include 


#include 


#include 





#include "mysql_driver.h"


#include "mysql_connection.h"





#define DBHOST "tcp://127.0.0.1:3306"


#define USER "root"


#define PASSWORD "root"


#define DATABASE "test"





using namespace std;


using namespace sql;





int _tmain(int argc, char *argv[]){


    // I'm alive


    cout << "Hello World!" << endl;





    // necessary variables


    Driver *driver;


    Connection* con;


    Statement *stmt;


    ResultSet *res;


    /*PreparedStatement *prep_stmt;


    Savepoint *savept;*/





    //


    driver = get_driver_instance();





    // Connect to DB


    con = driver->connect("tcp//127.0.0.1:3306", "root", "root");





    // 


    con->setAutoCommit(false);





    // set schema


    con->setSchema("world");





    // create statement object


    stmt = con->createStatement();





    // alert user


    cout << "Executing query: \"SELECT * FROM city\"" << endl;





    // execute query "SELECT * FROM city"


    res = stmt->executeQuery("SELECT * FROM city");





    // alert user


    cout << "\tRetrieved " << res->rowsCount() << " row(s)." << endl;





    // fetch data


    while(res->next()){


        cout << res->getString("Name") << endl;


    }





    system("pause");





    // Clean up


    delete res;


    delete stmt;


    /*delete prep_stmt;*/


    con->close();


    delete con;





    return 0;


} // end main

I am building this as a Win32 console application in Release mode, changed the configuration to x64 and have moved mysqlcppconn.dll to the output directory. The code is building correctly (*I think I have correctly added the necessary include directories as well as additional library dependencies/relevant paths). However, when I try to run it I get the following debug output:

'ConsoleApplication1.exe' (Win32): Loaded 'C:\Users\RBanerjee\Documents\Visual Studio 2012\Projects\ConsoleApplication1\x64\Debug\ConsoleApplication1.exe'. Symbols loaded.
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Windows\System32\ntdll.dll'. Symbols loaded.
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Windows\System32\kernel32.dll'. Symbols loaded.
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Windows\System32\KernelBase.dll'. Symbols loaded.
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Users\RBanerjee\Documents\Visual Studio 2012\Projects\ConsoleApplication1\x64\Debug\mysqlcppconn.dll'. Cannot find or open the PDB file.
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Windows\System32\libmysql.dll'. Module was built without symbols.
'ConsoleApplication1.exe' (Win32): Unloaded 'C:\Windows\System32\libmysql.dll'
'ConsoleApplication1.exe' (Win32): Loaded 'C:\Windows\System32\libmysql.dll'. Module was built without symbols.
'ConsoleApplication1.exe' (Win32): Unloaded 'C:\Windows\System32\libmysql.dll'
The program '[4172] ConsoleApplication1.exe' has exited with code -1073741701 (0xc000007b).

I am a little lost as to what to do next, I really just want to be able to develop a Windows application that can connect to a MySQL db and interact with it. I would appreciate any help with this problem or a pointer to some other tutorial.

Thanks

Conn->close() crashes (no replies)

santhosh edukulla — Sat, 24 Nov 2012 16:55:50 +0000

Conn->close() crashes, i dont know why and this happens some times, iam not able to decipher why?

Our production code uses and it crashes some times and gives nightmare to us from customers?
Any help is appreciated!

Thanks!
Sannthosh

Mysql C++ connector crash issues (1 reply)

santhosh edukulla — Sat, 24 Nov 2012 17:02:46 +0000

Team,

I am trying to use mysqlclient version 16 and Mysql c++ connector to connect to the Mysql database and perform some DB operations. The code for our product relying on these libraries is already written. Mysql Server version 5.1.56. I could see that it is crashing at various occasions.

Below are few crash dumps. Any idea why these are happening? Typically during close connection and create connection.
1/ For close connection, Iam using mSqlCon->close()
2/ For create connection iam using some thing like below:
driver = get_driver_instance();
mSqlCon = driver->connect( connection_properties );

mSqlCon is of type sql::Connection *. Any help is appreciated!!

#0 0x00007f82b4f064ff in ?? () from /usr/local/lib64/mysql/libmysqlclient.so.16
#1 0x00007f82b4f06758 in net_real_write () from /usr/local/lib64/mysql/libmysqlclient.so.16
#2 0x00007f82b4f06c3b in net_flush () from /usr/local/lib64/mysql/libmysqlclient.so.16
#3 0x00007f82b4f03279 in mysql_real_connect () from /usr/local/lib64/mysql/libmysqlclient.so.16
#4 0x00007f82b4a630d7 in sql::mysql::NativeAPI::LibmysqlStaticProxy::real_connect (this=, mysql=0x7f82ac041680,
host=0x7f82ac053d80 "K", user=0x4f

, passwd=0x0, db=0x35a5d367fc14006c

,
port=3306, unix_socket=0x7f82ac041680 "\a", client_flag=140199208425088)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/nativeapi/libmysql_static_proxy.cpp:316
#5 0x00007f82b4a649a9 in sql::mysql::NativeAPI::MySQL_NativeConnectionWrapper::connect (this=0x7f82ac0d22d0, host=,
user=, passwd=, db=, port=, socket_or_pipe=...,
client_flag=140199208425088) at /build/cteam/bs/linux-x86_64/connector-common-alt-64bit/boost/include/boost-1_39/boost/smart_ptr/shared_ptr.hpp:408
#6 0x00007f82b49f8ebe in sql::mysql::MySQL_Connection::init (this=0x7f82ac0d3740, properties=...)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/mysql_uri.h:51
#7 0x00007f82b49f57b3 in MySQL_Connection (this=0x7f82ac0d3740, _driver=, _proxy=, properties=...)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/mysql_connection.cpp:141
#8 0x00007f82b4a062cd in sql::mysql::MySQL_Driver::connect (this=0x7f82ac0466e0, properties=...)
at /build/cteam/bs/linux-x86_64/connector-common-alt-64bit/boost/include/boost-1_39/boost/smart_ptr/scoped_ptr.hpp:96

#0 0x00007fbf785e7745 in free () from /lib64/libc.so.6
#1 0x00007fbf79b49224 in __gnu_cxx::new_allocator::deallocate (this=,
__nstart=0x7fbf740dbc76, __nfinish=0x7fbf740dbc80) at /usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../../include/c++/3.4.6/ext/new_allocator.h:86
#2 std::_Deque_base >::_M_deallocate_node (
this=, __nstart=0x7fbf740dbc76, __nfinish=0x7fbf740dbc80)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/mysql_debug.cpp:401
#3 std::_Deque_base >::_M_destroy_nodes (
this=, __nstart=0x7fbf740dbc76, __nfinish=0x7fbf740dbc80)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/mysql_debug.cpp:497
#4 0x00007fbf79b491d0 in ~_Deque_base (this=0x7fbf74049db00000, __in_chrg=)
at /usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../../include/c++/3.4.6/bits/stl_deque.h:425
#5 0x00007fbf79b48def in ~MySQL_DebugLogger (this=0x7fbf740444d0, __in_chrg=)
at /usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../../include/c++/3.4.6/bits/stl_deque.h:703
#6 0x00007fbf79b4829f in checked_delete (this=)
at /build/cteam/bs/linux-x86_64/connector-common-alt-64bit/boost/include/boost-1_39/boost/checked_delete.hpp:34
#7 boost::detail::sp_counted_impl_p::dispose (this=)
at /build/cteam/bs/linux-x86_64/connector-common-alt-64bit/boost/include/boost-1_39/boost/smart_ptr/detail/sp_counted_impl.hpp:78
#8 0x00007fbf79b3ae22 in ~MySQL_ConnectionData (this=0x7fbf740d6140, __in_chrg=)
at /build/cteam/bs/linux-x86_64/connector-common-alt-64bit/boost/include/boost-1_39/boost/smart_ptr/detail/sp_counted_base_gcc_x86.hpp:145
#9 ~MySQL_Connection (this=0x7fbf740d6140, __in_chrg=)
at /export/home2/tmp/cteam/bs/connector-c++-64bit/src/mysql-connector-c++-1.1.1/driver/mysql_connection.cpp:162

Thanks!
Santhosh

Can't compile in MS Visual Studio 2010 due to a missing file 'libmysql.lib' (no replies)

Pavan Shah — Tue, 20 Nov 2012 21:29:57 +0000

I downloaded the 64-bit MSI package. And it seems to be missing this one file:

libmysql.lib

where can I get this file?

thanks

Pavan

example for connector in visual studio 2008 (2 replies)

yuanjie chen — Mon, 26 Nov 2012 11:20:20 +0000

To test the c++ mysql connector I reset my mysql(DBMS)，download the boost library, the sqlstring.h . now I test the example here: http://dev.mysql.com/doc/refman/5.5/en/connector-cpp-examples-complete-example-1.html

But when I run it the ide says no "_get_driver_instance",and...I saw the mysql Official Guide，there is no more "get_driver_instance"...holy shit! do you know how long I spend at this thing...I'm going to crazy.

Is anyone could give a effective example use the latest version of the mysql(DBMS) and mysql connector/C++ ? thank you in advance.

Error 1102 Incorrect Database Name (no replies)

Brian Ryall — Fri, 09 Nov 2012 13:25:13 +0000

I have no clue what this means, tried connecting to mysql server with the following

driver = sql::mysql::get_mysql_driver_instance()
connection = driver->connect("//", username, password)

I am making this call on Linux to a Linux mysql server if that helps

64 bit build for C++ connectors (4 replies)

C Scruby — Mon, 22 Oct 2012 14:09:59 +0000

Hi,

I'm trying to rebuild an existing (and working) DLL which connects MetaTrader to MYSQL. I've installed the SDK, the compiler updates and everything suggested. I get a 'succesfull' build in Visual Studio 2010 Express BUT..... MetaTrader 5 won't load the DLL.

I've looked at the DLL using dependency walker and the DLL looks like it's in 64 bit format at the top level with mysqlcppconn.dll in 64 bit, MSVCP90 and MSVCR90 dlls also in 64 bit mode BUT.....libmysql.dll looks like it's still in 32 bit mode along with ADVAPI32, USER32 and Kernel32 dlls.

Oddly there is no 64 bit version of libmysql.dll in the 64 MSI installer package.

Kind of pulling my hair out with this. MetaTrader won't give any error reporting apart from "Cannot load DLL" -

Anyone got any ideas what I'm doing wrong? Is there a 64 bit version of the libmysql.dll?? If so anyone know where it is? I might well be barking totally up the wrong tree with this line of enquiry but I've tried everything else I can think of.

cheers

How to prevent program from crashing if mysql host is not reachable (1 reply)

James Barajas — Mon, 22 Oct 2012 13:03:45 +0000

I'm using the MySQL Connector for c++

I'm trying to connect to a remote MySQL server which happens to be offline at the moment and I noticed that my program throws an exception and aborts!!
It is OK that it could not connect however I'd like to keep my program running.
because in case of a failed connection I'd like to try connecting to a different server but I cant if the program crashes after the first attempt.

Is there a way to do prevent this crash?

Thanks,

here is the connection code:

Connection * conn;
mysql::MySQL_Driver *driver;

try
{
driver = mysql::get_mysql_driver_instance();
conn = driver->connect("host1", "user", "pswd");
} catch (SQLException &e) {
cout << "ERROR: SQLException in " << __FILE__;
cout << " (" << __func__<< ") on line " << __LINE__ << endl;
cout << "ERROR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() << ")" << endl;
}
catch (std::runtime_error &e){
cout << "ERROR: runtime_error in " << __FILE__;
cout << " (" << __func__ << ") on line " << __LINE__ << endl;
cout << "ERROR: " << e.what() << endl;
}

where can i find the example of the Connector/C++? (2 replies)

wefwef ewefwe — Tue, 11 Dec 2012 13:29:23 +0000

where can i find the example of the Connector/C++?

In refman-5.5-en.pdf i can find some article about example,but i can not find it in C:\Program Files\MySQL

Not able to connect using standalone_example (1 reply)

matteo interlandi — Thu, 06 Sep 2012 07:03:45 +0000

Hi there,

I have installed mysql connector C++ but I have some trouble in connecting to the db.

I used the simple standalone_example_docs1.cpp and when It tried to connect to the db (line 43: con = driver->connect("tcp://XXXXXXXXX:3306", "XXXXXX", "XXXXXX");) it returns the following errors:

# ERR: SQLException in test_install.cc(main) on line 63
# ERR: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay (MySQL error code: 1104, SQLState: 42000 )

Some ideas?

Thanks,
Matteo

How can I get the auto generated key after insert? (1 reply)

Vintray White — Mon, 20 Aug 2012 06:55:53 +0000

Hello

I want to get the auto generated key after insert,I found there is one overloaded function in connection.h for prepareStatement.

PreparedStatement * prepareStatement(const sql::SQLString& sql, int autoGeneratedKeys) = 0;

But how can I use it to return key?
Thanks and regards!

MySQL Connector/C++ 1.1.1: Microsoft Visual Studio 2010 (no replies)

Edwin Desouza — Thu, 09 Aug 2012 21:15:59 +0000

Dear MySQL Users,

A new GA (general availability) version of MySQL Connector/C++ has
been made available: MySQL Connector/C++ 1.1.1 GA.

The MySQL Connector/C++ provides a C++ API for connecting client applications to
the MySQL Server 5.1 or newer. You can download the production release
at:

http://dev.mysql.com/downloads/connector/cpp/1.1.html

The MySQL driver for C++ offers an easy to use API derived from JDBC
4.0. MySQL Workbench is using it successfully since years.

We have improved the driver since the last GA release. Please see the
documentation and the CHANGES file in the source distribution for a
detailed description of bugs that have been fixed. The following
features and bug fixes have been added:

* DatabaseMetaData::getSQLKeywords() updated to match MySQL 5.5. Note
that C/C++, just like C/JDBC, returns the same list for every MySQL
database version.

* Added MySQL_Connection::getLastStatementInfo() which returns back
the value of the mysql_info() function of the MySQL Client Library
(libmysql).

* Added new method ResultSetMetaData::isNumeric() and implemented it
in all classes that subclass from it.

* Fixed the bug causing compilation errors in Microsoft Visual Studio
2010 if stdint.h was included. See http://bugs.mysql.com/bug.php?id=60307

* Fixed bug making statement that did not raise any warning to return
warnings from previously executed statement.

* Fixed stores(Lower|Mixed)Case(Quoted)Identifiers methods.

* URI format has been extended to better fit IPv6 addresses. You now
can use [] to separate host part of the URI.

* Built against libmysql 5.5.27 enabling support of authentification
plugins and IPv6.

You can find further details, including usages examples, in the
documentation at:

http://dev.mysql.com/doc/en/connector-cpp.html

Prepared Statements not getting closed (11 replies)

James Barajas — Thu, 30 Aug 2012 16:41:11 +0000

Using MySQL Connector C++ 1.1.0
MySQL server 5.5

I'm having a problem with prepared statements not getting closed every time even though I explicitly close the prepared statement in my method.
The method gets called back-to-back three times every 50ms.
When it is called back-to-back, the prepared statement only gets closed once out of the three times. so eventually I get an exception that I have exceeded the maximum number of prepared statements.

query: show global status like '%Com_Stmt%'; confirms that only about 1/3 of all
prepared statements created get closed.

The MySQL log show the following pattern:
Prepare SELECT * FROM myTbl WHERE ID = ? and name = ?
Execute SELECT * FROM myTbl WHERE ID = '1' and name = 'John'
Prepare SELECT * FROM myTbl WHERE ID = ? and name = ?
Execute SELECT * FROM myTbl WHERE ID = '2' and name = 'Josh'
Prepare SELECT * FROM myTbl WHERE ID = ? and name = ?
Execute SELECT * FROM myTbl WHERE ID = '3' and name = 'Mike'
Close stmt
.....

so the log confirms that the statement does not get closed every time.

but when I run my program my print statements show the following pattern:
creating prepared stmt
executing prepared stmt
closing prepared stmt
creating prepared stmt
executing prepared stmt
closing prepared stmt
......
and there is NO exception thrown other then:

"can't create more than max_prepared_stmt_count statements (current value: 16382)"
after a few minutes. So I don't know what's going on.

Here is the code I'm running:

ResultSet * DBMgr::getRecords( list values) {

ResultSet * res;
PreparedStatement *pstmt;
SQLString query = "SELECT * FROM myTbl WHERE ID = ? and name = ? ";
string val;

cout << " creating prepared stmt\n";
pstmt = m_mySqlConnection -> prepareStatement(query);
int i = 1;
BOOST_FOREACH(val, values)
{
pstmt->setString(i,val);
i++;
}
try {
cout << "executing prepared stmt\n";
res = pstmt->executeQuery();
cout << " closing prepared stmt\n;"
pstmt->close();
delete pstmt;
}
catch (SQLException &e) {
cout << "ERROR: SQLException in " << __FILE__;
cout << " (" << __func__<< ") on line " << __LINE__ << endl;
cout << "ERROR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
}
return res;
}

hope someone can advise.

Thanks!

-James

C++ MySQL Connector 1.1.0 Throws exception but query succeeds (3 replies)

James Barajas — Thu, 02 Aug 2012 18:56:02 +0000

The C++ MySQL Connector is throwing exceptions every time I try to insert a record into one of my MySQL tables.
The error code is (MySQL error code: 0, SQLState: 00000)
but the query is successful.
I also tried executing the exact same query directly on MySQL I get no error.
so why is the connector throwing an exception if there is no error??
how can I get around this?

here is my code:

void DBMgr::addRecord(string id, int num, string tblName)
{

SQLString query;
Statement *stmt;
stmt = m_mySqlConnection -> createStatement();

query = "INSERT INTO ";
query.append(tblName);
query.append(" SET id= '");
query.append(id);
query.append("', num = '");
query.append(boost::lexical_cast(num));
query.append("';");
cout << "executing query "<< query << endl;
try {

stmt->executeQuery(query);
stmt->close();
delete stmt;
}
catch (SQLException &e) {
cout << "ERROR: SQLException in " << __FILE__;
cout << " (" << __func__<< ") on line " << __LINE__ << endl;
cout << "ERROR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() << ")" << endl;
}
}

any help is appreciated.