• Pre-requisites: Make sure to complete all the steps from pre-requisites section.

• Create a Maven project : Download Apache Maven and make sure to set the PATH before using mvn commands. Use the following maven command to create a project.

  Copy

  
  
  mvn archetype:generate -DgroupId=com.oracle.jdbctest -DartifactId=jdbc-test-project -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false 
  

• Copy ADBQuickStart.java to src directory : Make sure to copy ADBQuickStart.java to the src/main/java/com/oracle/jdbctest directory.

• Modify pom.xml with the following changes:
  Add Oracle JDBC driver as a dependency. Note: ojdbc8-production will download Oracle JDBC driver (ojdbc8.jar ) along with other companion jars such as ucp.jar (It is a jar required for using UCP as a client side connection pool), oraclepki.jar, osdt_core.jar, osdt_cert.jar (These jars are required for using Oracle Wallets while connecting to Autonomous Database) etc., Refer to Maven Central Guide for more details.

  Copy

  
  
  <properties>
      <maven.compiler.source>11</maven.compiler.source>
      <maven.compiler.target>11</maven.compiler.target>
  </properties>
  <dependencies>
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8-production</artifactId>
      <version>19.18.0.0</version>
      <type>pom</type>
    </dependency>
  </dependencies>
  
  
  

Make sure you are in the directory where pom.xml is present.

• Clean and Compile the Java code: Use the following commands.

  Copy

  
  
  mvn clean
  

  Copy

  
  
  mvn compile
  

• Run the sample Java program

  Copy

  
  
  mvn exec:java -Dexec.cleanupDaemonThreads=false -Dexec.mainClass="com.oracle.jdbctest.ADBQuickStart"
  

• Sample Output:

  You will see the queried rows returned from the database and a message Congratulations! You have successfully used Oracle Autonomous Database as shown in the screenshot below.
  Note: If you connect to ADB from behind a firewall, you will likely encounter a connection timeout error. Make sure to be outside the firewall while running this sample or update the tnsnames.ora file to use an HTTPS proxy. Learn how to do this in "JDBC Thin Connections with an HTTP Proxy" section of the ADB documentation.

  
  
  

• Pre-requisites: Make sure to complete all the steps from pre-requisites section.

• Create a Gradle project : Follow the instructions from Gradle Guide for Gradle download and build instructions. Make sure to set the PATH before using gradle commands. As a first step, create a gradle project using the below command. Make sure to choose "2: application" for 'Select type of project to generate'. Also, for "Source package (default: temp):" use com.oracle.jdbctest.

  Copy

  
  
  gradle init 
  

• Copy ADBQuickStart.java to src directory : Make sure to copy ADBQuickStart.java to the src/main/java/com/oracle/jdbctest directory.

• Modify build.gradle with the following changes:

  • Add mavenCentral() as a repository
  • Add the Oracle JDBC driver as a dependency.
    Note: ojdbc8-production will download Oracle JDBC driver (ojdbc8.jar ) along with other companion jars such as ucp.jar (It is a required jar for using UCP as a client side connection pool), oraclepki.jar, osdt_core.jar, osdt_cert.jar (These jars are required for using Oracle Wallets while connecting to Autonomous Database) etc., Refer to Maven Central Guide for more details.
  • Update the 'mainClassName' to ADBQuickStart.
  • Add run block to pause for reading password from console
  Copy

   
  
  repositories { 
    // Maven Central
     mavenCentral()
   } 
  
  dependencies { 
    // Get the 19.18.0.0 Oracle JDBC driver along with other companion jars
    implementation("com.oracle.database.jdbc:ojdbc8-production:19.18.0.0")
   }
  application { 
    // Define the main class for the application
    mainClassName ='{your_project_directory}.ADBQuickStart' 
  } 
  // To pause to read the password from console
  run {
    standardInput = System.in
  }
   

Make sure you are in the directory where build.gradle is present.

• Compile the Java code: Use the below command.

  Copy

  
  
  ./gradlew build
  

• Run the sample Java program

  Copy

  
  
  ./gradlew run
  

• Sample Output:

  You will see the queried rows returned from the database and a message Congratulations! You have successfully used Oracle Autonomous Database as shown in the screenshot below.
  Note: If you connect to ADB from behind a firewall, you will likely encounter a connection timeout error. Make sure to be outside the firewall while running this sample or update the tnsnames.ora file to use an HTTPS proxy. Learn how to do this in "JDBC Thin Connections with an HTTP Proxy" section of the ADB documentation.

  
  
  

• Pre-requisites: Make sure to complete all the steps from pre-requisites section.

• Create a Maven project :

  • File -->New --> New Maven Project. You can either use maven archetype or check on 'Create a simple project (skip archetype selection)' .
  • Choose GAV for your Maven project: These will appear in pom.xml for the project.
    Group Id: com.oracle
    Artifact Id: ADBquickstart
    Version: Leave it as 0.0.1-SNAPSHOT
    

• Create ADBQuickStart.java: Right click on src/main/java . and click on, New -> Class. Enter the following values.
  Package: com.oracle.jdbctest
  Name: ADBQuickStart and Click 'Finish'.
  Make sure to copy contents of ADBQuickStart.java to this new file created.

