[androidbrasil-dev] Erro - SQLITE

16:21 |

Pessoal,

Podem me ajudar com um erro que está acontecendo ao criar uma aplicação com o SQLITE no Android Studio?

Por acaso, é até um exercício antigo que tinha pego de um curso que havia feito.

Segue o LOG:

05-27 19:19:54.339 1938-1938/com.example.fragment_exemplo.app D/dalvikvm﹕ GC_FOR_ALLOC freed 42K, 4% free 2826K/2932K, paused 30ms, total 30ms

05-27 19:19:54.339 1938-1938/com.example.fragment_exemplo.app I/dalvikvm-heap﹕ Grow heap (frag case) to 3.426MB for 635808-byte allocation

05-27 19:19:54.359 1938-1945/com.example.fragment_exemplo.app D/dalvikvm﹕ GC_FOR_ALLOC freed <1K, 4% free 3447K/3556K, paused 12ms, total 12ms

05-27 19:19:54.419 1938-1938/com.example.fragment_exemplo.app E/SQLiteLog﹕ (1) near ")": syntax error

05-27 19:19:54.419 1938-1938/com.example.fragment_exemplo.app D/AndroidRuntime﹕ Shutting down VM

05-27 19:19:54.419 1938-1938/com.example.fragment_exemplo.app W/dalvikvm﹕ threadid=1: thread exiting with uncaught exception (group=0xb2cafb20)

05-27 19:19:54.459 1938-1938/com.example.fragment_exemplo.app E/AndroidRuntime﹕ FATAL EXCEPTION: main

Process: com.example.fragment_exemplo.app, PID: 1938

java.lang.RuntimeException: Unable to resume activity {com.example.fragment_exemplo.app/com.example.fragment_exemplo.app.ListaAlunos}: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE CadastroCaelum ( id INTEGER PRIMARY KEY, nome TEXT UNIQUE NOT NULL, telefone TEXT, endereco TEXT, site TEXT, nota REAL, );

at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2788)

at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2817)

at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2250)

at android.app.ActivityThread.access$800(ActivityThread.java:135)

at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1196)

at android.os.Handler.dispatchMessage(Handler.java:102)

at android.os.Looper.loop(Looper.java:136)

at android.app.ActivityThread.main(ActivityThread.java:5017)

at java.lang.reflect.Method.invokeNative(Native Method)

at java.lang.reflect.Method.invoke(Method.java:515)

at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)

at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)

at dalvik.system.NativeStart.main(Native Method)

Caused by: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE CadastroCaelum ( id INTEGER PRIMARY KEY, nome TEXT UNIQUE NOT NULL, telefone TEXT, endereco TEXT, site TEXT, nota REAL, );

at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)

at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)

at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)

at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)

at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)

at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1672)

at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1603)

at com.example.fragment_exemplo.app.AlunoDAO.onCreate(AlunoDAO.java:37)

at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)

at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)

at com.example.fragment_exemplo.app.AlunoDAO.recuperaLista(AlunoDAO.java:49)

at com.example.fragment_exemplo.app.ListaAlunos.carregaLista(ListaAlunos.java:121)

at com.example.fragment_exemplo.app.ListaAlunos.onResume(ListaAlunos.java:67)

at android.app.Instrumentation.callActivityOnResume(Instrumentation.java:1192)

at android.app.Activity.performResume(Activity.java:5310)

at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2778)