# Pastebin lPYpyAde
    # Prep the connection
    Java::com.mysql.jdbc.Driver
    userurl = "jdbc:mysql://db-read.onestoptoronto.com/mmky"
    connSelect = java.sql.DriverManager.get_connection(userurl, "user", "VERYSECRET")
    stmtSelect = connSelect.prepare_statement(%q{select l.id, l.clone_loc, l.clone_allowed from `locations` l, `engines` e
                                                  where e.`name` = ?
                                                  and e.`location_id` = l.id})
    loc_id = 0
    hostname = scope['facts']['hostname']
    rSlocid = stmtSelect.execute_query(hostname)