How to combine random variable with character '%' in Jmeter JDBC Sampler?

Question

I am trying to make workload test in Jmeter. This is Postgresql and I would like to combine a random variable with '%'.

Could you help me the way to make sql query?

I have already tried with '?%', but there is an error "The column index is out of range: 1, number of columns: 0.".

Answer 1

The easiest way is switching to Select Statement and amend your query to look like:

SELECT * FROM scloud_usr.tcus_usr_rgn where UID like '${__RandomString(3,ABD,UID)}%'

---

If you want to continue with the Prepared Select Statement you need to add this % wildcard to the parameter value itself, not in the query, i.e.

More information:

• Using “like” wildcard in prepared statement
• Performance Testing BLOB from a MySQL Database with JMeter
• Prepared statements with % wildcards