title: Parameterize a JDBC SQL Query in SOAP UI from a Custom Property
body: <p>To proceed with a Database validation, I am having a need of comparing a record in the DB along with a data which is dynamically generated in the previous REST response, using <code>SoapUI</code>.</p>
  
  <p>I have already captured the property value using a <code>Property Transfer</code> step and stored the required value in a custom property in Test-Case successfully i.e., using property expansion, say <code>${TestCase#customerId}</code></p>
  
  <p>My intention is to use that particular value stored in the custom properties to query the result I am expecting, in the <code>JDBC Request</code> test step.</p>
  
  <p>The query which I have drafted with the parameter is as below : </p>
  
  <pre><code>Select * 
  From ABC.SEC_CUST
  Where ABC.SEC_CUST.CUSTOMER_ID =  ${TestCase#customerId} 
  </code></pre>
  
  <p>The response I receive after executing is as below.</p>
  
  <blockquote>
    <p>Error getting response; java.sql.SQLSyntaxErrorException : ORA-00911: Invalid character.</p>
  </blockquote>
  
  <p>But, when I run the query without the parameterized value it executes perfectly. Where, I tend the conclusion as there is a syntax issue in the way I have mentioned the parameter in the query. </p>
  
  <p>But, I am unable to find the correct way to mention the parameter in the query in SoapUI.</p>
  
  <p>Can anyone with experience in SoapUI, please assist me on this?</p>