Pessoal já olhei mais de 1000 vezes e não entendi o pq o meu código
está gerando este erro.
Vi vários tutoriais e tudo simplifica no que eu fiz.
On 27 jan, 15:43, Fabiano - Carioca <fabianobalme...@gmail.com> wrote:
> 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
>
> ...
>
> mais »
0 comentários:
Postar um comentário