Android Question Remote Desktop Connect - troubleshooting

[mrumball]

Hi,

I have successfully set up the RDC server (connecting to MS SQL) and client - all worked fine at first, using the supplied RDC client program (modified to suit). It then stopped working and now get server error each time i run a query.

Server side is running - as i get 'Connection Successful' from a web browser. When the query is run i get the following error:-

"java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float" followed by server error message each time the query runs.

Server side config sql statements are as below:

sql.select_order=SELECT * from QryPickNPrint WHERE Order_number = ? AND Line_number = ?

MS SQL
Order_number is varchar
Line_number is integer


Modified RDC client program is below:

#Region  Project Attributes
    #ApplicationLabel: B4A Example
    #VersionCode: 1
    #VersionName:
    'SupportedOrientations possible values: unspecified, landscape or portrait.
    #SupportedOrientations: unspecified
    #CanInstallToExternalStorage: False
#End Region

#Region  Activity Attributes
    #FullScreen: False
    #IncludeTitle: True
#End Region

Sub Process_Globals
    Dim reqManager As DBRequestManager
End Sub

Sub Globals

End Sub

Sub Activity_Create(FirstTime As Boolean)
    If FirstTime Then
        reqManager.Initialize(Me, "http://132.225.220.6:17178")
    End If
End Sub

Sub Activity_Click
    GetAnimal("573518",5)
End Sub

Sub GetAnimal(order As String,Line As Int )
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "select_order"
    cmd.Parameters = Array As Object(order,Line)
    reqManager.ExecuteQuery(cmd, 0, Null)
End Sub

Sub JobDone(Job As HttpJob)
    If Job.Success = False Then
        Log("Error: " & Job.ErrorMessage)
    Else
        If Job.JobName = "DBRequest" Then
            Dim result As DBResult = reqManager.HandleJob(Job)
            reqManager.PrintTable(result)
        End If
    End If
    Job.Release
End Sub

Sub Activity_Resume

End Sub

Sub Activity_Pause (UserClosed As Boolean)

End Sub

Any ideas as to what has happened?? or how to troubleshoot
Thanks
Martin

 

[Erel]

Are you testing it with the rapid debugger?

If yes then you should apply this fix: http://www.b4x.com/android/forum/th...crash-dbrequestmanager-rdc.33526/#post-196355

I will update the tutorial about it.

 

[mrumball]

Thanks Erel
Thats it.. thanks for your help, I switched to rapid and it stopped working, I will install the fix.

also might help someone installing the server side on a windows machine - the server will not start if you have a '-' in the directory name e.g..
c:\android-RDC

it cannot find the required files - took me a while to suss this one out but as soon as the dash was removed it worked fine