MySQL query Cache / Java

[Miran Cvenkel]

1. I have

SET query_cache_type = 1; RESET QUERY CACHE ;

so when same query query executed second time , it goes a lot faster like 1.5 --> 0,05 sec (in client program like forinstance HeidiiSQL)

2. I'm executing this many times via browser refresh so SQL is allways the same (also the same as at 1), but timing (sql_execution_time) is allways the 'same' 1.5s + a bit more.
Like caching would not work.
Using prooxol connection pool manager

      Calendar cal = Calendar.getInstance();
      long startTime = cal.getTimeInMillis();

      d_recordCount = con.executeStoredProcedure("getOnePageOfDataNew", args, outparm);

      Calendar cal1 = Calendar.getInstance();
      long endTime = cal1.getTimeInMillis();
      [color=red]sql_execution_time[/color] = endTime - startTime;

Any explanation ?

[Miran Cvenkel]

red part takes time. Should I change something in first line , or is that it ?

 public void setDataSet(String sql) throws SQLException 
  {

      java.sql.Statement stm = this.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
     [color=red] this.rs = stm.executeQuery(sql);[/color]
      this.rsEmpty =  !this.rs.first();

  }