Creating Database and Tables

[Raihan Jamal]

Can anybody explain me where android store sqLite database....
I have created database and tables on the click event of a Button.... so I just need to verify whether the database and table have been created or not....


I am trying to create database and table on the click event of
button... when I am clicking on the button for creating database and
table... it is saying that process com.example.hw3 has stopped
unexpectedly...please try again... Below is the code... what wrong I
am doing....??
Somebody Please help me....

    

package com.example.hw3;


import java.util.Locale;

import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class HW3 extends Activity {
private Button b1;
//private HW3DbAdapter db1;
private EditText text;

/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
text = (EditText) findViewById(R.id.EditText01);
initControls();
}

protected void initControls()
{
b1 = (Button)findViewById(R.id.CreateDB);

b1.setOnClickListener(new Button.OnClickListener()
{ public void onClick (View v){ DoWork(); }});
}

protected void DoWork()
{

SQLiteDatabase db;

// db1 = new HW3DbAdapter(this);
text.setText("Button 1 was clicked");
// db1.open();
//fillData();

db = openOrCreateDatabase(
"db_hw3.db"
, SQLiteDatabase.CREATE_IF_NECESSARY
, null
);
db.setVersion(1);
db.setLocale(Locale.getDefault());
db.setLockingEnabled(true);
final String CREATE_TABLE_COUNTRIES =
"CREATE TABLE db_entry ("
+ "id INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "mb_text TEXT NOT NULL,"
+ "ph_location TEXT);";

db.execSQL(CREATE_TABLE_COUNTRIES);


}



}

[Monu Tripathi]

. so I just need to verify whether the database and table have been created or not....

Database is created inside your application and you can browse to it using adb shell. It must be there in /data/data/your_app_name folder

As regards exception you are getting it would help if you post exception logs from logcat.

[Raihan Jamal]

Thanks for replying back...
Actually I am new to Android and SQLite..... so if you can give the command and where these commands I have to type then I can check whether the tables have been created or not...
And also give some example of logcat and how to use it.... so that I can post the exception over here....

[Monu Tripathi]

Raihan Jamal wrote:Thanks for replying back...
Actually I am new to Android and SQLite..... so if you can give the command and where these commands I have to type then I can check whether the tables have been created or not...
And also give some example of logcat and how to use it.... so that I can post the exception over here....

How to see the database file and logs:
If you are using Eclipse:
switch to DDMS perspective - > File Browser -> Browse to data/data/your_package_name folder. There you would see your database.
Similarly to see the logs, switch to Logcat view.

Else wise:

From the SDK_installation/tools folder, type adb shell. This will give you the shell prompt.
cd to data/data/your_package_name/

to get the logs type adb logcat from the SDK_installation/tools context.

Also, read Android FAQs(see my signature for a link) some of the very basic questions are listed there.

[Raihan Jamal]

Thanks for replying...
I am having one more problem now...
I am using this below java file to create a database and table on the click event of Create DB Button( till here it is working fine) and then below this Create DB button, there is one more button named Send Button... and on the click event of Send Button I am opening another activity which contains a edit text and a button called Insert(this is also working fine for me) and on the click event of this Insert Button... I have to insert the value that we are typing into edit text box into the table that we have created previously.... but I am not able to figure it out why it is not inserting into table that we have created previously... what wrong I am doing please let me know.... Below are the codes....
-----------------
This Code contains Create DB Button and Send Button and click event also that are creating tables and database

  
package com.example.hw3;


import android.app.Activity;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class HW3 extends Activity {
	private Button b1;
	private Button b2;
	@SuppressWarnings("unused")
	private A1 test;
	private EditText text;
	
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        text = (EditText) findViewById(R.id.EditText01);
        initControls();
    }
    
    protected void initControls()
    {
    b1 = (Button)findViewById(R.id.CreateDB);
    b2 = (Button)findViewById(R.id.Button02);
    
    
    
    

    b1.setOnClickListener(new Button.OnClickListener()
    { public void onClick (View v){ DoWork(); }});
    
    b2.setOnClickListener(new Button.OnClickListener()
    { public void onClick (View v){ 
    Intent myIntent = new Intent(HW3.this, A1.class);
	// HW3.this.startActivity(myIntent);
      startActivity(myIntent);  
}});
    
    
    }

   
    protected void DoWork()
    {
    	
       //	SQLiteDatabase db=null;
    	
    //	db1 = new HW3DbAdapter(this);
    	text.setText("Button 1 was clicked");
      // db1.open();
        //fillData();
       
    	SQLiteDatabase myDB= null;
    	  String TableName = "db_entry";

    	  /* Create a Database. */
    	  try {
    	   myDB = this.openOrCreateDatabase("db_hw3", MODE_PRIVATE, null);
    	   myDB.execSQL("DROP TABLE IF EXISTS db_entry" );
    	   /* Create a Table in the Database. */
    	   myDB.execSQL("CREATE TABLE IF NOT EXISTS "
    	     + TableName
    	     + " (id INTEGER PRIMARY KEY AUTOINCREMENT, mb_text TEXT NOT NULL,ph_location TEXT);");

    	  }
    	  catch(Exception e) {
    	   Log.e("Error", "Error", e);
    	  } finally {
    	   if (myDB != null)
    	    myDB.close();
    	  }
      
       
    }
    
    
    
}  

------------------

This is the Code for an Activity that contain edit text and Insert Button....I think something wrong I am doing in the try block of this code..... Please help

  package com.example.hw3;

import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;


public class A1 extends Activity {
	private Button b3;
	private EditText text1;
	private EditText text3;
	
	public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main1);
        
        initControls1();
    }
	
	 protected void initControls1()
	    {
	    b3 = (Button)findViewById(R.id.SendButton);
	    text1 = (EditText) findViewById(R.id.et1);  
	    text3 = (EditText) findViewById(R.id.EditText04);
	    b3.setOnClickListener(new Button.OnClickListener()
	    { public void onClick (View v){ DoWork1(); }});
	    
	     
	    
	    }
	 protected void DoWork1()
	    {
		 SQLiteDatabase myDB= null;
		// SQLiteDatabase myDB;
   	  //String TableName = "db_entry";
   	String str= text1.getText().toString();
   	text3.setText(str);
   	  //String Data="";
   	 try {
  	  myDB = this.openOrCreateDatabase("db_hw3", MODE_PRIVATE, null);

  	    /* Insert data to a Table*/
  	   myDB.execSQL("INSERT INTO db_entry"
  		 + " (mb_text, ph_location)"
  	     + " VALUES (str,pp );");
     	 }
  	  	  catch(Exception e) {
    	   Log.e("Error", "Error", e);
    	  } 
   	  
   	  
   	  
   	  
	    }
	
}
  

[Monu Tripathi]

  myDB.execSQL("INSERT INTO db_entry"  
         + " (mb_text, ph_location)"  
          + " VALUES (str,pp );");  
         }  

You are not passing actual values stored in your variables; should you be using str,pp inline in your query?

[Raihan Jamal]

Hey Monu,
Thanks a lot for replying.... I have figured it out the above problem... Can you just tell me what is wrong with this below code...
I am trying to get the location of phone as latitude and longitude by using location manager but everytime I do this.... Force Close message appears... I have also added permission in android.manifest file...
what wrong I am doing here...?? DO reply..
Thanks..

  

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.location.Location;
import android.location.LocationManager;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;


public class A1 extends Activity {
	private Button b3;
	private EditText text1;
	private EditText text3;
	private LocationManager lm;
	private Location loc1;

	public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main1);
         
        initControls1();
    }
	
	 protected void initControls1()
	    {
	    b3 = (Button)findViewById(R.id.SendButton);
	    text1 = (EditText) findViewById(R.id.et1);  
	    text3 = (EditText) findViewById(R.id.EditText04);
	    b3.setOnClickListener(new Button.OnClickListener()
	    { public void onClick (View v){ DoWork1(); }});
	    
	     
	    
	    }
	 protected void DoWork1()
	    {
		 SQLiteDatabase myDB= null;
		// SQLiteDatabase myDB;
   	  //String TableName = "db_entry";
   	String str= text1.getText().toString();
   	String latLongString;
   	lm = (LocationManager) getSystemService(Context.LOCATION_SERVICE);

    // connect to the GPS location service
    Location loc = lm.getLastKnownLocation("gps");

    // fill in the TextViews
    double lat = loc.getLatitude();
    double lng = loc.getLongitude();
    latLongString = "Lat:" + lat + "\nLong:" + lng;

    // ask the Location Manager to send us location updates
   	  //String Data="";
   	 try {
  	   myDB = this.openOrCreateDatabase("db_hw3", MODE_PRIVATE, null);
  	 text3.setText(Double.toString(loc.getLatitude()));
  	    /* Insert data to a Table*/
  	
   	ContentValues cv=new ContentValues(2);
  	cv.put("mb_text", text1.getText().toString());
  	cv.put("ph_location", 2);
  	myDB.insert("db_entry", null, cv);
  	 
  	}  
  	  	  catch(Exception e) {
    	   Log.e("Error", "Error", e);
    	  } 
   	  
   	  
   	  
   	  
	    }
	
}

 

[Ulf Dittmer]

If an app is forcibly closed then there should be a message in the logcat output.
My guess would be that "loc" is null because there is no known last location.

[Raihan Jamal]

Thanks for replying... so what should I do in this case... Should I change latitude and longitude value in the emulator control or something else..please guide..

[Ulf Dittmer]

See "Providing Mock Location Data" in http://developer.android.com/guide/topics/location/index.html

Next time please mention right away if you're using the emulator; that's crucial information.

[Raihan Jamal]

Hey... SOrry for that....
I am not able to use geo.... I don't know why... and I was usuing by this way also.... (http://www.devx.com/wireless/Article/39239/1763?supportItem=6) and I also click on send button to send the latitude and longitude value but still I got force close message...

this is my logcat output.. and this is the error I am having when I try to extract the latitude and longitude value
04-21 17:22:19.550: ERROR/AndroidRuntime(258): java.lang.NullPointerException


Do reply.. what to do?

