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
  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)
  2. 0

    Android: How to get the last id inserted ORMLite?

    Stack Overflow | 2 years ago | Luiz Negrini
    java.sql.SQLException: Could not perform raw query for SELECT MAX (id) FROM configuracao 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22) 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at com.j256.ormlite.dao.BaseDaoImpl.queryRaw(BaseDaoImpl.java:552) 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at com.universo91.towersrock.DAO.ConfiguracaoDao.buscaIdUltimaAtualizacao(ConfiguracaoDao.java:78) 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at com.universo91.towersrock.BL.PSTowersRock.doInBackground(PSTowersRock.java:72) 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at com.universo91.towersrock.BL.PSTowersRock.doInBackground(PSTowersRock.java:39) 02-23 22:36:25.011 1446-1491/com.universo91.towersrock W/System.err﹕ at android.os.AsyncTask$2.call(AsyncTask.java:288)
  3. 0

    SQLException when using orderBy() in ORMLite

    Stack Overflow | 1 year ago | KJEjava48
    java.sql.SQLException: Problems executing Android query: SELECT * FROM `accounts` WHERE ((`parent_id` = 1 AND `active` = 1 ) AND `id` NOT IN (5 ,43 ) ) ORDER BY CASE WHEN name=Others THEN 1 ELSE 0 END,name 07-22 12:06:29.750: W/System.err(581): at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22) 07-22 12:06:29.750: W/System.err(581): at com.j256.ormlite.android.AndroidCompiledStatement.getCursor(AndroidCompiledStatement.java:184) 07-22 12:06:29.760: W/System.err(581): at com.j256.ormlite.android.AndroidCompiledStatement.runQuery(AndroidCompiledStatement.java:65) 07-22 12:06:29.771: W/System.err(581): at com.j256.ormlite.stmt.SelectIterator.<init>(SelectIterator.java:55) 07-22 12:06:29.780: W/System.err(581): at com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:247) 07-22 12:06:29.790: W/System.err(581): at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:196) 07-22 12:06:29.800: W/System.err(581): at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:265) 07-22 12:06:29.800: W/System.err(581): at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:361) 07-22 12:06:29.820: W/System.err(581): at com.j256.ormlite.stmt.Where.query(Where.java:503) 07-22 12:06:29.820: W/System.err(581): at com.fort.sample.db.SaveMoneyController.getListData(SaveMoneyController.java:183) 07-22 12:06:29.830: W/System.err(581): at com.fort.sample.view.MainActivity.loadExpense(MainActivity.java:338) 07-22 12:06:29.840: W/System.err(581): at com.fort.sample.view.MainActivity.listClicked(MainActivity.java:248) 07-22 12:06:29.860: W/System.err(581): at com.fort.sample.view.MainActivity.access$10(MainActivity.java:233) 07-22 12:06:29.860: W/System.err(581): at com.fort.sample.view.MainActivity$8.onItemClick(MainActivity.java:216) 07-22 12:06:29.860: W/System.err(581): at android.widget.AdapterView.performItemClick(AdapterView.java:284) 07-22 12:06:29.899: W/System.err(581): at android.widget.ListView.performItemClick(ListView.java:3513) 07-22 12:06:29.899: W/System.err(581): at android.widget.AbsListView$PerformClick.run(AbsListView.java:1812) 07-22 12:06:29.921: W/System.err(581): at android.os.Handler.handleCallback(Handler.java:587) 07-22 12:06:29.930: W/System.err(581): at android.os.Handler.dispatchMessage(Handler.java:92)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Use Ormlite for JOIN 2 tables

    Stack Overflow | 2 years ago | Roberto
    java.sql.SQLException: Problems executing Android query: SELECT pedido.* FROM pedido INNER JOIN cliente ON pedido.idcliente = cliente.idCliente INNER JOIN cliente ON pedido.idcliente = cliente.idCliente WHERE cliente.nomeRazao LIKE 'ANA' AND (cliente.nomeRazao LIKE 'ANA' ) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.android.AndroidCompiledStatement.getCursor(AndroidCompiledStatement.java:184) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.android.AndroidCompiledStatement.runQuery(AndroidCompiledStatement.java:65) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.stmt.SelectIterator.&lt;init&gt;(SelectIterator.java:55) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:247) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:196) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:265) 07-15 19:55:53.980 1603-1603/br.com.forcavenda W/System.err﹕ at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:361)
  6. 0

    recordset is not returning any value

    Stack Overflow | 3 years ago | C.Ronaldo
    java.sql.SQLException: No current row in the ResultSet. 09-11 13:39:38.967: W/System.err(1625): at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:270) 09-11 13:39:38.967: W/System.err(1625): at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:641) 09-11 13:39:38.976: W/System.err(1625): at com.example.messagesql.gaSQLConnect.CheckUser(gaSQLConnect.java:69) 09-11 13:39:38.976: W/System.err(1625): at com.example.messagesql.Login$1.onClick(Login.java:38) 09-11 13:39:38.976: W/System.err(1625): at android.view.View.performClick(View.java:2485) 09-11 13:39:38.976: W/System.err(1625): at android.view.View$PerformClick.run(View.java:9080)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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