title: Invalid data conversion: Parameter instance 50.0/100 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815
body: <pre><code>String expression = CHEMICAL_REORDERPOINT + "*" + searchRequest.getReorderPercentage() + "/100)";
  </code></pre>
  
  <p>Before :</p>
  
  <pre><code>String expression = CHEMICAL_REORDERPOINT + "*" + searchRequest.getReorderPercentage() + "/100)";
  </code></pre>
  
  <p><code>searchRequest.getReorderPercentage()</code> comes dynamically from browser after submit value.
  Lets take value for <code>searchRequest.getReorderPercentage() = 50</code></p>
  
  <pre><code>so String expression = CHEMICAL_REORDERPOINT*50/100; 
  </code></pre>
  
  <p>This is getting populated in a prepared statement of <code>JDBC</code> in my application, so to maintain the prepare statement rule i have used in below way:</p>
  
  <p>After :</p>
  
  <pre><code>String expression = CHEMICAL_REORDERPOINT + "*?)"
  String str = searchRequest.getReorderPercentage() + "/100";
  params.add(str)
  </code></pre>
  
  <p>here params is a list from which the parameters will be iterated and will be placed in postion parameters of prepare statement while executing it.</p>
  
  <p>But now i m getting exception like 
   <strong>Invalid data conversion: Parameter instance 50.0/100 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815</strong></p>
  
  <p>Pls can any one help me out. Thanks</p>