Jmeter ------ reponse error "unknown column 'xxxxx' in 'where clause'"

Tag: Art Sele width todo returned result: Select JDBC Error

 

I. Problem Description

Jmeter adds a connection to the MySQL database. After compiling the JDBC request, the following error occurs: "unknown column 'be7f5b6e750bb6becf85521333864420 'in 'where clause'".

 

Ii. Cause

SQL query conditions lack double quotation marks

 

Iii. Problem Analysis: Let's view the written SQL statements.

The correct syntax is: Select * From todo where todo_start =$ {todo_start} And user_uuid = "be7f5b6e750bb6becf85521333864420 ";

Naturally, the UID returned from the/user/login reponse is be7f5b6e750bb6becf855000033864420, because the UID is obtained from the JSON extra added in/user/login, therefore, in SQL, the UID is directly transmitted to user_uuid: user_uuid = "$ {uid}". An error is reported during running.

 

Iv. Solution

 

Jmeter ------ reponse error "unknown column 'xxxxx' in 'where clause'"