Android SQLite Database Viewer or Debuging with Stetho

Every Android Developer uses SQLite Database to store data into the Android Application data. But to view the data in SQLite have a lot of options to view.

Today I am going to explain one of the famous Database viewer introduced by the Facebook.
Facebook people have released one SQLite Database viewer called Stetho. By using this Developers can access the SQLite database from the Chrome desktop browser.

Add this line to your build.gradle file:

compile 'com.facebook.stetho:stetho:1.4.2'

 And add this line to your Activity/Application Class onCreate() method: 

public class MyApplication extends Application {
  public void onCreate() {
    super.onCreate();
    Stetho.initializeWithDefaults(this);
  }
}

Once application Runs in your Emulator/Real Device you can see the database from the Chrome.

Open it from Chrome :

chrome://inspect/#devices 

you can see the below screen:

Step 2:

Source Information from:
https://github.com/facebook/stetho

AlertDialog List Items with onClick and onItemLongClick

                // TODO Auto-generated method stub
                AlertDialog.Builder alertBuilder = new AlertDialog.Builder(
                        ListAlertDailog.this);
                alertBuilder.setIcon(R.drawable.ic_launcher);
                alertBuilder.setTitle("Select Mobile OS:-");
                final ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(
                        ListAlertDailog.this,
                        android.R.layout.select_dialog_item);
                arrayAdapter.add("Android");
                arrayAdapter.add("IOS");
                arrayAdapter.add("Windows");
                arrayAdapter.add("Bada");
                arrayAdapter.add("BlackBerry OS");
                arrayAdapter.add("Symbian OS");

                alertBuilder.setNegativeButton("Cancle",
                        new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialog,
                                    int which) {
                                dialog.dismiss();
                            }
                        });

                alertBuilder.setAdapter(arrayAdapter,
                        new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialog,
                                    int which) {
                                String strOS = arrayAdapter.getItem(which);
                                Toast.makeText(getApplicationContext(),
                                        "On click selected " + strOS, Toast.LENGTH_SHORT)
                                        .show();
                                dialog.dismiss();
                            }
                        });

                final AlertDialog alertDialog = alertBuilder.create();
                alertDialog.setOnShowListener(new OnShowListener() {

                    @Override
                    public void onShow(DialogInterface dialog) {
                        // TODO Auto-generated method stub
                        ListView listView = alertDialog.getListView();
                        listView.setOnItemLongClickListener(new OnItemLongClickListener() {

                            @Override
                            public boolean onItemLongClick(
                                    AdapterView<?> parent, View view,
                                    int position, long id) {
                                // TODO Auto-generated method stub
                                String strOS = arrayAdapter.getItem(position);
                                Toast.makeText(getApplicationContext(),
                                        "Long Press " + strOS,
                                        Toast.LENGTH_SHORT).show();
                                alertDialog.dismiss();
                                return true;
                            }
                        });
                    }
                });

                alertDialog.show();
           

How to compare dates in android or Java (String format dates compare in java)

  Here is the example to compare 2 string format dates :

 
 String dateOneStr = "12/02/2016";

        String dateTwoStr = "13/02/2016";

        Date date1,date2;
    DateFormat df = new SimpleDateFormat("dd/MM/yyyy"); 
    try {
     date1 = df.parse(dateOneStr);
     date2 = df.parse(dateTwoStr);
       
        if(date1.after(date2)){
               System.out.println("Date1 is after Date2");
           }

           if(date1.before(date2)){
               System.out.println("Date1 is before Date2");
           }

           if(date1.equals(date2)){
               System.out.println("Date1 is equal Date2");
           }
       
    } catch (ParseException e) {
        e.printStackTrace();
    }

How To Fix Eclipse Error - Java was started but returned exit code 13

Some times after installing sdk or new plugins to eclipse we will face the issue like

Java was started but returned exit code 13 message with dialog and we can't able to open eclipse

Resolve this issue by followed by below points:

1)open eclipse folder where your using eclipse

2)check for "eclipse.ini" file in the same folder

example path:

D:\Surya Android\eclipse-java-indigo-SR1-win32\eclipse here is eclipse is root folder

and check for eclipse.ini file

Right click and chose edit option

and now you can see the file like the below format:

-startup
plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.1.100.v20110502
-product
org.eclipse.epp.package.java.product
--launcher.defaultAction
openFile
--launcher.XXMaxPermSize
128M
-showsplash
org.eclipse.platform
--launcher.XXMaxPermSize
128m
--launcher.defaultAction
openFile
-vmargs
-Dosgi.requiredJavaVersion=1.7
-Xms512m
-Xmx512m









at the end of the line just paste below 2 lines of text
-vm
C:/Program Files/Java/jdk1.7.0_75/bin/javaw.exe
And now save the file and restart the eclipse now eclipse will work fine.

