title: execute query in java not return results but in mysql workbench still return results
body: <p>This query:</p>
  
  <pre><code>    SELECT 
      r.report_id,
      r.user_id,
      u.user_name,
      u.user_mail,
      d.department_name,
      r.report_comment,
      r.report_target_date,
      r.report_create_date,
      r.report_revised_date,
      r.report_root_id,
      report_revised_id
  FROM
      report r
          JOIN
      user u ON u.user_id = r.user_id
          JOIN
      department d ON u.department_id = d.department_id
          JOIN
      authority a ON r.user_id = a.user_src_id
          AND a.user_dest_id = 131
  WHERE
      r.report_target_date BETWEEN '2014-07-23 23:59:00' AND '2014-08-22 00:00:00'
      AND r.report_comment LIKE '%事務%'
  </code></pre>
  
  <p>In mysql workbench this query has return value but when using it in java it's not returning anything:</p>
  
  <pre><code>Statement stmt = connection.createStatement(); 
  ResultSet rs = null;
  rs = stmt.executeQuery(query);
  </code></pre>
  
  <p>In mysql workbench this query has return value but rs return is empty.</p>