ReferenceError: jdbc is not defined

[Anthony Apollis]

Can somebody help please?

I would like to connect mysql db to a google sheet. I would like to read date from more than one table into google sheets. I am having this problem from the follow script:

var HOST = '000'

var PORT = '3311'

var USERNAME = 'Anthony_bottles'

var PASSWORD = 'aa'

var DATABASE = 'sasoftco_bottles_app'

var DB_TYPE = 'mysql'

function createConnection(){

var url =  "jdbc:mysql://<HOST>[:<PORT>]/<DATABASE>"

var  conn= jdbc.getConnection("url","user","password")

 conn.close();

}

[IRVYN CORNEJO]

Hello, 

I solved it using this alternative 
- getConnection(url, info)

var conn = Jdbc.getConnection('jdbc:mysql://yoursqlserver.example.com:3306/database_name',
                              {user: 'username', password: 'password'})

I also leave an example code, implementing this way of passing the parameters.

https://github.com/irvyncornejo/conexion-Mysql-GAS