Provision an Oracle Autonomous Database Instance

You need access to an Oracle Autonomous Database. Refer to Before You Begin with Autonomous Database on Dedicated Exadata Infrastructure if you have no provisioned one already.

Remember the password that you used for ADMIN user. For the demonstration purpose, we will be using ADMIN user, but our recommendation is to create other database users either using Oracle SQL Developer or Database Actions.

Obtain Client Credentials

1. Download a wallet file from the Autonomous Database instance to obtain a zip file that contains the client security credentials and network configuration settings required to access an Autonomous Database instance.

   Obtain the client security credentials (wallet.zip file):

   • ADMIN user: On the Oracle Cloud Infrastructure Console, click Database connection. See Download Client Credentials.
   • Other user (non-administrator): Obtain the Oracle Wallet from the administrator for your Autonomous Database instance.
   Note
   
   Protect the wallet.zip file and its contents to prevent unauthorized database access.
2. Unzip the client credentials file (wallet.zip).

Install JDK 8

Download latest JDK 8 or a higher JDK versions.

Download a Sample Program from Github

1. Download the ADBQuickStart.java file from Github. This sample application uses the Sales History (SH) sample schema and displays 20 records from the SH.CUSTOMERS table.
2. Modify the ADBQuickStart.java file to include your Oracle Autonomous Database connection information:
   • DB_USER: You can use ADMIN, the user created by default when the Oracle Autonomous Database is created (if you create another OracleAutonomous Database user, you can use that user instead).
   • DB_PASSWORD: Use the database user's password. If connecting as the ADMIN user, set this to the password you chose during the Create Autonomous Database step while provisioning Oracle Autonomous Database. For security reasons, you need to enter the password through the console when you run the sample.
   • DB_URL: Enter the net service name (TNS Alias) DBName_medium where DBName is the Oracle Autonomous Database Name entered during the Create Autonomous Database step while provisioning Oracle Autonomous Database. The available net service names can be seen in the tnsnames.ora file, which is a part of the client credentials zip file.

     TNS_ADMIN should point to the location where you have unzipped the client credentials of Oracle Autonomous Database.

   A sample quick start Java file looks like this:

   DB_URL = "jdbc:oracle:thin:@DBName_medium?TNS_ADMIN=/Users/test/wallet_DBName" DB_USER="ADMIN" and DB_PASSWORD="enter_it_from_console"

3. Save changes to the ADBQuickStart.java file.

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

   gradle init

2. Copy the ADBQuickStart.java file to the src/main/java/com/oracle/jdbctest directory.
3. Modify the build.gradle file with the following changes:
   • Add mavenCentral() as a repository.
   • Add Oracle JDBC driver as a dependency.
     Note
     
     ojdbc8-production downloads Oracle JDBC driver (ojdbc8.jar) along with ucp.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 Oracle Autonomous Database.

     For additional information, see Maven Central Guide.

   • Update the mainClassName to ADBQuickStart.
   • Add a run block to read the password from the console.

     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
     }

4. Build a Gradle Application. Make sure you are in the directory where build.gradle file is present. Compile the Java code using the following command:

   ./gradlew build

5. Run the sample Java program.

   ./gradlew run

   Sample Output: The queried rows along with a success message are displayed, as shown in the following screen: