Updated on 2022-06-01 GMT+08:00

Preparing a JDBC Client Development Environment

To run the JDBC API sample code of Presto, you need to perform the following operations. The following example develops an application that uses JDBC to connect to Presto in the Windows environment.

Procedure

  1. Obtain the Presto sample project. Obtaining a Sample Project provides the address.
  2. In the root directory of the Presto sample project, run the mvn install command to perform compilation.
  3. In the root directory of the Presto sample project, run the mvn eclipse:eclipse command to create an Eclipse project.
  4. In the application development environment, import the sample project to the Eclipse development environment.

    1. Choose File > Import > General > Existing Projects into Workspace > Next > Browse.

      The Browse Folder dialog box is displayed.

    2. Select the presto-examples folder. On Windows, the folder path cannot contain any space.
    3. Click Finish.

      After successful import, the PrestoJDBCExample class is the JDBC API sample code.

  5. Set an Eclipse text file encoding format to prevent garbled characters.

    1. On the Eclipse menu bar, choose Window > Preferences.

      The Preferences window is displayed.

    2. In the navigation tree, choose General > Workspace. In the Text file encoding area, select Other and set the value to UTF-8. Click Apply and then OK. Figure 1 shows the settings.
      Figure 1 Setting the Eclipse encoding format

  6. Modify the sample. You can skip this step for a cluster with Kerberos authentication disabled.

    After obtaining the krb5.conf and user.keytab files of the new development user in 4, modify KerberosPrincipal in presto.properties to the principal of the new user, KerberosConfigPath to the path of the krb5.conf file, and KerberosKeytabPath to the path of the keytab file.