sql::InvalidArgumentException MySql C++

Question

I'm using VisualStudio 12 for develop one app. In that app i need do some mySql call's, i have that code:

sql::Statement *stmt = db->global->createStatement();
sql::ResultSet *res = stmt->executeQuery("SELECT * FROM `tbl_jobs` WHERE name = 'maintenance';");
Server->maintenance = (res->getString("data") == "on")? true : false;

The query is ok, work's well on Navicat, but on:

res->getString("data")

Ever throw's that error:

Unhandled exception at ...: Microsoft C++ exception: sql::InvalidArgumentException at memory location ....

If i done sql::SQlException throw i get this log:

ERROR: SQLException in .... Function: main on line 33 ERROR: MySQL_ResultSet::getString: can't fetch because not on result set (MySql error code: 1544116026, SqlState: MySQL_ResultSet::getString: can't fetch because not on result set)

I understan the sql::ResultSet don't have any data, but if i print res->rowsCount() say me are 1 row... I tryed with res->first(), but throws random error's.

¿Any ideas? :c

Can you use try/ catch. stackoverflow.com/questions/16004540/… — metalfight - user868766
– metalfight - user868766, Commented Jun 25, 2013 at 10:19
@ ldgorman Added, @metalfightm i alredy use but return's "ERROR: SQLException...." — Erni CA
– Erni CA, Commented Jun 25, 2013 at 10:36

llama · Accepted Answer · 2013-06-25 10:39:21Z

2

You must call next() or similar in order for your resultset to point to the nth result in the set

If your resultset is empty calling getString() will fail. check for a result before continuing. something like:

if(!res->next())
  return; //Handle Failiure

Do this before you try to operate on your results

Here they are using a while loop alternatively.

answered Jun 25, 2013 at 10:39

llama

1,6861 gold badge14 silver badges41 bronze badges

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

1 Comment

Erni CA Over a year ago

Make another errror on inline void _Container_base12::_Orphan_all(), in xutility, and i can't read any with debugger

max · Accepted Answer · 2014-10-05 18:16:00Z

1

call res->next() before your first getString(...) function

edited Oct 5, 2014 at 18:16

max

103k15 gold badges113 silver badges177 bronze badges

answered Oct 5, 2014 at 17:45

Phạm Mạnh

1551 silver badge2 bronze badges

Collectives™ on Stack Overflow

sql::InvalidArgumentException MySql C++

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related