Create ATP Connection in JDeveloper v12.2.1.4

 1. Before creating ATP connection in JDeveloper, keep below data ready

        a. DB Username: XXX

        b. Db Password: YYY

        c. Extract Wallet file location: C:\xx\ATP_DB

        d. Create network/admin path inside the extracted Cloud Wallet folder and move tnsnames.ora file into it

        e. KeyStore/Truststore Password: Usually same as Wallet password

        f. Open TnsNames.ora inside the extracted Cloud Wallet zip file and get the Hostname(xxpaasdb_tp)

 

2. Open Database > New

 


3. Enter below given default values

        a. Connection Name: <Custom Connection Name>

        b. Username: <DB Username>

        c. Password: <DB Password>

        d. Custom JDBC Url: jdbc:oracle:thin:@<Hostname>


 


4. Open JDBC Parameters and enter below details

Property Value
javax.net.ssl.keyStore C:\xx\ATP_DB\Walletdb\keystore.jks
javax.net.ssl.keyStorePassword
javax.net.ssl.keyStoreType JKS
javax.net.ssl.trustStore C:\xx\ATP_DB\Walletdb\truststore.jks
javax.net.ssl.trustStorePassword
javax.net.ssl.trustStoreType JKS
oracle.jdbc.fanEnabled false
oracle.net.ssl_server_dn_match true
oracle.net.ssl_version 1.2
oracle.net.tns_admin C:\xx\ATP_DB\Walletdb\network\admin

      


5. Click on ok and Test the Connection, you should see a success message



 


Comments

Post a Comment

Popular posts from this blog

Mavenize an Oracle ADF Application

Image
To Mavenize an Oracle ADF Application first step would be to Setup Maven in Jdeveloper after this we Mavenize Oracle ADF Application . Follow below steps to Setup Maven in Jdeveloper 1.> Navigate to Tools > Preferences > Maven > Settings 2.> Get user settings file path - For me it is : C:\Users\username\.m2\settings.xml 3.> Navigate to path and modify settings file server tag as below  <servers>     <server>     <id>maven.oracle.com</id>     <username>OracleUserName</username>     <password>OraclePwd</password>     <configuration>       <basicAuthScope>         <host>ANY</host>         <port>ANY</port>         <realm>OAM 11g</realm>       </basicAuthScope>       <httpConfiguration>       ...
Read more

Creating Column Filter on a VBCS Table using ListDataProvider(LDP)

Image
 In this blog we will create filter functionality for a table using ListDataProvider (LDP). Create an ADP based Table in VBCS based on any Data Source For this example, I will use a JSON file as Data Source and create an ADP based table for the same Create textboxes on top of columns which will act as filters for the columns Create 5 textboxes on top of each column to act as filters Create searchObject variable and map all filter text values to it Convert the ADP to ListDataProviderView Create function to convert ADP to ListDataProviderView Call custom function getListViewProvider , it takes a custom ADP and filter Criteria as parameters, on Page all data are shown hence filter criteria passed will be null Call on vb-Enter event and assign the same to oj-table data Assign a single value change event for all the filter fields Call custom function getFilterCriterion to get filter criteria for ListDataProviderView Filter the ListDataProviderView based on the filter criteria Run the Ui...
Read more

Using Custom Colors in Sunburst Chart

Image
 In  Previous blogs we have created Sunburst Chart, now we will try to add custom color to the same Create VBCS App with Sunburst Chart Create a Global array and provide it custom rgb color palette values. Now create a custom function which will return an array value randomly or based on any custom logic, for this example i will be passing the color based on the node’s id value. Replace the old function with the newly created one Now you can see custom colors as per our logic and also these colors will remain static and will not change every time the ui is opened.
Read more