Na sua última mensagem você postou um stack trace e uma linha de
código. Assumindo que esteja sendo irônico, o que exatamente você
esperava que alguém concluisse com base nisso?
-Bruno
Em 27 de janeiro de 2012 15:43, Fabiano - Carioca
<fabianobalmeida@gmail.com> escreveu:
> 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