Android Question JDBC MySQL

gbzrope · Apr 3, 2019

Is there any way to validate that an INSERT query was succesfull on a remote MySQL database?
Other than to then run another query to retrieve the recordset created?

e.g.

B4X:

sSQL="INSERT INTO statements_collected(ID, Client, DeviceID) VALUES(" & Crsr.getint("ID") & "," & Main.iUserID & ",'" & MainOptions.sDeviceID & "')"
                    mysql.ExecNonQuery(sSQL)

Erel · Apr 3, 2019

1. It is a mistake to use the non-async methods with JdbcSQL.
2. Check the Success parameter. If it is true then the command was executed successfully.

gbzrope · Apr 3, 2019

Erel said:
1. It is a mistake to use the non-async methods with JdbcSQL.
2. Check the Success parameter. If it is true then the command was executed successfully.

I tried ExecQueryAsync but that expects a recordset, this is just an Insert query, and ExecQueryAsync does not work.

DonManfred · Apr 3, 2019

https://www.b4x.com/android/help/jdbcsql.html#jdbcsql_execnonquerybatch

B4X:

For i = 1 To 1000
  sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000)))
Next
Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log("NonQuery: " & Success)

gbzrope · Apr 3, 2019

DonManfred said:

https://www.b4x.com/android/help/jdbcsql.html#jdbcsql_execnonquerybatch

B4X:

For i = 1 To 1000
  sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000)))
Next
Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log("NonQuery: " & Success)

Yes, I have that file, the problem is/was that the queries are quite large and I have already built them up with values.
I have just tried:
sql.AddNonQueryToBatch(sSQL, NULL)
Which seems to work.

DonManfred · Apr 3, 2019

ExecNonQueryBatch is async... All ok

Erel · Apr 4, 2019

Tutorial about async SQL methods: [B4X] SQL with Wait For

Android Question JDBC MySQL

gbzrope

Member

Erel

B4X founder

gbzrope

Member

DonManfred

Expert

gbzrope

Member

DonManfred

Expert

Erel

B4X founder

Similar Threads

Android Question JDBC MySQL

gbzrope

Member

Erel

B4X founder

gbzrope

Member

DonManfred

Expert

gbzrope

Member

DonManfred

Expert

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency