java.sql.SQLException: Unknown field 'corflag' from the Android sqlite cursor, not in:[id, codcli, nomcli, endcli, numcli, baicli, cepcli, cidcli, cnpcli, cplcli, sigufs, te1cli, te2cli, codtab, codtra, codpgt, codcob, latitude, longitude, dataatualizacaoposicaogps] 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.android.AndroidDatabaseResults.findColumn(AndroidDatabaseResults.java:128) 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:797) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:270) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:161) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:200)

ormlite | carlosmarian | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    How to identify whether a column in the table

    ormlite | 3 years ago | carlosmarian
    java.sql.SQLException: Unknown field 'corflag' from the Android sqlite cursor, not in:[id, codcli, nomcli, endcli, numcli, baicli, cepcli, cidcli, cnpcli, cplcli, sigufs, te1cli, te2cli, codtab, codtra, codpgt, codcob, latitude, longitude, dataatualizacaoposicaogps] 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.android.AndroidDatabaseResults.findColumn(AndroidDatabaseResults.java:128) 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:797) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:270) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:161) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:200)

    Root Cause Analysis

    1. java.sql.SQLException

      Unknown field 'corflag' from the Android sqlite cursor, not in:[id, codcli, nomcli, endcli, numcli, baicli, cepcli, cidcli, cnpcli, cplcli, sigufs, te1cli, te2cli, codtab, codtra, codpgt, codcob, latitude, longitude, dataatualizacaoposicaogps] 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.android.AndroidDatabaseResults.findColumn(AndroidDatabaseResults.java:128) 02-12 13:23:35.374: W/System.err(904): at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:797) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:270) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:161) 02-12 13:23:35.414: W/System.err(904): at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:200)

      at com.j256.ormlite.dao.BaseDaoImpl.query()
    2. ORMLite Core
      BaseDaoImpl.query
      1. com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:263)
      1 frame
    3. br.com.giro
      ListaClienteFragment$CarregaRegistrosAsync.doInBackground
      1. br.com.giro.pedido.mobile.persistence.BaseDAO.findAll(BaseDAO.java:168)
      2. br.com.giro.pedido.mobile.controller.ClienteController.listaTodas(ClienteController.java:32)
      3. br.com.giro.pedido.mobile.view.ListaClienteFragment$CarregaRegistrosAsync.doInBackground(ListaClienteFragment.java:211)
      4. br.com.giro.pedido.mobile.view.ListaClienteFragment$CarregaRegistrosAsync.doInBackground(ListaClienteFragment.java:1)
      4 frames