Re: Returning 2147483647 and not displaying exception error.

[Lawrin Novitsky]

Hi,

You try to execute >1 statements at once. For that you need to set connection option CLIENT_MULTI_STATEMENTS to true. You need to use connect(sql::ConnectOptionsMap&) ) for that. It should look like following:

sql::ConnectOptionsMap options;

options.insert( std::make_pair( "hostName", host));
options.insert( std::make_pair( "userName", login));
options.insert( std::make_pair( "password", passwd ));
options.insert( std::make_pair( "CLIENT_MULTI_STATEMENTS", true ) );

conn.reset( driver->connect(options) );

Now, you need to use execute - getMoreResults - getResultSet, not executeQuery in this case. smth like:

stmt->execute(query);

if ( stmt->getMoreResults() )
{
rs.reset( stmt->getResultSet() );

rs->next();
...

last little one thing - you don't have field "_currId", but "currId"

and the last thing- if you do everything like i showed... you won't get working code :) because we found some serious bug. i'll push fix of it on sunday-monday. you will need to build c/c++ driver from latest sources to make your code work.
so, thank you - w/out your post that bug would probably stay hidden for some more time.

regards,