jmeter – Variable Name must not be null in JDBC Request
So Jmeter seems super cool.
I’ve only used it a little bit but it does seem a bit touchy about somethings (like spaces in input fields) and the errors are often less than obvious and I’m not finding that much out there on google for the errors.
Today I ran into the error
Variable Name must not be null in JDBC Request
and Googling it didn’t turn up anything.
I’m pretty sure I ran into this same error a few weeks ago when I was first starting with Jmeter, so blogging here to document it.
I was trying something new – running a procedure – instead of a regular sql statement and I think that threw me off.
The error sounded to me like I needed to define an input or output variable.
I tried both of those, until finally I saw its not the input or output variable but the name of the JDBC connection pool that was missing
This was the closest google hit I could find
In googling around, I did turn up
which sounds cool – loading up the results into a table after the Jmeter run
And thanks to Ivan Rancati who answered this same question of mine 4 weeks ago on email@example.com
Another problem I had today was “”The column index is out of range”
I was doing a
“INSERT INTO authors (id,name,email) VALUES(nextval(‘serial’),’Priya’,’firstname.lastname@example.org’);”
The JDBC Request worked when it was just
“INSERT INTO authors (id,name,email) VALUES(2,’Priya’,’email@example.com’);”
Turns out I had set “Parameter values” and “Parameter types”. When I took them out it worked. What confuses me, and what I’ll have to look back into, is the whole reason I added the Parameters was because the nextval wasn’t work. Forgot what that original error was.