Override google apps script 32768 characters limit on Exception: Argument too large: sql

Viewed 108

I used Google apps script GAS to upload my data to mysql server. If the statement is over 32768 characters, the function returns error. I think it is because of the Google cache issue for 16 bit in length. How to increase the limit? Here is my code:

mysql_statement = "INSERT INTO table (abc_id) VALUES ( xxx "
Logger.log(mysql_statement.length) // 32769
conn.createStatement().execute(mysql_statement)

Returns : Info Exception: Argument too large: sql

0 Answers
Related