Android Question Java.lang.illegalStateException

[Rajesh Gupta]

Hii All

I am saving data in Sqlite Database, with one field of Data type MEMO, which contains around 7 MB of JSON data..

There is no problem in insertion, and when i am extracting data with SELECT query then this exception occurs.

Anyone please help...

 

[Erel]

Please post the full error message from the logs.

 

[Rajesh Gupta]

Please post the full error message from the logs.

java.lang.illegalstateException: Couldn't read row 0, col 1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it.

This is the exception which I am getting.

Is the size of the field issue?

 

[mcqueccu]

java.lang.illegalstateException: Couldn't read row 0, col 1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it.

This is the exception which I am getting.

Is the size of the field issue?

copy the full error code, and also the code which you are using to retrieve the data.

 

[Rajesh Gupta]

copy the full error code, and also the code which you are using to retrieve the data.

Try
      
    SQL1.Initialize(File.DirInternal, "Masters.db", True)

    Dim q As String = "SELECT Distinct * FROM tblLedgers WHERE PARTYNAME = '" & ddlaccname.Text & "' AND BDEPID = '" & GlobalConst.BDEPID &"' And CurFY = '" & GlobalConst.CurFY & "'"
    tblLedgers = SQL1.ExecQuery(q)

    If tblLedgers.RowCount > 0 Then
        tblLedgers.Position= 0
      
        Dim JsonFromDb As String = tblLedgers.GetString("PARTYJSON")
        Dim OpeningBal As Double = tblLedgers.GetDouble("OPBAL")
      
        ConvertJSONToDataTableinOFfflineMode(JsonFromDb, OpeningBal,True)
    Else
        Msgbox("No Data Found.", "Access Denied")
        pbaccledger.Visible = False
        ddlaccname.Enabled=True
        txtFrom.Enabled=True
        txtTo.Enabled=True
        btnaccledger.Enabled=True
        imgFrom.Enabled=True
        imgTo.Enabled=True
        End If
    Catch
        Log(LastException)
        Msgbox(LastException, "Exception Occured")
    End Try

I am getting the above exception in msg box when i am running the app.

 

[Erel]

This code is wrong and will fail if the user enters a ' in one of the fields.

 Dim q As String = "SELECT Distinct * FROM tblLedgers WHERE PARTYNAME = '" & ddlaccname.Text & "' AND BDEPID = '" & GlobalConst.BDEPID &"' And CurFY = '" & GlobalConst.CurFY & "'"
    tblLedgers = SQL1.ExecQuery(q)

Watch the SQL tutorial: https://www.b4x.com/etp.html

Comment the Try / Catch keywords and see the full error message.

 

[Rajesh Gupta]

This code is wrong and will fail if the user enters a ' in one of the fields.

 Dim q As String = "SELECT Distinct * FROM tblLedgers WHERE PARTYNAME = '" & ddlaccname.Text & "' AND BDEPID = '" & GlobalConst.BDEPID &"' And CurFY = '" & GlobalConst.CurFY & "'"
    tblLedgers = SQL1.ExecQuery(q)

Watch the SQL tutorial: https://www.b4x.com/etp.html

Comment the Try / Catch keywords and see the full error message.

When i comment try catch, then it shows beginning of Main------
I think the problem is with the size of cursor limit, it is exceeding 1000 data sets or it is of 4 MB approx

This can be the reason?

 

[Erel]

You should post the logs.

This can be the reason?

Yes. SQL fields are limited to 1mb or 2mb depending on the Android version.

 

[Rajesh Gupta]

You should post the logs.

Yes. SQL fields are limited to 1mb or 2mb depending on the Android version.

I saw that the cursor size is limited to 1MB only, so can we use any other class, instead of Cursor?

 

[Erel]

The limit is not related to any specific class. It is a limit in Android SQLite engine.