04-21 17:22:10.190: INFO/ActivityManager(56): Starting activity: Intent { cmp=com.example.hw3/.A1 }
04-21 17:22:10.450: WARN/Resources(258): Converting to string: TypedValue{t=0x12/d=0x0 a=2 r=0x7f050003}
04-21 17:22:10.880: INFO/ActivityManager(56): Displayed activity com.example.hw3/.A1: 585 ms (total 585 ms)
04-21 17:22:13.450: WARN/KeyCharacterMap(258): No keyboard for id 0
04-21 17:22:13.459: WARN/KeyCharacterMap(258): Using default keymap: /system/usr/keychars/qwerty.kcm.bin
04-21 17:22:19.440: DEBUG/LocationManager(258): Constructor: service = android.location.ILocationManager$Stub$Proxy@43d195b8
04-21 17:22:19.479: DEBUG/AndroidRuntime(258): Shutting down VM
04-21 17:22:19.499: WARN/dalvikvm(258): threadid=3: thread exiting with uncaught exception (group=0x4001b188)
04-21 17:22:19.509: ERROR/AndroidRuntime(258): Uncaught handler: thread main exiting due to uncaught exception
04-21 17:22:19.550: ERROR/AndroidRuntime(258): java.lang.NullPointerException
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.example.hw3.A1.DoWork1(A1.java:54)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.example.hw3.A1$1.onClick(A1.java:36)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.View.performClick(View.java:2364)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.View.onTouchEvent(View.java:4179)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.widget.TextView.onTouchEvent(TextView.java:6534)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.View.dispatchTouchEvent(View.java:3709)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:883)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:883)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:883)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:883)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.android.internal.policy.impl.PhoneWindow$DecorView.superDispatchTouchEvent(PhoneWindow.java:1659)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.android.internal.policy.impl.PhoneWindow.superDispatchTouchEvent(PhoneWindow.java:1107)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.app.Activity.dispatchTouchEvent(Activity.java:2061)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.android.internal.policy.impl.PhoneWindow$DecorView.dispatchTouchEvent(PhoneWindow.java:1643)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.view.ViewRoot.handleMessage(ViewRoot.java:1691)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.os.Handler.dispatchMessage(Handler.java:99)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.os.Looper.loop(Looper.java:123)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at android.app.ActivityThread.main(ActivityThread.java:4338)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at java.lang.reflect.Method.invokeNative(Native Method)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at java.lang.reflect.Method.invoke(Method.java:521)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
04-21 17:22:19.550: ERROR/AndroidRuntime(258):     at dalvik.system.NativeStart.main(Native Method)
04-21 17:22:19.640: INFO/Process(56): Sending signal. PID: 258 SIG: 3
04-21 17:22:19.650: INFO/dalvikvm(258): threadid=7: reacting to signal 3
04-21 17:22:19.779: INFO/dalvikvm(258): Wrote stack trace to '/data/anr/traces.txt'
04-21 17:22:21.570: INFO/Process(258): Sending signal. PID: 258 SIG: 9
04-21 17:22:21.650: INFO/ActivityManager(56): Process com.example.hw3 (pid 258) has died.
04-21 17:22:21.710: INFO/WindowManager(56): WIN DEATH: Window{43da0710 com.example.hw3/com.example.hw3.HW3 paused=false}
04-21 17:22:21.719: INFO/WindowManager(56): WIN DEATH: Window{43ca3548 com.example.hw3/com.example.hw3.A1 paused=false}
04-21 17:22:21.909: INFO/ActivityManager(56): Start proc com.example.hw3 for activity com.example.hw3/.HW3: pid=299 uid=10025 gids={}
04-21 17:22:22.399: DEBUG/ddm-heap(299): Got feature list request
04-21 17:22:22.630: WARN/UsageStats(56): Something wrong here, didn't expect com.example.hw3 to be resumed
04-21 17:22:23.300: WARN/InputManagerService(56): Got RemoteException sending setActive(false) notification to pid 258 uid 10025
04-21 17:22:23.559: INFO/ActivityManager(56): Displayed activity com.example.hw3/.HW3: 1771 ms (total 1771 ms)
  

[Ulf Dittmer]

Which object is null - is it "loc"? If so, have you tried supplying mock data like the link I posted suggested? Also, have you tried running this code on an actual device that has a GPS that has locked in on a position? Have you tried using the network location provider?

[Raihan Jamal]

