Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sounds strange, but I had the exact same problem. The app I was working on was making several successive requests to download a bunch of thumbnail images to display in a ListView, and after the second one it would hang as if there was a dead lock in the HttpClient code.</p> <p>The strange fix that I found was to use AndroidHttpClient instead of DefaultHttpClient. As soon as I did this, and I tried a lot of stuff before going this route, it started working just fine. Just remember to call client.close() when you're done with the request.</p> <p>AndroidHttpClient is described in the documentation as DefaultHttpClient with "reasonable default settings and registered schemes for Android". Since this was introduced in api level 8 (Android 2.2), I dug up the source to duplicate these "default settings" so that I could use it further back than that api level. Here is my code for duplicating the defaults and a helper class with a static method for safely closing it</p> <pre><code>public class HttpClientProvider { // Default connection and socket timeout of 60 seconds. Tweak to taste. private static final int SOCKET_OPERATION_TIMEOUT = 60 * 1000; public static DefaultHttpClient newInstance(String userAgent) { HttpParams params = new BasicHttpParams(); HttpProtocolParams.setVersion(params, HttpVersion.HTTP_1_1); HttpProtocolParams.setContentCharset(params, HTTP.DEFAULT_CONTENT_CHARSET); HttpProtocolParams.setUseExpectContinue(params, true); HttpConnectionParams.setStaleCheckingEnabled(params, false); HttpConnectionParams.setConnectionTimeout(params, SOCKET_OPERATION_TIMEOUT); HttpConnectionParams.setSoTimeout(params, SOCKET_OPERATION_TIMEOUT); HttpConnectionParams.setSocketBufferSize(params, 8192); SchemeRegistry schReg = new SchemeRegistry(); schReg.register(new Scheme("http", PlainSocketFactory.getSocketFactory(), 80)); schReg.register(new Scheme("https", SSLSocketFactory.getSocketFactory(), 443)); ClientConnectionManager conMgr = new ThreadSafeClientConnManager(params, schReg); DefaultHttpClient client = new DefaultHttpClient(conMgr, params); return client; } } </code></pre> <p>And in another class...</p> <pre><code>public static void safeClose(HttpClient client) { if(client != null &amp;&amp; client.getConnectionManager() != null) { client.getConnectionManager().shutdown(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POandroid httpclient hangs on second request to the server (connection timed out)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USRich
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POandroid httpclient hangs on second request to the server (connection timed out)
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks a lot, I'll try this method. Do you use one instance for all your requests after these changes or call newInstance every time you need to send data? And do you call safeClose after EACH request?
      singulars
      1. PO
      1. USNorthern Captain
    2. COYep...new instance every time, and safeClose every time. I don't notice a performance hit at all, and this app I was doing at the time I first had this problem makes a ton of service requests.
      singulars
      1. PO
      1. USRich
    3. COIf I do the same, close and open new instance every time, then the problem vanishes. But I read in the docs that it is strongly recommended to reuse HttpClient+ConnManager and do not create it for every connection, that should save a lot of time and cpu... Am I wrong?
      singulars
      1. PO
      1. USNorthern Captain
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload