At the time this blog was published, DB Adapter is not certified/supported with ATP database. The instruction in this blog is for demonstration purpose only
When you are developing an application using JDeveloper with Oracle ATP (Autonomous Transaction Processing ) Database, you will need to create a connection to ATP instance that you have created. You can use the connection to create a DB connection using DB Adapter in SOA Suite Quickstart JDeveloper. In this blog, this article describes how to configure an ATP connection in JDeveloper.
Before you create a connection in JDeveloper, you will need to create an ATP instance and download the client credentials (Wallet) by following the instruction in this link: https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/adbconnecting.htm#ConnectingtoanAutonomousDatabase
Once the client credentials zip file have been downloaded, unzip it to a folder, you will notice the folder contains the following files:
There are 2 ways to connect, either by using Oracle Wallet or Java KeyStore, the method you choose to use will depend on the tool you are using, as well as the connectivity feature supported by the tool. In SQL Developer, you can use Oracle Wallet. In this example, we will be using Java KeyStore:
Before you configure the database connection in JDeveloper, you need to create the "network/admin" folder in your unzipped wallet folder, then copy the tnsnames.ora to this folder.
You can choose one of the 2 options below to configure your JDeveloper to connect to the ATP database.
1. Modify the jdev.conf, add the following in the jdev.conf file
AddVMOption -Doracle.net.tns_admin=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/network/admin
AddVMOption -Djavax.net.ssl.trustStore=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/truststore.jks
AddVMOption -Djavax.net.ssl.trustStorePassword=<YOUR ATP WALLET PASSWORD>
AddVMOption -Djavax.net.ssl.keyStore=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/keystore.jks
AddVMOption -Djavax.net.ssl.keyStorePassword=<YOUR ATP WALLET PASSWORD>
After configuring your jdev.conf in option 1, you can launch the JDeveloper to configure a new database connection.
2. Add the following in as the JDBC Parameters when you create a database connection in JDeveloper.
oracle.net.tns_admin=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/network/admin
javax.net.ssl.trustStore=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/truststore.jks
javax.net.ssl.trustStorePassword=<YOUR ATP WALLET PASSWORD>
javax.net.ssl.keyStore=<PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/keystore.jks
javax.net.ssl.keyStorePassword=<YOUR ATP WALLET PASSWORD>
In the database connection creation screen, enter the username and password of the ATP Admin user, then choose “Enter Custom JDBC URL” and enter the URL in this format:
The <TNS Alias> can be found in the tnsnames.ora file in the client credential folder above.
If you choose to use option 2 above, you can click on the JDBC Parameters button to enter the name and value listed above.
To connect to the SOACS, you need to follow the steps outlined in this support document (How to configure Jdeveloper to deploy to SOACS? (Doc ID 2583653.1)) to export the default SOACS trust and demo identity SSL certificates, and import them into the trust store you downloaded from ATP.
keytool -importcert -alias SOACSRootCA -file TrustedCertificate -keystore <PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/truststore.jks -storepass <ATP keystore password>
keytool -importcert -alias SOACSIdentity -file Certificate -keystore <PATH TO YOUR UNZIP CLIENT CREDENTIALS ZIP FILE>/truststore.jks -storepass <ATP keystore password>