title: How do you get multiple resultset from a single CallableStatement?
body: <p>When I call the stored proc from command line I get the following. </p>
  
  <pre><code>CALL `events`.`get_event_by_id`(10)
  
  +---------+----------+-------------+---------------------+---------------------+---------------------+--------+----------+
  | evet_id | name     | description | starttime           | endtime             | last_modified       | active | addre_id |
  +---------+----------+-------------+---------------------+---------------------+---------------------+--------+----------+
  |      10 | samole 3 | sanely      | 2013-11-27 17:37:00 | 2013-11-27 18:09:00 | 2013-11-27 09:37:42 |      1 |       20 |
  +---------+----------+-------------+---------------------+---------------------+---------------------+--------+----------+
  1 row in set (0.00 sec)
  
  +---------+------------+---------+
  | user_id | username   | picture |
  +---------+------------+---------+
  |       1 | jamess2000 | NULL    |
  |       2 | yferna2012 | NULL    |
  +---------+------------+---------+
  2 rows in set (0.00 sec)
  
  +----------+------------------------------+---------------------+-------------+--------+
  | addre_id | street                       | name                | description | active |
  +----------+------------------------------+---------------------+-------------+--------+
  |       20 | Schieffelin                  | Manhattan Ville Loc | NULL        |      1 |
  +----------+------------------------------+---------------------+-------------+--------+
  </code></pre>
  
  <p>Here is a snippet of my Java Code</p>
  
  <pre><code>String SP_GET_EVENT_BY_ID = "CALL `events`.`get_event_by_id`(?)";
  String PROC_PARAM_EVENT_ID = "evet_id";
  mCallableStatement = mConnection.prepareCall(SP_GET_EVENT_BY_ID);
  mCallableStatement.setInt(10, PROC_PARAM_EVENT_ID);
  </code></pre>
  
  <p>When I execute the statement, only the event_table results are returned.
  I read the query with the following:</p>
  
  <pre><code>ResultSet reader = mCallableStatement.executeQuery();
  
  while(reader.next())
  {
     //etc..... here i assign db values to properties. 
  }
  </code></pre>
  
  <p>I am trying to avoid making multiple request to the database because it's extremely slow (300 ms depending on on how many results)</p>
  
  <p>Is it even possible?</p>