I think so Loc is pointing to be null that's why it giving me error on double lat = loc.getLatitude(); by logcat ouput...
Actually My actual device is not working properly... so that's why I am working on emulator ryt now...
yeah I have provided the latitude and longitude value like this (http://www.devx.com/wireless/Article/39239/1763?supportItem=6) and also I have click on send button to send the latitude and longitude values...
Have you tried using the network location provider?
what does this means??
Meaning using cellid and locationid of phone??
Do reply... What wrong I am doing...?
I have tried all the things that I know as I am new to android and Sqlite....

Thanks in advance...

[Ulf Dittmer]

This code lists all providers (most likely two: gps and network). Even the emulator should have the network provider. If you provide a LocationListener then your app will be notified once a location is established. If you search the net you'll find articles and examples of this.

LocationManager locmgr = (LocationManager) getSystemService(Context.LOCATION_SERVICE);

List<String> providers = locmgr.getAllProviders();

for (String prov : providers) {
	Log.d("Test", "provider '"+prov+"'");
	//locmgr.requestLocationUpdates(prov, 0, 0, new MyLocationListener());

	Location loc = locmgr.getLastKnownLocation(prov);
	if (loc != null)
		log("cached: latitude="+loc.getLatitude()+", longitude="+loc.getLongitude());
}

[Raihan Jamal]

Thanks for your quick reply... Now I see some entry in to table ... but in latitude filed I am getting zero always
What I am trying now just for checking that latitude value I am getting is right or not.... so I am just inserting this latitude value in to the table... which has a datatype
like this (ph_location REAL) so now when I see in to the table, this latitude field has 0 entry always irrespective of changing the location...

I am changing the location by this way...
C:\>telnet localhost 5554
Android Console: type 'help' for a list of commands
OK
geo fix -82.411629 28.054553
OK

this is the code.... it is like that we have to use location manager in the onCreate method.... as i am using location manager on the click event of button...

Do reply
thanks...

 


import java.util.List;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.location.Location;
import android.location.LocationManager;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;


public class A1 extends Activity {
	private Button b3;
	private EditText text1;
	private EditText text3;
	private LocationManager lm;
	 Location loc;
	 double lat;
	public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main1);
         
        initControls1();
    }
	
	 protected void initControls1()
	    {
	    b3 = (Button)findViewById(R.id.SendButton);
	    text1 = (EditText) findViewById(R.id.et1);  
	    text3 = (EditText) findViewById(R.id.EditText04);
	    b3.setOnClickListener(new Button.OnClickListener()
	    { public void onClick (View v){ DoWork1(); }});
	    
	     
	    
	    }
	 protected void DoWork1()
	    {
		 SQLiteDatabase myDB= null;
		// SQLiteDatabase myDB;
   	  //String TableName = "db_entry";
   	String str= text1.getText().toString();
    LocationManager locmgr = (LocationManager) getSystemService(Context.LOCATION_SERVICE);  
      
    List<String> providers = locmgr.getAllProviders();  
       
     for (String prov : providers) {  
         Log.d("Test", "provider '"+prov+"'");  
         //locmgr.requestLocationUpdates(prov, 0, 0, new MyLocationListener());  
       
         Location loc = locmgr.getLastKnownLocation(prov);  
        if (loc != null)  
        {
        	lat = loc.getLatitude();
            double lng = loc.getLongitude();
        }
    }  
    // ask the Location Manager to send us location updates
   	  //String Data="";
   	 try {
  	   myDB = this.openOrCreateDatabase("db_hw3", MODE_PRIVATE, null);
  	 text3.setText(str);
  	    /* Insert data to a Table*/
  	
   	ContentValues cv=new ContentValues(2);
  	cv.put("mb_text", text1.getText().toString());
  	cv.put("ph_location", lat);
  	myDB.insert("db_entry", null, cv);
  	  /* myDB.execSQL("INSERT INTO db_entry"
  		 + " (mb_text, ph_location)"
  	     + " VALUES ('str',pp );");
     	*/ 
  	}  
  	  	  catch(Exception e) {
    	   Log.e("Error", "Error", e);
    	  } 
   	  
   	  
   	  
   	  
	    }
	
}
  

[Ulf Dittmer]

it is like that we have to use location manager in the onCreate method

It doesn't work like that. If the device/emulator hasn't fixed a position yet then you'll get a null value. I think there are ways of running code at device startup time - if that registers a LocationListener and stores the results it gets, then your app code may have a location available upon startup.

Easier to implement is probably to register a LocationListener in the onCreate method of your app, and then to wait until the app is notified about a location. Assuming that the GPS hasn't just been turned on that shouldn't take long.

[Raihan Jamal]

Thanks a lot for your help... I have solved that problem.... I have learnt a lot by our conversations....
Really Thanks....
I have inserted latitude and longitude values into the database... now I have to find the nearest location from the current location....
I am confuse how should I proceed... Just like there is a concept of Oracle Spatial Database and in it we can use SDO_GEOMETRY for this thing .... so In android and sqlite how we can solve this problem...
Do reply...