- Forum-Beiträge: 13
12.07.2012, 13:42:54 via Website
12.07.2012 13:42:54 via Website
habe das problem das sich die app beim aufrufen der datenbank aufhängt also in der zeile ourDatabase = ourHelper.getWritableDatabase(); in der methode public aktien_db open() {
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.SQLException;
7import android.database.sqlite.SQLiteDatabase;
8import android.database.sqlite.SQLiteOpenHelper;
9
10public class aktien_db {
11
12
13 private static final String DATABASE_NAME = "BApp";
14 private static final String DATABASE_TABLE = "aktien_tabelle";
15 private static final int DATABASE_VERSION = 1;
16
17 public static final String KEY_ISIN = "ISIN";
18 public static final String KEY_BEZEICHNUNG = "Bezeichnung";
19
20 private dbHelper ourHelper;
21 private final Context ourContext;
22 private SQLiteDatabase ourDatabase;
23
24 private static class dbHelper extends SQLiteOpenHelper{
25
26 public dbHelper(Context context) {
27 super(context, DATABASE_NAME, null, DATABASE_VERSION);
28 // TODO Auto-generated constructor stub
29 }
30
31 @Override
32 public void onCreate(SQLiteDatabase db) {
33 // TODO Auto-generated method stub
34 db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" +
35 KEY_ISIN + " TEXT NOT NULL, " +
36 KEY_BEZEICHNUNG + " TEXT NOT NULL );"
37 );
38 }
39
40 @Override
41 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
42 // TODO Auto-generated method stub
43 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
44 onCreate(db);
45
46 }
47
48
49 }
50
51 public aktien_db(Context c){
52 ourContext = c;
53
54 }
55
56 public aktien_db open() {
57
58 ourHelper = new dbHelper(ourContext);
59
60 ourDatabase = ourHelper.getWritableDatabase();
61
62 return this;
63
64 }
65
66 public void close(){
67 ourHelper.close();
68 }
69
70 public long createEntry(String iSIN, String name) {
71 // TODO Auto-generated method stub
72 ContentValues cv = new ContentValues();
73 cv.put(KEY_ISIN, iSIN);
74 cv.put(KEY_BEZEICHNUNG, name);
75 return ourDatabase.insert(DATABASE_TABLE, null, cv);
76
77 }
78
79 public aktien_stack getData() {
80 // TODO Auto-generated method stub
81 aktien_stack anfang = null;
82 aktien_stack a = null;
83 String[] columns = new String[] {KEY_ISIN, KEY_BEZEICHNUNG};
84 Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);
85
86
87 int iISIN = c.getColumnIndex(KEY_ISIN);
88 int iBezeichnung = c.getColumnIndex(KEY_BEZEICHNUNG);
89
90 for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){
91
92
93
94 if(anfang==null){
95 anfang = new aktien_stack();
96 anfang.Set_aktien_stack(c.getString(iISIN), c.getString(iBezeichnung));
97 anfang.next=null;
98
99 }
100 else{
101 a = new aktien_stack();
102 a.next = anfang;
103 a.Set_aktien_stack(c.getString(iISIN), c.getString(iBezeichnung));
104 anfang = a;
105
106 }
107
108 }
109 return anfang;
110
111 }
112
113
114}
207-12 07:33:53.468: I/dalvikvm-heap(2344): Grow heap (frag case) to 9.772MB for 960012-byte allocation
307-12 07:33:53.528: I/dalvikvm(2344): threadid=3: reacting to signal 3
407-12 07:33:53.688: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
507-12 07:33:53.698: D/dalvikvm(2344): GC_CONCURRENT freed <1K, 3% free 9950K/10247K, paused 5ms+4ms
607-12 07:33:53.988: I/dalvikvm(2344): threadid=3: reacting to signal 3
707-12 07:33:53.988: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
807-12 07:33:54.488: I/dalvikvm(2344): threadid=3: reacting to signal 3
907-12 07:33:54.488: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
1007-12 07:33:58.048: D/gralloc_goldfish(2344): Emulator without GPU emulation detected.
1107-12 07:33:58.108: I/dalvikvm(2344): threadid=3: reacting to signal 3
1207-12 07:33:58.138: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
1307-12 07:33:58.888: I/dalvikvm(2344): threadid=3: reacting to signal 3
1407-12 07:33:58.898: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
1507-12 07:34:00.098: I/System.out(2344): megaTest1
1607-12 07:34:00.098: I/System.out(2344): Testebene2 7
1707-12 07:34:00.098: I/System.out(2344): Testebene2 8
1807-12 07:34:00.108: D/AndroidRuntime(2344): Shutting down VM
1907-12 07:34:00.108: W/dalvikvm(2344): threadid=1: thread exiting with uncaught exception (group=0xb4058180)
2007-12 07:34:00.148: E/AndroidRuntime(2344): FATAL EXCEPTION: main
2107-12 07:34:00.148: E/AndroidRuntime(2344): java.lang.RuntimeException: Unable to start activity ComponentInfo{de.GFD.bapp/de.GFD.bapp.menue}: java.lang.NullPointerException
2207-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956)
2307-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
2407-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread.access$600(ActivityThread.java:123)
2507-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
2607-12 07:34:00.148: E/AndroidRuntime(2344): at android.os.Handler.dispatchMessage(Handler.java:99)
2707-12 07:34:00.148: E/AndroidRuntime(2344): at android.os.Looper.loop(Looper.java:137)
2807-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread.main(ActivityThread.java:4424)
2907-12 07:34:00.148: E/AndroidRuntime(2344): at java.lang.reflect.Method.invokeNative(Native Method)
3007-12 07:34:00.148: E/AndroidRuntime(2344): at java.lang.reflect.Method.invoke(Method.java:511)
3107-12 07:34:00.148: E/AndroidRuntime(2344): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
3207-12 07:34:00.148: E/AndroidRuntime(2344): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
3307-12 07:34:00.148: E/AndroidRuntime(2344): at dalvik.system.NativeStart.main(Native Method)
3407-12 07:34:00.148: E/AndroidRuntime(2344): Caused by: java.lang.NullPointerException
3507-12 07:34:00.148: E/AndroidRuntime(2344): at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
3607-12 07:34:00.148: E/AndroidRuntime(2344): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
3707-12 07:34:00.148: E/AndroidRuntime(2344): at de.GFD.bapp.aktien_db.open(aktien_db.java:60)
3807-12 07:34:00.148: E/AndroidRuntime(2344): at de.GFD.bapp.MySQL_get_data_online.setData(MySQL_get_data_online.java:32)
3907-12 07:34:00.148: E/AndroidRuntime(2344): at de.GFD.bapp.menue.onCreate(menue.java:43)
4007-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.Activity.performCreate(Activity.java:4465)
4107-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
4207-12 07:34:00.148: E/AndroidRuntime(2344): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
4307-12 07:34:00.148: E/AndroidRuntime(2344): ... 11 more
4407-12 07:34:00.378: I/dalvikvm(2344): threadid=3: reacting to signal 3
4507-12 07:34:00.378: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
4607-12 07:34:00.789: I/dalvikvm(2344): threadid=3: reacting to signal 3
4707-12 07:34:00.798: I/dalvikvm(2344): Wrote stack traces to '/data/anr/traces.txt'
Vielen Dank für die Hilfe ;)
lg Mathias
— geändert am 12.07.2012, 15:04:11
Empfohlener redaktioneller Inhalt
Mit Deiner Zustimmung wird hier ein externer Inhalt geladen.
Mit Klick auf den oben stehenden Button erklärst Du Dich damit einverstanden, dass Dir externe Inhalte angezeigt werden dürfen. Dabei können personenbezogene Daten an Drittanbieter übermittelt werden. Mehr Infos dazu findest Du in unserer Datenschutzerklärung.