Android Question java.sql.SQLException: Could not retrieve transaction read-only status from server

[WangShiQin]

sql = "INSERT INTO findtable (station_num, employeer_name, result) VALUES (?,?,?)"
MysqlJdbc.ExecNonQuery2(sql,Array As Object(station_num, employeer_name, result))

under Debug , run ok. but under Release, Error occurred, java.sql.SQLException: Could not retrieve transaction read-only status from server, why? thanks


AdditionalJar: mysql-connector-java-5.1.49-bin
jdbcSQL 1.5

 

[aeric]

Is the server running on new version of MySQL?
Please post your jdbcUrl and the whole error message.

Check this post:

JdbcSQL - Insert error

Hi all, I used sample code to connect JdbcSQL from the link JdbcSQL forum link The ExecQueryAsync works find. But when I use ExecNonQuery it returns and error. Code and error message as follows. Sub ListAnimals As ResumableSub Wait For (Connect) Complete (Success As Boolean) If...

www.b4x.com