I am trying to pull data from a MySql database into a Google Doc via Apps Script. When I try connect to the database I get the error below because Jdbc is undefined.

Cannot read property 'getConnection' of undefined 

Below is the code I am using

<div>
  <span id="import" style="background-color: red">Import</span>
</div>
<script src="//ajax.googleapis/ajax/libs/jquery/1.9.1/jquery.min.js">
</script>
<script>
  /**
   * On document load, assign click handlers to each button and try to load the
   * user's origin and destination language preferences if previously set.
   */
  $(function() {
    $('#import').click(import_test); 
  });


// Replace the variables in this block with real values.
var address = 'ip';
var user = 'username';
var userPwd = 'password';
var db = 'db';

var dbUrl = 'jdbc:mysql://' + address + '/' + db;

// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
  var conn = Jdbc.getConnection(dbUrl, user, userPwd);
}

function import_test() {
console.log('ping');
readFromTable();
console.log('ping2');
}

</script>

The documentation is only for Google Cloud SQL and I can't find anything in the mysql documentation on how to do this in javascript.

Any ideas on how to connect to MySql via Apps Script?

Thanks.

I am trying to pull data from a MySql database into a Google Doc via Apps Script. When I try connect to the database I get the error below because Jdbc is undefined.

Cannot read property 'getConnection' of undefined 

Below is the code I am using

<div>
  <span id="import" style="background-color: red">Import</span>
</div>
<script src="//ajax.googleapis./ajax/libs/jquery/1.9.1/jquery.min.js">
</script>
<script>
  /**
   * On document load, assign click handlers to each button and try to load the
   * user's origin and destination language preferences if previously set.
   */
  $(function() {
    $('#import').click(import_test); 
  });


// Replace the variables in this block with real values.
var address = 'ip';
var user = 'username';
var userPwd = 'password';
var db = 'db';

var dbUrl = 'jdbc:mysql://' + address + '/' + db;

// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
  var conn = Jdbc.getConnection(dbUrl, user, userPwd);
}

function import_test() {
console.log('ping');
readFromTable();
console.log('ping2');
}

</script>

The documentation is only for Google Cloud SQL and I can't find anything in the mysql documentation on how to do this in javascript.

Any ideas on how to connect to MySql via Apps Script?

Thanks.

• javascript
• mysql
• jdbc
• google-apps-script

1 Answer 1

As with most frameworks, all database calls should be done from the server, not the browser.

Put it on the server and call a server function from the client js.