title: Trouble with PreparedStatement that uses union of selects query and IN CLAUSE
body: <p>I wrote a query of the form:</p>
  
  <pre><code>select .... where x.y in (?) union select .... where p.y in (?) and a.b not in (?) 
  </code></pre>
  
  <p>The question marks indicate places where I put multiple values at run time (dynamically putting values in the IN clause) using the preparedStatement.setString() method.</p>
  
  <p>The resultset, on executing this query seems to ignore the query after the union clause.
  I get no exception anywhere.</p>
  
  <p>I post this question, just to know if anyone else has faced such a problem, like this link suggests <a href="http://www.sitepoint.com/forums/databases-88/help-union-multiple-tables-preparedstatement-not-working-291897.html" rel="nofollow">UNION of multiple tables and preparedstatement not working</a>
  The database is Oracle 10g, in case that makes a difference.</p>