JMeter JDBC Call returns the value as parameter name if the value received from DB is null

debugcn Published at Dev

Maniram

I am using a JDBC PreProcessor in JMeter to fetch a value from the DB before firing a SOAP call which needs to be enriched with that information.

I have assigned a variable XYZ to fetch the value returned from DB. If there is a value returned from DB, i am able to get that value using ${XYZ_1} successfully, however if the value returned from DB is nothing (null) (as seen in DB), the value returned using ${XYZ_1} is shown as ${XYZ_1}.

I am using this variable in Sampler as <Location>${XYZ_1}</Location>

Ex: If DB returns value as 'California', i get it as <Location>California</Location>

If DB returns value as nothing (null), the value looks like <Location>${XYZ_1}</Location>.

Now my issue here is, if DB returns the value as nothing (null), i want the value to be set as nothing. So it should like like below

<Location></Location>

Any suggestions on this?

UBIK LOAD PACK

You could modify your SQL so that instead of null it returns empty.

Another option is to put a JSR223 Post Processor + Groovy (or Beanshell Post Processor) after your JDBC Post Processor that would test the variable and if null put empty String instead.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-8

Comments

0 comments

From Dev

Related Related

Article

JMeter JDBC Call returns the value as parameter name if the value received from DB is null

JMeter JDBC Call returns the value as parameter name if the value received from DB is null

Method call returns null value

ajax call returns value but variable is null

Value cannot be null, Parameter name: path

Value cannot be null. Parameter name: entitySet

Value cannot be null. Parameter name: extent

"value cannot be null parameter name: key"

Value Cannot be null, Parameter name: dataTable

Value cannot be null. Parameter name: baseUri

Value cannot be null. Parameter name: entity

Value cannot be null. Parameter name: type

Value Cannot be null, Parameter name: dataTable

Value cannot be null. Parameter name: httpContext

Value cannot be null. Parameter name: incomingMarkupParser

Value cannot be null. Parameter name: first

Value cannot be null. Parameter name: value, CreateIdentityAsync?

Value cannot be null. Parameter name: value Sitecore

C# XML - Value cannot be null. Parameter name: value

Call by Name/Call by Value

Call by Name/Call by Value

Value from JavaScript object returns null

Null value returns from AddressBook framework in swift

Getting a value from parent activity returns null

JPA Repository.findById() returns null but the value is exist on db

JPA Repository.findById() returns null but the value is exist on db

Vertx3 - Return a value from a JDBC connection? (sql db).

Function call as parameter value?

getLastKnownLocation returns Null value

@Value in Springboot returns null

getLastKnownLocation returns Null value