title: JDBC prepared statement to query JSON using json_exists
body: <p>I'm facing trouble transforming the below query to jdbc prepared statement and setting the parameters.</p>
  
  <p>oracle query:</p>
  
  <pre><code>select * from TRANSACTION_DUMMY where ID = 'aa'
  and JSON_EXISTS(TRANSACTION_DUMMY_INDEX FORMAT JSON, 
   '$.header.lineItems[*].status?(@=="complete")')
  </code></pre>
  
  <p>translated query:</p>
  
  <pre><code>select * from TRANSACTION_DUMMY where ID = ?
  and JSON_EXISTS(TRANSACTION_DUMMY_INDEX FORMAT JSON, 
  '$.header.lineItems[*].status?(@==?)')
  </code></pre>
  
  <p>the issue is how to set parameters in the query.
  tried playing around with indexes but always getting the error, invalid column index.</p>
  
  <p>any pointers how to handle the above scenario using java jdbc prepared statement?</p>
  
  <p>thanks</p>