title: Cannot insert data with sql form spring hibernate with createSQLQuery(sql).executeUpdate()
body: <p>I am working in a spring project, where I use hibernate 3.5.5-Final and my database is MySQL. My code is bellow</p>
  
  <pre><code>    String sql = "INSERT INTO recently_sold_products (product_id, sell_time) VALUES ('9749', '2016-06-01 00:00:00')";
      Query query = getCurrentSession().createSQLQuery(sql);
      System.out.println("Updating recently sold products. Row = " + query.executeUpdate());
  </code></pre>
  
  <p>This give me output Like</p>
  
  <p>Updating recently sold products. Row = 1</p>
  
  <p>But when i check the database table, I found no row. </p>
  
  <p>In this table product_id is primary key. If I try to insert a duplicate product_id then I found the error messages, Duplicate entry '9749' for key 'PRIMARY', which confirm that the query reach in the database. But if I try to insert a normal row then the output of executeUpdate() method is 1, but no row insert in table.</p>
  
  <p>I cannot understand what happen. </p>