[Resolved] The connection to adb is down, and a severe error has occured.

System returns the following error when running an android project in Eclipse.



[2013-01-17 22:34:06 - XXX] The connection to adb is down, and a severe error has occured.
[2013-01-17 22:34:06 - XXX]You must restart adb and Eclipse.
[2013-01-17 22:34:06 - XXX] Please ensure that adb is correctly located at 'C:\android-sdks\platform-tools\adb.exe' and can be executed.


Solution:
1. Restart eclipse
2. In command prompt, go to the Android sdk platform-tools directory.
3. type command: adb kill-server
4. and then type command: adb start-server

Meanwhile, the following logs will be shown in eclipse.

[Resolved] You must have AdActivity declared in AndroidManifest.xml with configChanges

You must have AdActivity declared in AndroidManifest.xml with configChanges.

Solution

Add the following Activity in AndroidManifest.xml file.

<application ...>

<activity android:name="com.google.ads.AdActivity"

android:configChanges="keyboard|keyboardHidden|orientation|screenLayout|uiMode|screenSize|smallestScreenSize" />

</application>

Local datetime in SQLite

This article shows how to get the local date time from SQLite


When we run the following SQL, it returns the UTC time..

select datetime('now');

2012-12-26 16:01:07




To return the local time, you can add the the parameter 'localtime' 

select datetime('now', 'localtime');

2012-12-27 00:01:07

[How-to] Get the year-month-day (yyyy-mm-dd) from a date field in SQLite

SQLite is the database for the Android Application.

The following SQL is an example of getting date by SQL statement.

select _id, strftime('%Y-%m-%d', create_date) c_date from TABLE1

Returned result:

Another SQL example shows how to get counts of records by date

select strftime('%Y-%m-%d', create_date), count(strftime('%Y-%m-%d', create_date) ) from TABLE1 group by strftime('%Y-%m-%d', create_date)

More reference for the date field in SQLite can be found in the official website
http://www.sqlite.org/lang_datefunc.html

[Resolved] Android: WebView Web Page not available

Today I'm trying to create a WebView in Android, it shows a Web page not available after running the app in the emulator.

       protected void onCreate(Bundle savedInstanceState) {

              super.onCreate(savedInstanceState);

              setContentView(R.layout.activity_main);

             

              WebView wv = (WebView) findViewById(R.id.webView1);             

              wv.loadUrl("https://www.google.com");

             

                }

Solution 

1. Make sure the permission is granted

<uses-permission android:name="android.permission.INTERNET"></uses-permission>

2. Make sure the following bold content in your code

       protected void onCreate(Bundle savedInstanceState) {

              super.onCreate(savedInstanceState);

              setContentView(R.layout.activity_main);

             

              WebView wv = (WebView) findViewById(R.id.webView1);

              wv.setWebViewClient(new WebViewClient(){});

             

              wv.loadUrl("https://www.google.com");

             

                }

Andriod Permission: Connect to Internet

The following permission should be grant for the internet connection from Android Application.

<manifest xmlns:android="http://schemas.android.com/apk/res/android" ... />

    ...

    <uses-permission android:name="android.permission.INTERNET" />

</manifest>

[RESOLVED] E/ERR(1183): org.apache.http.conn.HttpHostConnectException: Connection to http://localhost refused

Today I am trying to write an android program to retrieve an XML data from localhost server. When running the program, the following error occurs:

E/ERR(1183): org.apache.http.conn.HttpHostConnectException: Connection to http://localhost refused

              String url = "http://localhost:100/test.xml";

              try {

                     DefaultHttpClient httpClient = new DefaultHttpClient();

                     HttpPost httpPost = new HttpPost(url);

                     HttpResponse httpResponse = httpClient.execute(httpPost);

              } catch (ClientProtocolException e1) {

                     // TODO Auto-generated catch block

                     e1.printStackTrace();

              } catch (IOException e1) {

                     // TODO Auto-generated catch block

                     e1.printStackTrace();

              }

             

 


Solution:
The Android emulator could not recognize the localhost and results in connection refused.
To resolve, we can change the localhost to the ip address 10.0.2.2 and try again, problem resolved.

e.g. String url = "http://10.0.2.2:100/test.xml";