Could not create the Java Virtual Machine.

I am using Eclipse IDE for development from so many years. recently i installed on plugin from the market place in eclipse. And i restarted eclipse,  at that time i can't able to open eclipse in my system.
i am facing below issue.

Error : Could not create the Java Virtual Machine.
Error: A fatal exception has occurred.Program will exit.

To resolve above issue i followed below point.

I just opened "eclipse.ini"file in eclipse folder.

And i  removed the -vm P:\Programs\jdk1.6\bin lines.

And i changed the required java version from

1.5 to 1.6 set  -Dosgi.requiredJavaVersion=1.6.

Import a large sql dump file to a MySQL database using command line

Steps to import large amount of data (dump ) file to mysql using command line. 

1. Open a command prompt (or shell) with administrative privileges

2. Connect to a MySQL instance using command line

If you are using online/hosted sql like (AWS)

$PATH_TO_MYSQL\mysql.exe -h 198.166.1.9 --port=3306 -u root -p

If you are in localhost you do not need host and port

$PATH_TO_MYSQL\mysql.exe -u root -p

3. Check your network buffer length value.

            SHOW VARIABLES LIKE 'net_buffer_length';

4. If the value is less than 1000000 .Set network buffer length to a large byte number. The default value may throw errors for such large data files

set global net_buffer_length=1000000;

5. Set maximum allowed packet size to a large byte number. The default value may throw errors for such large data files.

set global max_allowed_packet=1000000000;

6. Disable foreign key checking to avoid delays, errors and unwanted behavior

SET foreign_key_checks = 0;

SET UNIQUE_CHECKS = 0;

SET AUTOCOMMIT = 0;

7. Import your sql dump file

source C:\db_dumpfolder\filename.sql

Here “C:\db_dumpfolder\filename.sql” is a fully qualified path of your sql file.

8. Once total sql file execution completed. Don’t forget to enable foreign key checks when procedure is complete!

      SET foreign_key_checks = 1;

      SET UNIQUE_CHECKS = 1;

      SET AUTOCOMMIT = 1;

If you want to edit large amount of sql file(if you are unable to open large .sql file) use below Notepad.

http://www.editpadlite.com/

This Source from the:

https://cmanios.wordpress.com/2013/03/19/import-a-large-sql-dump-file-to-a-mysql-database-from-command-line/

  

         

How to show Android Activity as a dialog in Android

we can apply a dialog theme to an activity so that it is displayed as a floating dialog.

To apply a dialog theme to an activity, just modify the <Activity> element in the AndroidManifest.xml file by adding the android:theme attribute(android:theme="@android:style/Theme.Dialog") to the Activity.


 In Manifest file just add one simple attribute to show activity as a dialog.

 <activity
android:label="@string/app_name"
android:name=".Activity"
android:theme="@android:style/Theme.Dialog"  />

Then here we got one doubt how to close this activity dialog? 

solution is just call finish( ) method to close the activity dialog.

New Customized Alert Dialog in Android with Sweet Alert Dialog Example

Check out The below wonder full Alert Dialog in Android Using

Sweet Alert.

Sweet Alert. a beautiful and best Alert Dialog with Best UI.

Check out for more information:

Credits :   https://github.com/pedant/sweet-alert-dialog

Exception occurred while reading or writing file {0}The Axis2 facets cannot be installed since the Axis2 runtime location has not been set. Go to the Web Services preference page and set the Axis2 runtime location under Axis2 Preferences

This is the exception am getting when am trying to create a web service.


Exception occurred while reading or writing file {0}The Axis2 facets cannot be installed since the Axis2 runtime location has not been set.   Go to the Web Services preference page and set the Axis2 runtime


How to Resolve this Issue ?

Create Dummy dynamic web project with axis2 feature and leave it. Next try your old project .

how to change port no of jboss manually

Here the procedure to change the port number of jboss (or) check the current port number of jboss server

These are the steps to change port number of jboss manually.

Steps:

 1) Go to below path

     jboss-6.0.0.Final\server\default\deploy\jbossweb.sar\  

  2) Fnd out server.xml in jbossweb.sar folder

  3) Open server.xml

  4) Check this below tag in xml file and change port attribute in xml .

    <Connector protocol="HTTP/1.1" port="8243" address="${jboss.bind.address}" 
           redirectPort="${jboss.web.https.port}" />

 5) Restart your JBoss server.

  Now check from your browser

   http://localhost:8243/

how to disable or restrict specific number in keyboard while entering into Edittext Android

Hi here the below code used to restrict or disable specific number while enter in Edittext.

You no need to use any filters or lot of lines code just using simple attribute in Edittext.

i.e using android:digits attribute you can resolve this issue

Code to restrict '0' while entering any number in Edittext.

