Ciao ragazzi sto creando un database SQLite interno all'applicazione, ho creato la pagina che conterrā tutte le specifiche del database e le query varie, provando a fare un insert noto che non mi da un errore "No such table..." e noto anche che non trova la tabella in quanto non fa partire proprio la query di create table nel metodo onCreate. Le ho provate tutte ci deve essere qualcosa che manca o che ho sbagliato mi date una mano? grazie
Questo č il file del database:
codice:
package com.itc.zappapp.Internal_db;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class database_zappapp {
//Tabella orari delle aule
//g_a_lunedi
//g_a_martedi
//g_a_mercoledi
//g_a_giovedi
//g_a_venerdi
//g_a_sabato
//Tabelle orari delle classi
//g_o_lunedi
//g_o_martedi
//g_o_mercoledi
//g_o_giovedi
//g_o_venerdi
//g_o_sabato
//Tabelle orari dei professori
//g_p_lunedi
//g_p_martedi
//g_p_mercoledi
//g_p_giovedi
//g_p_venerdi
//g_p_sabato
//Tabelle varie
//g_ricevimenti
//g_version
//g_calendario
//s_studenti
//s_voti
//COMUNI A PI� DI UNO
public static String KEY_ID = "_id";
public static final String KEY_1 = "prima";
public static final String KEY_2 = "seconda";
public static final String KEY_3 = "terza";
public static final String KEY_4 = "quarta";
public static final String KEY_5 = "quinta";
public static final String KEY_6 = "sesta";
public static final String KEY_MATERIA = "materia";
public static final String KEY_CLASSE = "classe";
public static final String KEY_PROF = "prof";
//SPECIFICI PER AULA
public static final String KEY_AULA = "aula";
//SPECIFICI PER RICEVIMENTI
public static final String KEY_GIORNO = "giorno";
public static final String KEY_H_INIZIO = "h_inizio";
public static final String KEY_H_FINE = "h_fine";
public static final String KEY_EMAIL = "email";
//SPECIFICI PER VERSION
public static final String KEY_V_NO = "v_no";
//SPECIFICI PER CALENDARIO
public static final String KEY_DATA_INIZIO = "data_inizio";
public static final String KEY_DATA_FINE = "data_fine";
public static final String KEY_EVENTO = "evento";
//SPECIFICI PER STUDENTI
public static final String KEY_NOME_UTENTE = "nome_utente";
public static final String KEY_NOME = "nome";
public static final String KEY_COGNOME = "cognome";
public static final String KEY_PASSWORD = "password";
public static final String KEY_TIME_LOGIN = "time_login";
//SPECIFICO PER VOTI
public static final String KEY_VOTO = "voto";
public static final String KEY_DATA = "data";
public static final String KEY_TIPO = "tipo";
public static final String KEY_ID_STUDENTE = "id_studente";
//NOME DEL DATABASE
private static final String DATABASE_NAME = "Internal_db_zappapp";
//TABELLE
private static final String DATABASE_TABLE_G_A_LUNEDI = "g_a_lunedi";
private static final String DATABASE_TABLE_G_A_MARTEDI = "g_a_martedi";
private static final String DATABASE_TABLE_G_A_MERCOLEDI = "g_a_mercoledi";
private static final String DATABASE_TABLE_G_A_GIOVEDI = "g_a_giovedi";
private static final String DATABASE_TABLE_G_A_VENERDI = "g_a_venerdi";
private static final String DATABASE_TABLE_G_A_SABATO = "g_a_sabato";
private static final String DATABASE_TABLE_G_O_LUNEDI = "g_o_lunedi";
private static final String DATABASE_TABLE_G_O_MARTEDI = "g_o_martedi";
private static final String DATABASE_TABLE_G_O_MERCOLEDI = "g_o_mercoledi";
private static final String DATABASE_TABLE_G_O_GIOVEDI = "g_o_giovedi";
private static final String DATABASE_TABLE_G_O_VENERDI = "g_o_venerdi";
private static final String DATABASE_TABLE_G_O_SABATO = "g_o_sabato";
private static final String DATABASE_TABLE_G_P_LUNEDI = "g_p_lunedi";
private static final String DATABASE_TABLE_G_P_MARTEDI = "g_p_martedi";
private static final String DATABASE_TABLE_G_P_MERCOLEDI = "g_p_mercoledi";
private static final String DATABASE_TABLE_G_P_GIOVEDI = "g_p_giovedi";
private static final String DATABASE_TABLE_G_P_VENERDI = "g_p_venerdi";
private static final String DATABASE_TABLE_G_P_SABATO = "g_p_sabato";
private static final String DATABASE_TABLE_RICEVIMENTI = "g_ricevimenti";
private static final String DATABASE_TABLE_VERSION = "g_version";
private static final String DATABASE_TABLE_CALENDARIO = "g_calendario";
private static final String DATABASE_TABLE_STUDENTI = "s_studenti";
private static final String DATABASE_TABLE_VOTI = "s_voti";
//versione iniziale
private static final int DATABASE_VERSION = 1;
private DbHelper ourHelper;
private final Context ourContext;
private SQLiteDatabase ourDatabase;
private static class DbHelper extends SQLiteOpenHelper {
public DbHelper(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
//COPIARE PER TUTTE LE TABELLE DE DB
db.execSQL("CREATE TABLE " + DATABASE_TABLE_G_A_LUNEDI + " (" +
KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_AULA + " TEXT NOT NULL, " +
KEY_1 + " TEXT NULL DEFAULT NULL, " +
KEY_2 + " TEXT NULL DEFAULT NULL, " +
KEY_3 + " TEXT NULL DEFAULT NULL, " +
KEY_4 + " TEXT NULL DEFAULT NULL, " +
KEY_5 + " TEXT NULL DEFAULT NULL, " +
KEY_6 + " TEXT NULL DEFAULT NULL);" +
//tante altre tabelle.....
);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
public database_zappapp(Context c){
ourContext = c;
}
public database_zappapp open() throws SQLException{
ourHelper = new DbHelper(ourContext);
ourDatabase = ourHelper.getWritableDatabase();
return this;
}
public void close(){
ourHelper.close();
}
//INIZIO METODI PERSONALIZZATI
public long createEntry(Double s) {
// TODO Auto-generated method stub
ContentValues cv = new ContentValues();
cv.put(KEY_V_NO, s);
return ourDatabase.insert(DATABASE_TABLE_VERSION, null, cv);
}
}
Questo č l'errore:
codice:
11-04 15:47:42.847: I/SqliteDatabaseCpp(27451): sqlite returned: error code = 1, msg = no such table: g_version
11-04 15:47:42.847: E/SQLiteDatabase(27451): Error during inserting
11-04 15:47:42.847: E/SQLiteDatabase(27451): android.database.sqlite.SQLiteException: no such table: g_version: , while compiling: INSERT INTO g_version(v_no) VALUES (?)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:112)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1838)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1711)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at com.itc.zappapp.Internal_db.database_zappapp.createEntry(database_zappapp.java:383)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at com.itc.zappapp.Activity_Body.Activity_Menu.onCreate(Activity_Menu.java:31)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.Activity.performCreate(Activity.java:4465)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1053)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1934)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1995)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.ActivityThread.access$600(ActivityThread.java:128)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1161)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.os.Handler.dispatchMessage(Handler.java:99)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.os.Looper.loop(Looper.java:137)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at android.app.ActivityThread.main(ActivityThread.java:4514)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at java.lang.reflect.Method.invokeNative(Native Method)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at java.lang.reflect.Method.invoke(Method.java:511)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:790)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
11-04 15:47:42.847: E/SQLiteDatabase(27451): at dalvik.system.NativeStart.main(Native Method)
11-04 15:47:42.972: D/OpenGLRenderer(27451): Flushing caches (mode 0)