title: jmeter jdbc variable names query
body: <p>Again more apologies from myself for being a Jmeter newbie - I'm a little stuck with the JDBC requests - I've trawled through the posts on this site for the last 3 hours - but I can't quite find anything relevant (unless I'm missing something).</p>
  
  <p>My environment: Jmeter v2.11, JDK 7, Oracle 12</p>
  
  <p>It's very simple - I have a JDBC Sampler that I need to setup to use the value that is provided by a JDBC PreProcessor.</p>
  
  <p>Essentially I have a JDBCPreProcessor setup to identify the next (new) record's unique reference (call it applicationID)</p>
  
  <p>JDBC PreProcessor Details</p>
  
  <p>Select Statement --> select max(applicationID)+1 from table;</p>
  
  <p>I have a JDBC Sampler setup that I need to use the 'max(applicationID)+1' value (determined by the JDBC preprocessor)</p>
  
  <p>JDBC Sampler Details</p>
  
  <p>Select Statement --> select status from table where applicationID = 'max(applicationID)+1'</p>
  
  <p>I am unsure how to do this.  I have looked at the instructions and a lot of other Jmeter JDBC request posts, but I'm afraid I can't find the relevant info I need.</p>
  
  <p>I did try including adding a 'Variable Name' of 'maxrecordidvar' in the JDBC PreProcessor and set the JDBC Sampler query --> select status from table where applicationID = maxrecordidvar</p>
  
  <p>HOWEVER - this (obviously) didn't work - I get an Oracle error 'ORA-00904: "MAXRECORDIDVAR": invalid identifier'</p>
  
  <p>Again, many apologies if this is a stupid question and many thanks for all/any help anyone can provide!</p>