Build a Java application

    Working example

    This tutorial assumes that you have:

    • YugabyteDB up and running. If you are new to YugabyteDB, you can download, install, and have YugabyteDB up and running within five minutes by following the steps in the Quick Start guide.
    • Java Development Kit (JDK) 1.8, or later, is installed. JDK installers for Linux and macOS can be downloaded from , AdoptOpenJDK, or .
    • Apache Maven 3.3, or later, is installed.
    1. <?xml version="1.0"?>
    2. <project
    3.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
    4.   xmlns="http://maven.apache.org/POM/4.0.0"
    5.   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    6.   <modelVersion>4.0.0</modelVersion>
    8.   <groupId>com.yugabyte.sample.apps</groupId>
    9.   <artifactId>hello-world</artifactId>
    10.   <version>1.0</version>
    11.   <packaging>jar</packaging>
    13.   <dependencies>
    14.     <dependency>
    15.       <groupId>org.postgresql</groupId>
    16.       <artifactId>postgresql</artifactId>
    17.       <version>42.2.5</version>
    18.     </dependency>
    19.   </dependencies>
    21.   <build>
    22.     <plugins>
    23.       <plugin>
    24.         <groupId>org.apache.maven.plugins</groupId>
    25.         <artifactId>maven-compiler-plugin</artifactId>
    26.         <version>3.7.0</version>
    27.           <source>1.8</source>
    28.           <target>1.8</target>
    29.         </configuration>
    30.       </plugin>
    31.       <plugin>
    32.         <groupId>org.apache.maven.plugins</groupId>
    33.         <artifactId>maven-dependency-plugin</artifactId>
    35.         <executions>
    36.           <execution>
    37.             <id>copy-dependencies</id>
    38.             <phase>prepare-package</phase>
    39.             <goals>
    40.               <goal>copy-dependencies</goal>
    41.             </goals>
    42.             <configuration>
    43.               <outputDirectory>${project.build.directory}/lib</outputDirectory>
    44.               <overWriteReleases>true</overWriteReleases>
    45.               <overWriteSnapshots>true</overWriteSnapshots>
    46.               <overWriteIfNewer>true</overWriteIfNewer>
    47.             </configuration>
    48.           </execution>
    49.         </executions>
    50.       </plugin>
    51.     </plugins>
    52.   </build>
    53. </project>

    Create the appropriate directory structure as expected by Maven.

    1. package com.yugabyte.sample.apps;
    3. import java.sql.Connection;
    4. import java.sql.DriverManager;
    5. import java.sql.PreparedStatement;
    6. import java.sql.ResultSet;
    8. public class YBSqlHelloWorld {
    9.   public static void main(String[] args) {
    10.     try {
    11.       // Create the DB connection
    12.       Connection connection = null;
    13.       connection = DriverManager.getConnection(
    16.       // Create table 'employee'
    17.       String createStmt = "CREATE TABLE employee (id int PRIMARY KEY, " +
    18.                                                  "name varchar, " +
    19.                                                  "age int, " +
    20.                                                  "language varchar);";
    21.       connection.createStatement().execute(createStmt);
    22.       System.out.println("Created table employee");
    24.       // Insert a row.
    25.       String insertStmt = "INSERT INTO employee (id, name, age, language)" +
    26.                                                 " VALUES (1, 'John', 35, 'Java');";
    27.       connection.createStatement().executeUpdate(insertStmt);
    28.       System.out.println("Inserted data: " + insertStmt);
    30.       // Query the row and print out the result.
    31.       String selectStmt = "SELECT name, age, language FROM employee WHERE id = 1;";
    32.       PreparedStatement pstmt = connection.prepareStatement(selectStmt);
    33.       ResultSet rs = pstmt.executeQuery();
    34.       while (rs.next()) {
    35.           String name = rs.getString(1);
    36.           int age = rs.getInt(2);
    37.           String language = rs.getString(3);
    38.           System.out.println("Query returned: " +
    39.                              "name=" + name + ", age=" + age + ", language: " + language);
    40.       }
    42.       // Close the client.
    43.       connection.close();
    44.     } catch (Exception e) {
    45.         System.err.println("Error: " + e.getMessage());
    46.     }
    47.   }
    48. }

    To build the application, run the following command.

    You should see the following as the output.