Google Apps Script - Jdbc Connection Failed
I am attempting to open a connection from a Google Apps Spreadsheet without success, using example code from the Google Apps Developers reference (https://developers.google.com/app
Solution 1:
The problem is that the localhost
is used as the host. Google Apps Scripts are executed on Google servers and not on local computers. This means that the scripts cannot access the localhost
and the error is logical.
To get rid of the error is necessary to have an SQL Server accessible outside of a local network (public in internet). It can be a MySQL port forwarded behind of a firewall or a 3rd part public SQL service.
Searching in internet, I found a few public MySQL Servers, but I don not know either they are online or not (link #1, link #2, link #3)
Update 00: The JDBC Service has a bug with impossibility to resolve host name to IP. I tried to test using the following code. It makes a connection to the DB.
functiontest() {
var connection = Jdbc.getConnection("jdbc:mysql://193.62.203.76:3306/", "anonymous", "");
debugger;
}
Post a Comment for "Google Apps Script - Jdbc Connection Failed"