Android Question mysql lib dosnt work in release mode

[pezhooman]

hi im useing mysql lib : https://www.b4x.com/android/forum/threads/mysql-library-with-jdbc.22291/#content
my app works good in debug mode but in release mode dos not.
what sould i do.?

#Region  Project Attributes

Sub finger_LongClick
    Dim r As Int        ' return affected rows count
    Dim pdatest As String = pdate.getDate(DateTime.GetYear(DateTime.Now),DateTime.GetMonth(DateTime.Now),DateTime.GetDayOfMonth(DateTime.Now),"/")
    Try
        Dim hh As Int=DateTime.GetHour(DateTime.Now)
        Dim mm As Int=DateTime.GetMinute(DateTime.Now)
        Dim ss As Int=DateTime.GetSecond(DateTime.Now)+5
        Dim ptime As String =setdatesep(pdatest) & NumberFormat(hh,2,0) & NumberFormat(mm,2,0) & NumberFormat(ss,2,0)
        Dim codid As Long=Label1.Text
        Log("INSERT INTO devicelogs VALUES (null," & codid & ",'" & ptime & "',0,546840484,4865,0)")
        r=a.ExecuteNonQuery("INSERT INTO devicelogs VALUES (null," & codid & ",'" & ptime & "',0,546840484,4865,0)")
     
        'r=a.ExecuteNonQuery("INSERT INTO devicelogs (UserId,logdatetime,Funkkey,DeviceId,EventId,flag) VALUES (" & codid & ",'" & ptime & "',0,546840484,4865,1)")
        Log( " result is " & r)
        If r=-1 Then
            Label1.TextColor=Colors.Red
            Label1.Text="errore .."
            Sleep(1000)
         
            Label1.TextColor=Colors.ARGB(255,0,255,7)
            Label1.Text=""
        Else
            Label1.TextColor=Colors.ARGB(255,0,255,7)
            Label1.Text="success  "
            Dim Job As HttpJob
            Sleep(1000)
'
        End If
     
    Catch
        Log(LastException)
    End Try
End Sub

Private Sub setdatesep(s As String) As String
    Dim year As String=s.SubString2(0,s.IndexOf("/"))
    Dim mounth As String=s.SubString2(s.IndexOf("/")+1,s.LastIndexOf("/"))
    Dim dayr As String=s.SubString(s.LastIndexOf("/")+1)
    If mounth.Length=1 Then mounth="0"&mounth
    If dayr.Length=1 Then dayr="0" & dayr
    Return year &   mounth &  dayr
End Sub
Private Sub setdatesepfordevice(s As String) As String
    Dim year As String=s.SubString2(0,s.IndexOf("/"))
    Dim mounth As String=s.SubString2(s.IndexOf("/")+1,s.LastIndexOf("/"))
    Dim dayr As String=s.SubString(s.LastIndexOf("/")+1)
    If mounth.Length=1 Then mounth="0"&mounth
    If dayr.Length=1 Then dayr="0" & dayr
    Return year & "/" &   mounth &  "/" &  dayr
End Sub

 

[pezhooman]

here is my debug mode log :

INSERT INTO devicelogs VALUES (null,93151363,'13970630085260',0,546840484,4865,0)
result is 1
true
(ArrayList) [{deviceTime=08:52, DeviceDate=1397/06/30, PersonCode=93151363, FamilyAndName=پژومان کيسمي-مصطفي, FishDetailes=درخواست خارج از محدوده زماني است.}]
Rows #0
col1=93151363
col2=پژومان کيسمي-مصطفي
col3=08:52
col4=1397/06/30
col4=درخواست خارج از محدوده زماني است.
** Activity (main) Pause, UserClosed = true **



and now my release mode log:
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
INSERT INTO devicelogs VALUES (null,93151363,'13970630090131',0,546840484,4865,0)
result is -1

 

[pezhooman]

i got it mysql lib is working only in sdk 8 and my app was in sdk 26

 

[OliverA]

You may want to look into the JdbcSQL library. Then you would not have to deal with an over 6 year old library.
https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/

 

[Erel]

what sould i do.?

Check the error message in the logs.

Correct solution was given above. You need to switch to JdbcSQL and use its async features.

Incorrect solution: https://www.b4x.com/android/forum/threads/44760/#content