Create an ATP DataSource in Weblogic Server

1. Place the ATP Wallet File and Extract the same

a. File location : C:\Xx\Xxx\Xxx\Xxx\ATP_DB\ATPdb

2.    Get below details to be used for creating a DataSource Connection

a.    Open TnsNames.ora inside the extracted zip file and get the Hostname(Xxpaasdb_tp)

b.   DB UserName : XXX

c.    DB Password : YYY

3.    Log in to WebLogic Console and Navigate to Services>DataSource > New > Generic DataSource

 

4.    Give Connection name and a JNDI name via which to access the DataSource

 



            Name : paasdbXXX

            JNDI Name : jdbc/paasdbXXX

5.    Click on Next, keep default selection


6.    Enter dummy data in Connection properties (as we will be correcting the same in Next screen)


7.    Click Next, Enter correct data as shown below



        URL = jdbc:oracle:thin:@<hostname>

        Database User Name = XXX

        Database Password = YYY

        Properties : 

        oracle.net.tns_admin= C:\Xx\Xxx\Xxx\Xxx\ATP_DB\ATPdb

        user=<DB Username>

        javax.net.ssl.keyStore= C:\Xx\Xxx\Xxx\Xxx\ATP_DB\ATPdb \keystore.jks

        javax.net.ssl.trustStore= C:\Xx\Xxx\Xxx\Xxx\ATP_DB\ATPdb \truststore.jks

        oracle.net.ssl_server_dn_match=true

 

8.              8.  Test Configuration to see if it’s a Success

 

 

9.              9.  Click on Finish to create a DataSource

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