title: How to pass array of strings dynamically to SQL "IN" clause in Java?
body: <p>I have a array of Strings "String[]" with certain values. I want to pass that array dynamically to SQL "IN" clause something like:</p>
  
  <pre><code>Select * from Employee where emp_name in (?);
  </code></pre>
  
  <p>Here "?" has to replaced with String Array. I want to do this in Java Class. I tried with </p>
  
  <pre><code>Array array = conn.createArrayOf("VARCHAR", new Object[]{"1", "2","3"});
  pstmt.setArray(1, array);
  </code></pre>
  
  <p>But it is not working and getting exception "SQLFeatureException".</p>
  
  <p>Thanks!!!</p>