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
<fabianobalmeida@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, " +
>> > > > "CDOPCAO INTEGER NOT NULL, " +
>> > > > "NMOPCAO VARCHAR(250), " +
>> > > > "DESCOPCAO VARCHAR(250))";
>>
>> > > > public GerenciaBanco(Context context) {
>>
>> > > > super(context, DATABASE_NAME, null, DATABASE_VERSION);
>>
>> > > > }
>>
>> > > > @Override
>> > > > public void onCreate(SQLiteDatabase db) {
>>
>> > > > try {
>>
>> > > > db.execSQL(CFGFTP);
>> > > > //db.execSQL(USUARIO);
>> > > > //db.execSQL(EMPRESA);
>> > > > //db.execSQL(GRPINFO);
>> > > > //db.execSQL(INFO);
>> > > > //db.execSQL(OPCOESINFO);
>> > > > //db.execSQL(COLETA);
>> > > > //db.execSQL(AMOSTRA);
>> > > > //db.execSQL(INFOSAMOSTRA);
>>
>> > > > } catch (Exception e) {
>>
>> > > > Log.i(CATEGORIA, "ERRADO: " + e);
>> > > > }
>>
>> > > > }
>>
>> > > > @Override
>> > > > public void onUpgrade(SQLiteDatabase db, int oldVersion, int
>> > > > newVersion) {
>>
>> > > > }
>>
>> > > > }
>>
>> > > > On 27 jan, 13:23, Clebão - EcoCentauro <cleba...@gmail.com> wrote:
>> > > > > Cola para mim a classe GerenciaBanco por favor.
>>
>> > > > > Em 27 de janeiro de 2012 13:16, Fabiano - Carioca <
>> > > > fabianobalme...@gmail.com
>>
>> > > > > > escreveu:
>> > > > > > Corrigindo pergunta: Clebão você acha que o erro está na criação
>> > dos
>> > > > > > campos?
>>
>> > > > > > On 27 jan, 13:15, Fabiano - Carioca <fabianobalme...@gmail.com>
>> > wrote:
>> > > > > > > Clebão você acha que o erro está na dos campos?
>>
>> > > > > > > On 27 jan, 13:10, Fabiano - Carioca <fabianobalme...@gmail.com>
>> > > > wrote:
>>
>> > > > > > > > não foi irmão
>>
>> > > > > > > > On 27 jan, 12:52, Clebão - EcoCentauro <cleba...@gmail.com>
>> > wrote:
>>
>> > > > > > > > > tenta alterar a criação da PRIMARY KEY
>>
>> > > > > > > > > campa INTEGER PRIMARY KEY,
>>
>> > > > > > > > > Em 27 de janeiro de 2012 11:54, Renato Porto Puccini <
>> > > > > > > > > renatoppucc...@gmail.com> escreveu:
>>
>> > > > > > > > > > Maravilha!!!
>>
>> > > > > > > > > > legal que meu posto ajudou. E que mundo pequeno mesmo!!!
>> > > > > > > > > > abraços e sucesso ae Fabiano!!
>>
>> > > > > > > > > > ------------------------------------------
>> > > > > > > > > > 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>
>>
>> > > > > > > > > >> alterei e deu o mesmo resultado cara.
>>
>> > > > > > > > > >> On 27 jan, 11:35, Renato Porto Puccini <
>> > > > renatoppucc...@gmail.com>
>> > > > > > > > > >> wrote:
>> > > > > > > > > >> > cara, pelo que eu vi, é um erro no sql.
>> > > > > > > > > >> > você colocou o ponto e virgula dentro do seu create.
>>
>> > > > > > > > > >> > CREATE TABLE IF NOT EXISTS GRPINFO
>> > > > > > > > > >> > (" +
>> > > > > > > > > >> > "CDGRPINFO INTEGER NOT NULL," +
>> > > > > > > > > >> > "NMGRPINFO
>>
>> ...
>>
>> mais »
0 comentários:
Postar um comentário