JDBC Driver for Zoho Analytics CloudSQL

Copiedimport java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class ZohoReportsCloudSQL
{
    public static void main(String args[])
    {
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try
        {
            Class.forName("com.zoho.cloudsql.jdbc.ZohoReportsDriver");
            Properties conProps = new Properties();
            
            // ZohoAnalytics admin emailaddress
            conProps.put("user","david.s@zoho.com");

            // ZohoAnalytics OAuth authentication parameters
            conProps.put("CLIENT_ID","");
            conProps.put("CLIENT_SECRET","");
            conProps.put("REFRESH_TOKEN","");
            
            // Uncomment this incase you need proxy settings
            /*
            // Proxy host name to connect the internet
            conProps.put("PROXYSERVER","proxy_hostname");
            // Proxy port to connect the internet
            conProps.put("PROXYPORT","proxy_port");
            // Proxy user name to connect the internet
            conProps.put("PROXYUSERNAME","proxy_username");
            // Proxy password to connect the internet
            conProps.put("PROXYPASSWORD","proxy_password");
            */
            /* Important Note: Connection is single threaded in Zoho Analytics */
            // david.s@zoho.com is the admin of the Workspace 'Sales'
            con = DriverManager.getConnection("https://analyticsapi.zoho.com/api/david.s@zoho.com/Sales",conProps);
            stmt = con.createStatement();
            String sql ="select * from <tablename>";
            rs = stmt.executeQuery(sql);
        }
        catch(SQLException se)
        {
            // handle any errors
            System.out.println("SQLException: " + se.getMessage());
            System.out.println("Zoho Analytics Error code: " + se.getErrorCode());
        }
        catch(Exception e)
        {
            // handle the exception
        }
        finally
        {
            if(rs != null)
            {
                try
                {
                    rs.close();
                }
                catch(SQLException sqlEx) { } // ignore
            }
            if(stmt != null)
            {
                try
                {
                    stmt.close();
                }
                catch (SQLException sqlEx) { } // ignore
            }
            if(con != null)
            {
                try
                {
                    con.close();
                }
                catch (SQLException sqlEx) { } // ignore
            }
        }
    }
}