Nossa irmão vc foi esclarecedor.
On 27 jan, 15:27, Bruno Albuquerque <bruno.albuquer...@gmail.com>
wrote:
> Se foi ai mesmo, então gerenciaDataBase é null, o que obviamente é
> incorreto nesse ponto.
>
> -Bruno
>
> Em 27 de janeiro de 2012 15:24, Fabiano - Carioca
> <fabianobalme...@gmail.com> escreveu:
>
>
>
>
>
>
>
> > Cara tentei fazer o que vc disse.
>
> > Deu a mesma coisa.
>
> > Os erros que o Logi me varreu são estes.
>
> > Acusam exatamente nesta linha: SQLiteDatabase db =
> > gerenciaDataBase.getWritableDatabase();
>
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): FATAL EXCEPTION: main
> > 01-27 17:21:41.555: E/AndroidRuntime(31995):
> > java.lang.NullPointerException
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > br.com.mylims.model.ConfigFTPDao.salvaFTP(ConfigFTPDao.java:39)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > br.com.mylims.controller.TelaCadastroFTPController
> > $2.onClick(TelaCadastroFTPController.java:190)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > android.view.View.performClick(View.java:2408)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at android.view.View
> > $PerformClick.run(View.java:8816)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > android.os.Handler.handleCallback(Handler.java:587)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > android.os.Handler.dispatchMessage(Handler.java:92)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > android.os.Looper.loop(Looper.java:123)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > android.app.ActivityThread.main(ActivityThread.java:4627)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > java.lang.reflect.Method.invokeNative(Native Method)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > java.lang.reflect.Method.invoke(Method.java:521)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > com.android.internal.os.ZygoteInit
> > $MethodAndArgsCaller.run(ZygoteInit.java:868)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
> > 01-27 17:21:41.555: E/AndroidRuntime(31995): at
> > dalvik.system.NativeStart.main(Native Method)
>
> > On 27 jan, 14:47, Renato Porto Puccini <renatoppucc...@gmail.com>
> > wrote:
> >> se nao eh no sql, falaria a mesma coisa que ja falaram na lista. o lugar
> >> que vc inicia o metodo.
>
> >> pode seré problema em pegar o contexto como o clebao disse.
>
> >> tenta isso.
> >> gerenciaDataBase = new GerenciaBanco(ConfigFTPDao.this);
> >> e antes de criar, verifica se seu objeto ta nulo...
>
> >> e quando vc executa, nao da nenhum pau no onCreate da classe do sqlite?
> >> ou somente aqui na activiy mesmo?
> >> abs
>
> >> ------------------------------------------
> >> Renato Porto Puccini <http://www.linkedin.com/profile/view?id=58956239&trk>
> >> renatopuccinipt.com
> >> @renatoporto <http://twitter.com/renatoporto>
> >> renatoppucc...@gmail.com
> >> ------------------------------------------
>
> >> 2012/1/27 Fabiano - Carioca <fabianobalme...@gmail.com>
>
> >> > coloquei mas deu o mesmo erro.
>
> >> > On 27 jan, 14:09, Renato Porto Puccini <renatoppucc...@gmail.com>
> >> > wrote:
> >> > > poe um ponto e virgula dentro da string e depois do parentesis..
> >> > > COLETA (" +
> >> > > "IDAUXCOLETA INTEGER PRIMARY KEY NOT NULL, " +
> >> > > "IDAUXPROCESSO INTEGER," +
> >> > > "IDCOLETA VARCHAR(250)," +
> >> > > "DTPREVISTA DATETIME," +
> >> > > "DTAGENDA DATETIME, " +
> >> > > "OBSCOLETA TEXT) ; (AQUI) ";
>
> >> > > 2012/1/27 Fabiano - Carioca <fabianobalme...@gmail.com>
>
> >> > > > Segue
>
> >> > > > package br.com.mylims.auxiliares;
>
> >> > > > import android.content.Context;
> >> > > > import android.database.sqlite.SQLiteDatabase;
> >> > > > import android.database.sqlite.SQLiteOpenHelper;
> >> > > > import android.util.Log;
>
> >> > > > public class GerenciaBanco extends SQLiteOpenHelper{
>
> >> > > > private static final int DATABASE_VERSION = 1;
>
> >> > > > private static final String DATABASE_NAME = "mylimsColeta";
>
> >> > > > private static final String CATEGORIA = "coleta";
>
> >> > > > private static final String COLETA = "CREATE TABLE IF NOT EXISTS
> >> > > > COLETA (" +
> >> > > > "IDAUXCOLETA INTEGER PRIMARY KEY NOT NULL, " +
> >> > > > "IDAUXPROCESSO INTEGER," +
> >> > > > "IDCOLETA VARCHAR(250)," +
> >> > > > "DTPREVISTA DATETIME," +
> >> > > > "DTAGENDA DATETIME, " +
> >> > > > "OBSCOLETA TEXT)";
>
> >> > > > private static final String EMPRESA = "CREATE TABLE IF NOT
> >> > EXISTS
> >> > > > EMPRESA (" +
> >> > > > "IDAUXEMPRESA INTEGER PRIMARY KEY NOT NULL," +
> >> > > > "NMFANTASIA VARCHAR(250) NOT NULL," +
> >> > > > "NMCONTATO VARCHAR(250) NOT NULL, " +
> >> > > > "SOBRENOME VARCHAR(255), " +
> >> > > > "NMAREACONTATO VARCHAR(255)," +
> >> > > > "DDD VARCHAR(250), " +
> >> > > > "FONE VARCHAR(250), " +
> >> > > > "RAMAL VARCHAR(250), " +
> >> > > > "DDDCELULAR VARCHAR(250)," +
> >> > > > "CELULAR VARCHAR(250))";
>
> >> > > > private static final String CFGFTP = "CREATE TABLE IF NOT EXISTS
> >> > > > CFGFTP (" +
> >> > > > "CDFTP INTEGER PRIMARY KEY NOT NULL, " +
> >> > > > "IPFTP VARCHAR(250) NOT NULL," +
> >> > > > "LOGINFTP VARCHAR(250) NOT NULL," +
> >> > > > "SENHAFTP VARCHAR(250) NOT NULL)";
>
> >> > > > private static final String USUARIO = "CREATE TABLEIF NOT EXISTS
> >> > > > USUARIO (" +
> >> > > > "CDUSUARIO INTEGER PRIMARY KEY NOT NULL," +
> >> > > > "NMUSUARIO VARCHAR(250) NOT NULL," +
> >> > > > "LOGIN VARCHAR(250) NOT NULL, " +
> >> > > > "SENHA VARCHAR(250) NOT NULL, " +
> >> > > > "CDFTP INTEGER NOT NULL, " +
> >> > > > "CONSTRAINT [PK_USUARIO] PRIMARY KEY
> >> > (CDUSUARIO))";
>
> >> > > > private static final String AMOSTRA ="CREATE TABLE IF NOT EXISTS
> >> > > > AMOSTRA (" +
> >> > > > "CDAMOSTRA INTEGER PRIMARY KEY NOT NULL," +
> >> > > > "IDAMOSTRA VARCHAR(250), " +
> >> > > > "IDPROCESSO VARCHAR(250), " +
> >> > > > "IDAUXPROCESSO INTEGER, " +
> >> > > > "DTPREVISTA DATETIME, " +
> >> > > > "DTCOLETA DATETIME, " +
> >> > > > "FLCOLETADA CHAR(1) NOT NULL," +
> >> > > > "DTDOWNLOAD DATETIME, " +
> >> > > > "DTUPLOAD DATETIME, " +
> >> > > > "ENDERECOCOLETA VARCHAR(250)," +
> >> > > > "OBSERVACAO VARCHAR(250)," +
> >> > > > "CDUSUARIO INTEGER NOT NULL," +
> >> > > > "IDAUXCOLETA INTEGER NULL," +
> >> > > > "IDAUXEMPRESA INTEGER NOT NULL," +
> >> > > > "CONSTRAINT [PK_AMOSTRA] PRIMARY KEY
> >> > (CDAMOSTRA)," +
> >> > > > "FOREIGN KEY (CDUSUARIO) REFERENCES
> >> > > > USUARIO(CDUSUARIO) ON UPDATE
> >> > > > CASCADE ON DELETE CASCADE," +
> >> > > > "FOREIGN KEY (IDAUXCOLETA) REFERENCES
> >> > > > COLETA(IDAUXCOLETA) ON UPDATE
> >> > > > CASCADE ON DELETE CASCADE)";
>
> >> > > > private static final String GRPINFO ="CREATE TABLE IF NOT EXISTS
> >> > > > GRPINFO(" +
> >> > > > "CDGRPINFO INTEGER PRIMARY KEY NOT NULL," +
> >> > > > "NMGRPINFO VARCHAR(250))";
>
> >> > > > private static final String INFO ="CREATE TABLE IF NOT EXISTS
> >> > INFO("
> >> > > > +
> >> > > > "CDINFO INTEGER PRIMARY KEY NOT NULL," +
> >> > > > "NMINFO VARCHAR(250) NOT NULL, " +
> >> > > > "CDTIPODADO INTTEGER NOT NULL))";
>
> >> > > > private static final String INFOSAMOSTRA = "CREATE TABLE IF NOT
> >> > > > EXISTS INFOSAMOSTRA(" +
> >> > > > "CDAMOSTRA INTEGER KEY NOT NULL, " +
> >> > > > "CDINFO INTEGER NOT NULL, " +
> >> > > > "CDGRPINFO INTEGER NOT NULL," +
> >> > > > "VLINFO VARCHAR(250), " +
> >> > > > "FLOBRIGATORIO CHAR(1) NOT NULL, " +
> >> > > > "FOREIGN KEY (CDINFO) REFERENCES INFO(CDINFO) ON
> >> > > > DELETE CASCADE ON
> >> > > > UPDATE CASCADE, " +
> >> > > > "FOREIGN KEY (CDGRPINFO) REFERENCES
> >> > > > GRPINFO(CDGRPINFO) ON DELETE
> >> > > > CASCADE ON UPDATE CASCADE, " +
> >> > > > "FOREIGN KEY (CDAMOSTRA) REFERENCES
> >> > > > AMOSTRA(CDAMOSTRA) ON DELETE
> >> > > > CASCADE ON UPDATE CASCADE)";
>
> >> > > > private static final String OPCOESINFO = "CREATE TABLE IF NOT
> >> > EXISTS
> >> > > > OPCOESINFO (" +
> >> > > > "CDINFO INTEGER PRIMARY KEY NOT NULL, " +
> >> > > >
>
> ...
>
> mais »
0 comentários:
Postar um comentário