This section lists the steps to set up a Maven project.

1. Create a Maven project.
   1. From the File menu, select New, and then select New Maven Project. You can either use maven archetype or select Create a simple project (skip archetype selection) .
   2. Choose GAV for your Maven project. These will appear in the pom.xml file for the project.
      • Group Id: com.oracle
      • Artifact Id: ADBquickstart
      • Version: Leave it as 0.0.1-SNAPSHOT
2. Create the ADBQuickStart.java file.
   1. Right-click on src/main/java, select New, and then select Class.
   2. Enter the following values, and then click Finish.

   • Package: com.oracle.jdbctest
   • Name: ADBQuickStart

     Note:

     Make sure to copy contents of the ADBQuickStart.java file to the new file created.
3. Modify the pom.xml file and add Oracle JDBC driver as a dependency.

   Note:

   ojdbc8-production will download the Oracle JDBC driver (ojdbc8.jar) along with ucp.jar (required for using UCP as a client-side connection pool), oraclepki.jar, osdt_core.jar, and osdt_cert.jar. These JARs are required for using Oracle Wallets while connecting to Oracle Autonomous Database.

   See Also:

   Maven Central Guide

   <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>

This section lists the steps to build and run a Java program.

1. Right-click ADBQuickStart.java .
2. Click Run As, and then click Java Application to run the sample Java program.

   You are prompted to enter the database password. Once you enter the password, the results are displayed.

Sample Output:

The screenshot below shows the queried rows, along with a success message:

Note:

If you connect to Oracle Autonomous Database 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.

This section lists the steps to set up a Maven project.

1. Create a Maven project.
   1. Click from File menu, select New, and then select Project.
   2. Select Maven on the left hand side and select the latest version of JDK as Project SDK.
   3. Click Next.
   4. Give Name as ADBQuickstart.
2. Create the ADBQuickStart.java file.
   1. Right-click on src/main/java.
   2. Select New, and then select Java Class.
   3. Enter com.oracle.jdbctest.ADBQuickStart.java. This will create the required package structure as well. Make sure to copy contents of the ADBQuickstart.java file to this new file.
3. Modify the pom.xml file and add Oracle JDBC Driver as a dependency.

   Note:

   ojdbc8-production will download the Oracle JDBC driver (ojdbc8.jar) along with ucp.jar (required for using UCP as a client-side connection pool), oraclepki.jar, osdt_core.jar, and osdt_cert.jar. These JARs are required for using Oracle Wallets while connecting to Oracle Autonomous Database.

   See Also:

   Maven Central Guide

   <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>

This section lists the steps to build and run ADBQuickStart.

1. Compile the Java code.

   Right-click ADBQuickStart.java, and then click Build Module ADBQuickStart.

   Make sure that there are no compilation errors.

2. Run the sample Java program.

   Right-click ADBQuickStart.java, and then click Run ADBQuickStart.main().

   Make sure to enter the database password on the console.

Sample Output:

The screenshot below shows the queried rows, along with a success message:

Note:

If you connect to Oracle Autonomous Database 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.