AQA: jmeter: create assertions for JDBC (Database)

How to extract JDBC Request response?

My JDBC request response is as below,

request_token   create_date

Vve5vyD42ZPr5ssTIduzy1l6cvb/hDPaCMXnF8cFcpaCfdRMvNChB43I+JSgmgvy2owklXPRGvIVolDhb12lU2dIXko6ajlqyKoh3RjhPYo=    2015-02-25 18:56:00.0

How to extract only 'request token' from the response?

Answer:

In your JDBC Sampler add the following values into "Variables" input:

token,date

See below image for details:

https://i.stack.imgur.com/Hkz91.png

You'll be able to refer "request_token" value as ${token_1} and "create_date" value as ${date_1}

See the following material for more information:

• JDBC Request Sampler Documentation

• The Real Secret to Building a Database Test Plan With JMeter

How to get current date and time?

Use __time function:

• ${__time(dd/MM/yyyy,)}
• ${__time(hh:mm a,)}

${__time(dd-mmm-yyyy HHmmss)} 20-032-2015 233224
${__time(d-MMM-yyyy hhmmss)}  20-May-2015 113224
${__time(dd-m-yyyy hhmmss)}   20-32-2015 113224
${__time(D-M-yyyy hhmmss)}    140-5-2015 113224
${__time(DD-MM-yyyy)}         140-05-2015

Additional info:

http://www.tutorialbyexample.com/2015/02/oracle-database-testing-jmeter-tutorials.html

JMeter Beginner Tutorial 10 - How to create assertions for JDBC (Database) Test Plan