Wojciech Barski wrote:
> On May 20, 2009, at 5:04 PM, Warren Young wrote:
>
>> Yes, do. I tried modifying one of the examples to bounce the connection a
> few times in a few different places, and it doesn't affect anything. See the
> attached patch.
>
> I seem to be having the same problem. The simple code like this brings the
> access violation exception (on a reconnect try). I've traced it to
> mysql_real_connect line in the dbdriver::connect method.
I still can't reproduce it. I added these two lines to simple1.cpp, and
it didn't crash:
> Index: examples/simple1.cpp
> ===================================================================
> --- examples/simple1.cpp (revision 2561)
> +++ examples/simple1.cpp (working copy)
> @@ -48,9 +48,6 @@
> mysqlpp::Connection conn(false);
> if (conn.connect(mysqlpp::examples::db_name, cmdline.server(),
> cmdline.user(), cmdline.pass())) {
> - conn.disconnect();
> - conn.connect(mysqlpp::examples::db_name, cmdline.server(),
> - cmdline.user(), cmdline.pass());
> // Retrieve a subset of the sample stock table set up by resetdb
> // and display it.
> mysqlpp::Query query = conn.query("select item from stock");
I tried it on both Linux and Windows. Please apply the same patch to
your copy of MySQL++. If it crashes, I'll need some details about the
environment, since it clearly doesn't happen everywhere. If it doesn't
crash, it's likely that you just didn't follow the README-Visual-C++.txt
instructions carefully enough.