Databases
StackOverflow2013
Postsdbo
PORuntime Exception on creating Database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORuntime Exception on creating Database
    primarykey
    data
    text
    <p>I am developing a database app to enter the notes into it .But when i run this application on emulator it stops immediately saying <code>Unfortunately!Notepad2 has stopped working</code>.Please help me to work it correctly. There are two files. One MainActivity.java:</p> <pre><code>package com.example.notepad2; import android.os.Bundle; import android.app.Activity; import android.view.Menu; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.EditText; public class MainActivity extends Activity implements OnClickListener { EditText title,body; Button btn; NotepadDb notepad; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); title=(EditText)findViewById(R.id.title); body=(EditText)findViewById(R.id.body); btn=(Button)findViewById(R.id.btn); btn.setOnClickListener(this); notepad=new NotepadDb(this); notepad=notepad.open(); } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); return true; } @Override public void onClick(View v) { // TODO Auto-generated method stub notepad.insert(title.getText().toString(), body.getText().toString()); notepad.close(); } } </code></pre> <p>And the Other is NotepadDb.java</p> <pre><code>package com.example.notepad2; import android.app.Activity; import android.content.Context; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; public class NotepadDb extends Activity { private static final String DATABASE_NAME="Notepad"; private static final String TABLE_NAME="note"; private final int DATABASE_VERSION=1; private static final String KEY_TITLE="title"; private static final String KEY_BODY="body"; private static final String ID="_id"; private static final String Query="create table note(_id integer auto_increment primary key,title text not null,body text not null);"; DatabaseHelper dbHelper; SQLiteDatabase mydb; private Context cntxt; public class DatabaseHelper extends SQLiteOpenHelper{ public DatabaseHelper(Context context) { super(context, DATABASE_NAME,null, DATABASE_VERSION); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL(Query); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub db.execSQL("drop table note"); onCreate(db); } } public NotepadDb(Context context){ cntxt=context; } public NotepadDb open() throws SQLException{ dbHelper=new DatabaseHelper(cntxt); mydb=dbHelper.getReadableDatabase(); return this; } public void insert(String title,String body){ mydb.execSQL("insert into note values(null,"+title+","+body+");"); } public void close(){ dbHelper.close(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEduardo Savrin
    1. USEduardo Savrin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COExamine LogCat and see what your Java stack trace is telling you.
      singulars
      1. PORuntime Exception on creating Database
      1. USCommonsWare
    2. COpost the whole stacktrace..
      singulars
      1. PORuntime Exception on creating Database
      1. USbakriOnFire
    3. COPlease place error log to identify actual error in your code
      singulars
      1. PORuntime Exception on creating Database
      1. USNarayan Soni
 

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