android:digits="123456789"

Code to restrict '1' while entering any number in Edittext.

 android:digits="234567890"
Code to restrict '2' while entering any number in Edittext.

 android:digits="134567890"

Code to restrict '3' while entering any number in Edittext.

 android:digits="124567890"

Code to restrict '4' while entering any number in Edittext.

 android:digits="123567890"

Code to restrict '5' while entering any number in Edittext.

 android:digits="123467890"

Code to restrict '6' while entering any number in Edittext.

 android:digits="123457890"

Code to restrict '7' while entering any number in Edittext.

 android:digits="123456890"

Code to restrict '8' while entering any number in Edittext.

 android:digits="123456790"

Code to restrict '9' while entering any number in Edittext.

 android:digits="123456780"


Code to restrict '0' while entering any number in Edittext.

Example:

 <EditText
        android:id="@+id/number"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:digits="123456789"
        android:hint="Enter Pin"
        android:inputType="number" >

How to show .gif images in android (load .gif image from url example source)

Here the below example shows how to access .gif images from web and shown in android programmatically(Load animated GIF from Internet)


when an application attempts to perform a networking(Internet) operation(i.e connecting to internet,dowload images etc..) on its main thread.we will get "NetworkOnMainThreadException"

In such cases we should implement this requirement using background task like(asynctask,threads)

Here the below code to load gif image from URL

1) Create ShowGifView.java  class which extends View

This is the main class ShowGifView  takes input as context object and url of .gif image .

get the image from url and reload view.

package com.androidsurya.giffromurl;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;

import android.content.Context;
import android.graphics.Canvas;
import android.graphics.Movie;
import android.os.AsyncTask;
import android.util.AttributeSet;
import android.view.View;

public class ShowGifView extends View {

// Set true to use decodeStream
// Set false to use decodeByteArray
private static final boolean DECODE_STREAM = true;

private InputStream gifInputStream;
private Movie gifMovie;
private int movieWidth, movieHeight;
private long movieDuration;
private long mMovieStart;

static String gifURL;

public ShowGifView(Context context, String a) {
super(context);
gifURL = a;
init(context);
}

public ShowGifView(Context context, AttributeSet attrs) {
super(context, attrs);
init(context);
}

public ShowGifView(Context context, AttributeSet attrs, int defStyleAttr) {
super(context, attrs, defStyleAttr);
init(context);
}

private void init(final Context context) {
setFocusable(true);

gifMovie = null;
movieWidth = 0;
movieHeight = 0;
movieDuration = 0;
Loder task = new Loder();
task.execute(new String[] { gifURL });

}

private static byte[] streamToBytes(InputStream is) {
ByteArrayOutputStream os = new ByteArrayOutputStream(1024);
byte[] buffer = new byte[1024];
int len;
try {
while ((len = is.read(buffer)) >= 0) {
os.write(buffer, 0, len);
}
} catch (java.io.IOException e) {
}
return os.toByteArray();
}

@Override
protected void onMeasure(int widthMeasureSpec, int heightMeasureSpec) {
setMeasuredDimension(movieWidth, movieHeight);
}

public int getMovieWidth() {
return movieWidth;
}

public int getMovieHeight() {
return movieHeight;
}

public long getMovieDuration() {
return movieDuration;
}

@Override
protected void onDraw(Canvas canvas) {

long now = android.os.SystemClock.uptimeMillis();
if (mMovieStart == 0) { // first time
mMovieStart = now;
}

if (gifMovie != null) {

int dur = gifMovie.duration();
if (dur == 0) {
dur = 1000;
}

int relTime = (int) ((now - mMovieStart) % dur);

gifMovie.setTime(relTime);

gifMovie.draw(canvas, 0, 0);
invalidate();

}

}

private class Loder extends AsyncTask<String, Void, String> {
@Override
protected String doInBackground(String... urls) {
URL gifURL;
try {
gifURL = new URL(urls[0]);
HttpURLConnection connection = (HttpURLConnection) gifURL
.openConnection();

gifInputStream = connection.getInputStream();

// Insert dummy sleep
// to simulate network delay
try {
Thread.sleep(3000);
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

if (DECODE_STREAM) {
gifMovie = Movie.decodeStream(gifInputStream);
} else {
byte[] array = streamToBytes(gifInputStream);
gifMovie = Movie.decodeByteArray(array, 0, array.length);
}
movieWidth = gifMovie.width();
movieHeight = gifMovie.height();
movieDuration = gifMovie.duration();
} catch (MalformedURLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

@Override
protected void onPostExecute(String result) {
invalidate();
requestLayout();

}
}

}

2) Create showgif.xml file under layout folder. 

Copy the below code

Here addView used to attach .gif view to this layout.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <RelativeLayout
        android:id="@+id/addView"
        android:layout_width="match_parent"
        android:layout_height="match_parent" >
    </RelativeLayout>

</LinearLayout>

3) Create ShowGifActivity.java  

package com.androidsurya.giffromurl;

import android.app.Activity;
import android.os.Bundle;
import android.widget.RelativeLayout;

public class ShowGifActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.showgif);
RelativeLayout myLayout = (RelativeLayout) findViewById(R.id.addView);
                    //code to add gif image view to RelativeLayout -here created object to ShowGifView.class and pass the current object and url
