Building and Testing Databound Web Applications using JCS, DBCS and JDeveloper 12c by Kumar Shahi

Posted: September 4, 2016 in Cloud, WebLogic
Tags: , , , , , , , ,

image

The Cloud has become an integral part of the IT Ecosystem. Organizations are moving their huge physical IT infrastructure to the Cloud for better governance, lower TCO and better ROI. This article showcases the simplicity of using Oracle Java Cloud Service (JCS), Oracle Database Cloud Service (DCS) and JDeveloper 12c  to develop, deploy and test Web Applications

Use Case

I have taken a simple use case of creating an HR Application to show and modify employee information.

In this exercise,

  1. Create Database Cloud Service
  2. Connect DCS using SQL Developer
  3. Set up HR User in DCS, create tables and populate data
  4. Develop HR Application using JDeveloper 12c
  5. Create datasource in JCS to connect HR Schema
  6. Set up Putty to tunnel JCS connection
  7. Set up JCS Connection using JDeveloper 12c
  8. Deploy HRApplication to JCS using JDeveloper 12c
  9. Access diagnostic logs using Putty

Solution

Create Database Service

Log in to Oracle Cloud Service at https://myservices.oraclecloud.com/mycloud/faces/gDashboard.jspx


Supply Identity Domain, User Name, User Password and Sign In.

This dashboard page will open:

Click "Open Oracle Database Cloud Service" to open the page below:

Click the “Create Service” button to create a new Oracle Cloud Database Service. The page below will open. Select Service Level.

The first option, Oracle Database Cloud Service, will be enabled only if the associated Oracle Cloud Storage Account has a container created and available.

Otherwise, choose the Oracle Database Cloud Service-Virtual Image option.

Billing Frequency needs to be specified even if you have a trial account. I have selected “Monthly."

Click “Next.” You’ll see this screen, where you can specify the database version:

Click “Next” and select your Software Edition. I have selected Enterprise Edition.

Click “Next.”

Assign values to the required attribute:

  • Service Name – Specify Database Cloud Service Name
  • Compute Storage – Select configuration you would like to use
  • VM Public Key – Supply Public Key (created as part of prerequisite)
  • Usable Database Storage – Specify storage requirement for the database service
  • Total data file storage – Specify total data file storage
  • Administration Password – Specify Password for the SYS user
  • Confirm Password specified above
  • DB (Database) name – Automatically populated. User can modify if required.
  • PDB (Pluggable Database) Name – Automatically populated. User can modify if required.
  • Backup destination –  The “Both Cloud and Local Storage” option will  be available only if container is configured. Otherwise, user can select “Local Storage Only.”
    If backup destination is “Both Cloud and Local Storage,”  user will have to supply:
    • Cloud Storage Container – e.g., identityDomainName/containerName
    • Cloud Storage User name – cloud admin user name (normally email id)
    • Cloud Storage Password – cloud admin password.

Click “Next.” Confirm on the landing page to start creation of DBaas Service. Read the complete article here.

WebLogic Partner Community

For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Forum Wiki

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s