title: Prepared Statement Not Escaping Apostrophe
body: <p>I am using JDBC connection object obtained from hibernate to perform bath update, I am doing this because I need to use the MySql ON DUPLICATE feature. But, when trying to insert I am not able to inset saying the string has special characters,</p>
  
  <pre><code>Session session = sessionFactory.openSession();
  PreparedStatement pstm = null;
  Connection conn = session.connection();
  
  try
  {
      IRKeyWordTweet record = null;
      conn.setAutoCommit(false);
  
      for (Iterator itrList = statusToInsert.iterator(); itrList.hasNext();) 
      {   
          try
          {
              record = (IRKeyWordTweet) itrList.next();
              pstm = (PreparedStatement) conn.prepareStatement("INSERT QUERY");
  
              System.err.println(record.getTwtText());
  
              //tweetId
              pstm.setLong(1, record.getTweetId());
  
              Setters For Prepared statement....
              pstm.addBatch();
              int[] updateCounts = pstm.executeBatch();
          }
          catch (Exception e) 
          {
              e.printStackTrace();
          }
      }
  }
  catch (Exception e) 
  {
      log.error("Exception Occured",e);
  }
  finally
  {   
      try 
      {
          pstm.close();
          conn.close();
      }
      catch (SQLException e) {
          e.printStackTrace();
      }
      session.close();
  }
  </code></pre>
  
  <p>What could be causing this?</p>