• Modify pom.xml with the following changes:
  Add Oracle JDBC driver as a dependency. Note: ojdbc8-production will download Oracle JDBC driver (ojdbc8.jar ) along with other companion jars such as ucp.jar (It is a jar required for using UCP as a client side connection pool), oraclepki.jar, osdt_core.jar, osdt_cert.jar (These jars are required for using Oracle Wallets while connecting to Autonomous Database) etc., Refer to Maven Central Guide for more details.

  Copy

  
  
  <properties>
      <maven.compiler.source>11</maven.compiler.source>
      <maven.compiler.target>11</maven.compiler.target>
  </properties>
  <dependencies>
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8-production</artifactId>
      <version>19.18.0.0</version>
      <type>pom</type>
    </dependency>
  </dependencies>
  
  
  

Make sure you do not have any compilation error in the Java code and you are using the latest JDK version.

• Run the sample Java program: Right Click on ADBQuickStart.java --> Run As --> Java Application.
  You will be shown a prompt to enter the database password and once you enter the password, the results will be shown.

• Sample Output:

  You will see the queried rows returned from the database and a message Congratulations! You have successfully used Oracle Autonomous Database as shown in the screenshot below.
  Note: If you connect to ADB from behind a firewall, you will likely encounter a connection timeout error. Make sure to be outside the firewall while running this sample or update the tnsnames.ora file to use an HTTPS proxy. Learn how to do this in "JDBC Thin Connections with an HTTP Proxy" section of the ADB documentation.

  
  
  

• Pre-requisites: Make sure to complete all the steps from pre-requisites section.

• Create a Maven project :
  

  • Click on File --> New --> Project
    
  • Choose 'Maven' on the left hand side and choose the latest version of JDK as 'Project SDK'. Click Next.
  • Give 'Name' as ADBQuickstart

• Create ADBQuickStart.java : Right click on src/main/java . Click on New --> Java Class. Enter com.oracle.jdbctest.ADBQuickStart.java This will create the required package structure as well. Make sure to copy contents of ADBQuickStart.java to this new file.

• Modify pom.xml with the following changes:
  Add Oracle JDBC driver as a dependency. Note: ojdbc8-production will download Oracle JDBC driver (ojdbc8.jar ) along with other companion jars such as ucp.jar (It is a jar required for using UCP as a client side connection pool), oraclepki.jar, osdt_core.jar, osdt_cert.jar (These jars are required for using Oracle Wallets while connecting to Autonomous Database) etc., Refer to Maven Central Guide for more details.

  Copy

  
  
  <properties>
      <maven.compiler.source>11</maven.compiler.source>
      <maven.compiler.target>11</maven.compiler.target>
  </properties>
  <dependencies>
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8-production</artifactId>
      <version>19.18.0.0</version>
      <type>pom</type>
    </dependency>
  </dependencies>
  
  
  

• Compile the Java code: Right click on ADBQuickStart.java --> Build Module 'ADBQuickStart'. Make sure there are no compilation errors.

• Run the sample Java program: Right click on ADBQuickStart.java --> Run 'ADBQuickStart.main()'. Make sure to enter the database password on the console.

• Sample Output:

  You will see the queried rows returned from the database and a message Congratulations! You have successfully used Oracle Autonomous Database as shown in the screenshot below.
  Note: If you connect to ADB from behind a firewall, you will likely encounter a connection timeout error. Make sure to be outside the firewall while running this sample or update the tnsnames.ora file to use an HTTPS proxy. Learn how to do this in "JDBC Thin Connections with an HTTP Proxy" section of the ADB documentation.

  
  
  

• Make sure to complete all the steps from pre-requisites section.

• Download latest 19c version of ojdbc8-full.tar.gz from OTN and unzip the contents to your classpath.
  Note: ojdbc8-full.tar.gz contains the latest JDBC driver ojdbc8.jar, ucp.jar (It is a required jar for using UCP as a client side connection pool), oraclepki.jar, osdt_core.jar, osdt_cert.jar (These jars are required for using Oracle Wallets while connecting to Autonomous Database)

• Compile the Java program
  Make sure to provide the correct path for the required jars in the classpath.

  Copy

  
   javac -classpath ./lib/ojdbc8.jar:./lib/ucp.jar:/lib/oraclepki.jar:./lib/osdt_core.jar:./lib/osdt_cert.jar com/oracle/jdbctest/ADBQuickStart.java
  

• Run the sample Java program
  Make sure to provide the correct path for the required jars in the classpath.

  Copy

  
   java -classpath ./lib/ojdbc8.jar:./lib/ucp.jar:/lib/oraclepki.jar:./lib/osdt_core.jar:./lib/osdt_cert.jar:. com.oracle.jdbctest.ADBQuickStart
  

• Sample Output:

  You will see the queried rows returned from the database and a message Congratulations! You have successfully used Oracle Autonomous Database as shown in the screenshot below.
  Note: If you connect to ADB from behind a firewall, you will likely encounter a connection timeout error. Make sure to be outside the firewall while running this sample or update the tnsnames.ora file to use an HTTPS proxy. Learn how to do this in "JDBC Thin Connections with an HTTP Proxy" section of the ADB documentation.