Ok,
config.properties file: Sql sentence:
#Table: b003: Actualizamos la fecha de actualización de un proyecto en el server segùn su CUIP
#Input: last_login, cuip (where cuip is text)
#Return: True/False
sql.last_update_cuip_b003=UPDATE b003 SET last_login = CAST(? As TIMESTAMP) WHERE cuip = ?;
B4A code:
'Set date_update as TIMESTAMP format
Dim date_update As String = fCom.str_date(version_local, True, 1)
'Starter.arg: It was define as public variant in module server Starter: Public arg As Object
Starter.arg = Array(date_update, Starter.CUIP)
'exe_sql_nonQuery: It was define as sub in the current Activity
exe_sql_nonQuery("last_update_cuip_b003")
wait for exe_sql_nonQuery_complete
LogColor("last_update_cuip_b003: " & Starter.nonQuery_success, Colors.Green)
If Starter.nonQuery_success = False Then
Dim mensaje_error As String = "last_update_cuip_b003: db local" & " - [Error]: " & LastException
End If
Sub exe_sql_nonQuery (Name As String)
Try
LogColor("------Wait for exe_sql_nonQuery_complete...", Colors.Cyan)
Dim cmd As DBCommand = fCom.CreateCommand(Name, Starter.arg)
Dim j As HttpJob = fCom.CreateRequest.ExecuteBatch(Array(cmd), Null)
Wait For(j) JobDone(j As HttpJob)
If j.Success Then
LogColor("Inserted successfully!",Colors.Cyan)
Starter.nonQuery_success = True
Else
Starter.nonQuery_success = False
End If
j.Release
Starter.nonQuery_many = Starter.nonQuery_many + 1
Log("nonQuery_many: " & Starter.nonQuery_many)
Catch
Starter.nonQuery_success = False
Log(LastException)
End Try
LogColor("------ exe_sql_nonQuery_complete: DONE", Colors.Cyan)
CallSubDelayed(Me, "exe_sql_nonQuery_complete")
End Sub
Full error message (only when I run in debug mode, not in release mode):
ResponseError. Reason: org.postgresql.util.PSQLException: No se ha especificado un valor para el parametro 2., Response: <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 2.</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /rdc. Reason:
<pre> org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 2.</pre></p><hr><a href="
http://eclipse.org/jetty">Powered by Jetty:// 9.4.z-SNAPSHOT</a><hr/>
</body>
</html>