myLayout.addView(new com.androidsurya.giffromurl.ShowGifView(this,
"http://www.dan-dare.org/Dan%20Sonic/SonicTailsPlaneAni.gif"));
}
}

4) Last but important thing is AndroidManifest.xml

Note : Add Internet permission and   android:hardwareAccelerated="false" Tags.

<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.androidsurya.giffromurl"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="8"
      />
<uses-permission  android:name="android.permission.INTERNET"/>
    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.androidsurya.giffromurl.ShowGifActivity"
            android:hardwareAccelerated="false"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

Output Screenshot:

Actionbar in android 2.2 (Below Android 3.0 Version) Example - ActionBarSherlock Example

The action bar provides several key functions:
 
Provides a dedicated space for giving your app an identity and indicating the user's location in the app.

Makes important actions prominent and accessible in a predictable way (such as Search).

Supports consistent navigation and view switching within apps (with tabs or drop-down lists).


The ActionBar APIs were first added in Android 3.0 (API level 11) but they are also available in the Support Library for compatibility with Android 2.1 (API level 7) and above.

Develop Application using ActionBar APIs in Above Android 3.0(API level 11) is Very Easy.ActionBar APIs Provides On wards Android 3.0(API level 11).

But How to if you run the same application on versions < 3.0 you won’t. Okay, It shows lot's of error messages and Application is crashed.

Then what is soultion for this issue ?

So, how do we get the ActionBar on pre-Honeycomb?using ActionBarSherlock this library does is that if you’re using your app in a device with Android 2.x, it gives you an ActionBar that is a copy of the real ActionBar (it behaves the same way), but if you’re on Android 3.0 or later, you’ll get the standard ActionBar .

The best thing is that the methods that you can use with this ActionBar are the same than with the standard one.

 
How to use ActionBarSherlock in Below Android 3.0 (API level 11) ?

Here are the steps to get the library into Eclipse:

First of all, go to Sherlock ActionBar library’s website(http://actionbarsherlock.com/) and Download the latest version (current is 4.0.0).

Then (unzip) open the file you downloaded, enter the root folder and you will see three folders: library, samples and website.

Extract the library folder into your work space folder. You can rename it if you want to something like “Sherlock-ActionBar-lib-4.0.0”.

Open Eclipse. Click File -> New -> Android Project.

Now select “Create project from existing source”, and select the folder that you copied into your work space folder.

You should also type a name such as “Sherlock-ActionBar-lib-4.0.0” :). Now press Next.
Select Android 4.1 as target SDK and press Finish.

Open the libs folder in the Project that we've created, right-click the “android-support-v4.jar” file and select Build Path -> Add to Build Path.

Now, we have the Android Library Project of the Sherlock ActionBar in our work space and in Eclipse.

Now create a  a new Android Project, targeting at least Android 4.1 SDK. We will call ActionBarSherlockExample with MainActivity Class.

Add Library(Sherlock-ActionBar-lib) project to ActionBarSherlockExample.

Steps for Adding (Sherlock-ActionBar-lib) to Current Project:

Select Project->Right click Select Properties from menu->Now Properties Dialog visible now select Android on (Left side panel)->Now you can see Is Add button to Add Library project to current project just select (Sherlock-ActionBar-lib) and add library project to current project and click on apply button.

Now Open your Activity(MainActivity.java)  which is created in current project.
 public class MainActivity extends Activity {

}


Now Change extends Activity to SherlockActivity

See below code

public class MainActivity extends SherlockActivity {

}

Final Step ( Open the AndroidManifest of your ActionBarSherlockExample project and write inside the application tag just add below attribute)

android:theme="@style/Theme.Sherlock.Light.DarkActionBar"


Now you can run your current project in below  Android 3.0 (API level 11) version the you can see ActionBar .


Android Project:

Android Activity(MainActivity.java)

package com.androidsurya.actionbarsherlock;

import com.actionbarsherlock.app.SherlockActivity;
import android.os.Bundle;

public class MainActivity extends SherlockActivity {

      @Override
      protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);
      }

}

AndroidManifest file

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.androidsurya.actionbarsherlock"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk android:minSdkVersion="7" />

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/Theme.Sherlock.Light.DarkActionBar" >
        <activity
            android:name="com.androidsurya.actionbarsherlock.MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>