Google Apps Script Query To Mariadb

We recently moved our data to a new server - however the new one is using MariaDB. We do a lot of queries and calculations in Google Apps Script for spreadsheet. Since the server s

Solution 1:

I believe the way you used setMaxRows is the problem.

If you change the way you set the limit it will work.

// Call SO DATA //      stmt.setMaxRows(10000);var start = newDate();

  var rs = stmt.executeQuery("select * from sales_flat_invoice limit 10000");

This should fix your problem. This definetly comes from the missmatch of version of your MariaDB and the version of jdbc connector.

Cheers