title: Android MySQLLite select query not working, does not fetch results from code
body: <p>I am developing an Android application and have a following query:</p>
  
  <pre><code>result = myDataBase.query(HD_TABLENAME, new String[]{HD_KEYDATE, HD_KEYFESTID},
           "YEAR = "+ year +" AND MONTH = " + month, null, null, null, HD_KEYDATE);
  </code></pre>
  
  <p>I have written a custom DataBaseHelper which calls this query.</p>
  
  <p>The above results into the following query: </p>
  
  <pre><code>SELECT DATE, FESTIVALID FROM HOLIDAYDATES WHERE YEAR = 2010 AND MONTH = 1 ORDER BY DATE
  </code></pre>
  
  <p>when i execute the same query from SQLLite admin on the same file, it returns the required rows.</p>
  
  <p>There is no exception, how can i get the above to work.
  The database exists and It works for a previous query.
  Is there any property of the result object which I can check to see what is the exact error?</p>
  
  <p>NOT SURE IF THIS WILL HELP:
  A logcat message that I get after the execution  of the query :</p>
  
  <blockquote>
    <p>04-19 10:39:54.803: DEBUG/SntpClient(71): request time failed:    java.net.SocketException: Address family not supported by protocol</p>
  </blockquote>
  
  <p>CLARIFICATION:
  One of the properties has this:
  result.mStackTrace has the value = android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here</p>
  
  <p>Now, I guess first I have to close and open some cursor which I foolishly left open, but now trying to find it, if you can suggest anything, please do.</p>
  
  <p>ADDITIONAL QUESTION, is there any way to see the open connections to the database?</p>