B4J Question jrdc2 server: How to log sql string

OliverA said:

Note: Untested
You could add the following code to both ExecuteQuery2 and ExecuteBatch2 of the RDCHandler class module of the jRDC2 source code:

B4X:

#If Debug
   Dim sb As StringBuilder
   sb.Initialize
   sb.Append($"Query: ${Main.rdcConnector1.GetCommand(cmd.Name)}"$)
   Dim first As Boolean = True
   For Each parameter As Object In cmd.Parameters
       If first Then
           sb.Append($" Parameter(s): ${parameter}"$)
           first = False
       Else
           sb.Append($", ${parameter}"$)
       End If
   Next
   Log(sb.ToString)
#End If

In ExecuteQuery2, place it after

B4X:

Dim cmd As DBCommand = m.Get("command")

In ExecuteBatch2, place it in the loop that execute the commands, after

B4X:

For Each cmd As DBCommand In commands

Click to expand...

yfleury said:

You are the king

Click to expand...