I receive the following error when attempting to InsertMaps:
This is my SQL statement:
I have also tried the following, but receive the same error:
My MySQL/Java Connector:
B4X:
(MySQLSyntaxErrorException) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[push_users] ([id], [last_access]) VALUES ('358726061334668', 1488201837725)' at line 1
B4X:
DBUtils.InsertMaps(PushDB, "push_users", Array As Object(CreateMap("id": Id, "last_access": DateTime.Now)))
I have also tried the following, but receive the same error:
B4X:
Dim ListOfMaps As List
ListOfMaps.Initialize
ListOfMaps.Add(CreateMap("id":Id, "last_access": DateTime.Now))
DBUtils.InsertMaps(PushDB, "push_users", ListOfMaps)
My MySQL/Java Connector:
B4X:
#AdditionalJar: mysql-connector-java-5.1.40-bin