Friday, May 15, 2015

ADF DVT NBox visualisation component in ADF 11.1.1.9

With the arrival of ADF 11.1.1.9 a new visualisation component is included. The NBox.
"The ADF NBox is an interactive data visualization tool that allows users to view data displayed in a grid across two dimensions, each dimension representing a range of data. Customizable nodes representing data items are displayed in the cells formed by the intersection of the two dimensions." (Source: Oracle Documentation)
I never heard of the NBox before so I had to give it a try. I am quite impressive so far! Take a look

Use Case Description

In my sample for the NBox component I would like to display Employees on the dimensions „Origin“ (Country) and „Income“ (Salary).

How To

Step 1: Create a Read-Only ViewObject on the HR.EMP_DETAILS_VIEW Database View. That View includes all needed data for the use case. Nothing special here. So I am not going into details.

Step 2: Create a transient attribute to calculate the salaryLevel (lower, middle, upper - so that’s just my simple idea to divide Employees into 3 Salary-Groups so to say). I am doing this by a groovy expression: "Salary < 5000.0 ? 'lower' : (Salary < 10000.0 ? 'middle' : 'upper‘)"



Step 3: Create transient attribute to calculate an CountryDiscriminator. My idea here is to categorize every employee by the following Country-groups: US, UK and „Others“. To achieve that I am using the following groovy expression: "CountryId in ['US', 'UK']?CountryId:’OTHER'"


That’s all you need on the model side. The rest is done on the UI Layer.

Step 4: Open the „Data Controls“ palette and drag&drop the Collection „EmpDetailsView1“ onto the view (JSPX). Choose NBox from contextual menu.



Dialog opens to configure the Rows und Columns. Enter the column und row numbers, assign values and labels. In this example there are exactly 3 rows and 3 columns. The values should exactly match your values from the transient attributes.



Click: Next

The NBoxes nodes are going to be „Employee Names“ Each node will be stamped by the SalaryLevel (for income dimension) and CountryDiscriminator (for origin dimension)

In the Node-tab define the grouping by „JobTitle“. Choose color as Node classifier.


Click Tab: Indicator
Define the grouping by ‚DepartmentId“. Choose „Shape“ as indicator. (color is already used for the Job title classification)


Click: Finish-Button

The generated JSPX code will look like the following snippet. The data is bound against a tree binding.



Conclusion

The NBox component is quite rich. With some basic understanding it is very easy to transform data into meaningful and easy to read information! Beyond the given use case there are a lot more ways to visualize data. It’s worth to take a look into the documentation. Have fun!

Download Sourcecode

https://github.com/enpit/enpit.sample.adf.nbox

Further Information

From ADF Web UI Guide 11.1.1.9
- 23.2.3 NBox Use  Cases and Examples
- 26  Using NBox Components

From ADF Fusion Developer Guide 11.1.1.9
-  26.5 Creating Databound NBoxes

Issues

(1) As you can see from the screenshot of the „Create NBox“ dialog the „Next“-Button is disabled although everything required is filled in. The Button gets enabled once you click in some of the cells.
(2) In the second step of the „Create NBox“ sample the „Back“-Button is disabled although there is no reason. Workaround: fill in both required fields Row/ Column. Then the Back-Button gets enabled.

Tuesday, April 21, 2015

Java Cloud Service Webcast on April 24th 2015

[Source: Oracle]
Oracle Java Cloud Service is a part of the platform service offerings in Oracle Public Cloud Services. Powered by Oracle WebLogic Server, it provides a platform for developing and deploying new or existing Java EE applications.

Schedule: April 24th 2015 15:00-16:00 CET (Berlin time)
Presenters: Cosmin Tudor and Jürgen Kress
Registration: register here

In this webcast Cosmin & Jürgen  will provide both an overview presentation and a short demo that will cover the new Oracle Java Cloud Services - Platform as a Service offerings and the integration with other Oracle Cloud offerings like: Developer Cloud Services, Database Cloud Services, Documents Cloud Services ...

In about 1 hour the following topics will be covered:
  • Java Cloud Services:
    • Java Cloud Services PaaS and PaaS – Virtual Image
    • Java Cloud Services SaaS Extensions
    • Management and Administration:
      • Provisioning
      • Backup and Recovery
      • Patching
      • Scaling
      • REST API
    • Coherence Cloud Services
    • Storage Cloud Services
    • Compute Cloud Services
  • Developer Cloud Services
  • Database Cloud Services

Looking forward to it! Hope to see you in the webcast!

Sunday, March 8, 2015

#ofmForum 2015 in Budapest has rocked!

Last week I attended the Oracle Fusion Middleware Partner Community Forum 2015 in Budapest. Over 150 participants from Europe, US and even Latin America (Peru, Costa Rica, Mexico, Venezuela) joined the great event where various Oracle Product Managers and Oracle Partners exchanged their experiences with the community. Jürgen Kress  - well known from his soacommunity & weblogiccommunity blogs - and his team hosted a great event at a great location! Thanks a lot!

The Digital Transformation is just starting

We got an update about Oracles overall cloud & mobile strategy that drives the digital transformation. Nowadays there is a huge demand on business agility due to disruptive technologies and market shifts.

Oracles answer to these requirements are the upcoming Cloud Services

  • Integration Cloud Service (ICS)
  • Process Cloud Service (PCS)
  • Mobile Cloud Service (MCS)
and SaaS solutions running on Oracles PaaS (Database Cloud Service, Java Cloud Service). The main focus for the upcoming releases for  Oracle SOA/BPM/ACM 12c is on stability & improvements.

The nice thing about the ofmForum is that there wasn't just slides but on the most products real working demos. On day 2 there were 3 parallel tracks dedicated for SOA, BPM/ACM and WebLogic&Mobile. The experts gave demos on API Catalog, API Manager, StreamExplorer, Event Processing, Mobile Alta UI & OSB Integration for SOAP to REST transformations, MAF, ICS, PCS, MCS and the Java Cloud Service (JCS) plus Developer Cloud Service.  Really a lot of new acronyms to learn ;)

Day 3/4 was dedicated to 4 parallel Workshops with a lot of hands-on sessions. (SOA, BPM/ACM, Mobile Application Framework (MAF), Multichannel Enablement). I attended the Multichannel workshop. Based on an existing  SOAP-Webservice we used OSB 12c to transform it (without coding) to a REST JSON based service. On top of that we built a mobile app with MAF. In the end I had a running MAF application on my real iOS device.


Networking & Get-together

Besides the cool and new technologies there were a lot of chances to network and get in touch with Oracle Product Managers and Partners. I enjoyed it a lot meeting persons I only knew from twitter or blogs. Thanks for all the great conversations! Further, Budapest is an amazing city! Good food, wine & bars and historical locations. Thanks Jürgen and Oracle for the nice dinner in the spoon restaurant. And if you are in Budapest check out the Simpla Kertmozi, a pretty cool "ruin bar":)


I am really looking forward for the next OFM Forum 2016. Which location will be next?

Further information

See more cool pictures of the event in the twitter stream #ofmForum

Wednesday, February 25, 2015

Oracle ACE Director Confirmation and Fusion Middleware Forum 2015 in Budapest

I am happy to say having been nominated as Oracle ACE Director and being accepted lately. Big thanks to the ACE Program and everyone who was involved and made this happen.  I feel really honoured! It motivates me to participate and contribute more with the community.

It is challenging doing the daily business, taking time for conferences, writing blog posts, sharing Oracle FMW Content through social media channels, enjoying free time with family, etc.  Anyway whenever time permits I will try to continue with content contribution for Oracle ADF,  WebCenter, WebLogic, Cloud Services, MAF! Hope you enjoyed my existing posts so far and will enjoy it in future :) @oracleace thanks for the nice welcome gifts!


Find my ACE Profile page here.


Oracle Fusion Middleware Forum 2015

This year I am going to attend the annual OFM Forum in Budapest with lots of great presentations and Hands-On. It is organized by the SOA Community (led by Jürgen Kress). I am looking forward to meet with the community and see what Oracle plans for the upcoming FMW & Cloud Services.

SOA Suite 12c & Integration Cloud Service
BPM Suite 12c & Process Cloud Service
Mobile & Development tools & Mobile Cloud Service
WebLogic 12c & Java Cloud & Developer Cloud Service


There are 6 days left to register ;)
March 3-4, 2015, 10:30 AM - 5:00 PM
Check out the Agenda and Registration!


More Information




Sunday, January 25, 2015

ADF 12c Deck component Overview & Programmer examples

This year the german ADF Community resumed with "ADF Spotlight" - a series of 30 min Webcasts. It was my turn to give use cases and a programmers overview for the ADF 12c deck component. Since I like to share with the international community I made an english version of the few slides.
 


Download Sample: enpit.sample.adf1213.deck-jdev1213-v2.zip (It contains the use case for Image -> Detail and Slideshow)

Further information


Sunday, November 16, 2014

Create RESTful Services and deploy to Oracle Java Cloud Service with Netbeans

In preparation to one of my DOAG 2014 talks „Java WebApps and Services in Oracle Cloud" I created a new trial account for Oracle Java Cloud Service (http://cloud.oracle.com) two weeks ago. Now was the time to create a RESTful Service and deploy it to the cloud and make it accessible to public. 

Last time I tried the Oracle Cloud I used exclusively JDeveloper, this time I made my experience with Netbeans. From my point of view Netbeans has pretty good support for generating RESTService from Database tables. In a couple of minutes it is possible to create CRUD Operations and make it accesible by a REST endpoint. No matter what content type you prefer, by using JAXB XML and JSON content types are both automatically available.

Prerequites
Step 1: Create an Oracle Java Cloud Service trial account (fee less for 30 days)
Step 2: Download and install Netbeans Version 8.01 (http://www.netbeans.org)
Step 3: Make sure to install the Oracle Cloud plugin (1.5)  in Netbeans


Step 4: Download and Install (just unpack) Oracle Java Cloud  Service - Saas Extension SDK (release 14.1.12.0 Find it here: http://www.oracle.com/technetwork/middleware/weblogic/downloads/java-cloud-sdk-1848874.html)
Step 5: Next add your Oracle Cloud account as Cloud Provider to Netbeans (Goto „Services" Tab and provide your cloud account details)

Step 6: Add a WebLogic Service Instance under ‚Services Tab', so you are able to test the RESTService locally prior to deploying to Oracle Cloud. (I am not going into detail in this post for that task)

Step 7: Make sure to deploy your DB Schema objects plus data into Oracle Database Cloud Service (when subscribing to Java Cloud Service you will get the DB Service as well). See in my previous posts for more details.

HowTo develop RESTService with Netbeans
Everything is setup for cloud deployment. Now let's create a simple REST-Service on top of the HR  DB Tables EMPLOYEES and DEPARTMENTS.

Step 1: Start Netbeans, Create new Project Wizard from Type „Maven / Web Application"
Step 2: Enter your desired groupId, ArtefactId etc.

Step 3: Choose Oracle WebLogic as ‚Server' and Java EE Version 5.

Click Finish.

Step 3: Start „RESTFul Services from Database" Wizard


Step 4: Make a connection to your local database and select the desired Tables.


Step 5: Review and adapt Package-Settings if desired

Next:

Confirm your input and let Netbeans generate the source code. If you like you can make some adjustments to the generated code. Typically I would change the REST resource path. (in my sample: to „employees")


Step 6: In order beeing deployable to Oracle Cloud we need to make further some adjustments. That
is
Adjustment 1: web.xml
(1) We need to change the servlet class from org.glassfish.jersey.servlet.ServletContainer to com.sun.jersey.spi.container.servlet.ServletContainer because the prior class is not available on the cloud server. (2) Further add an <login-config /> if you want to make the Service publicly (without authentication) available.

Adjustment 2: weblogic.xml
Add a library reference to jax-rs 1.1
Adjustment 3: persistence.xml
Configure your Cloud DB Service name as JNDI Data Source


Deploy RESTService to the cloud

Step 1: Open Project Properties, Choose ‚Oracle Cloud Remote" Server Type, Java EE Version 5

Step 2: Execute ‚Run'
The cloud deployment will start...

The WAR file will be virus scanned...
And Finally deployed to the cloud.

Test the cloud RESTService
If using Chrome install the Postman extension to test the Service. e.g. to test different content types. JSON, XML
….


Administer Oracle Java Cloud Service from within Netbeans
Right under the Service Tab your able to Open the Apps, Start, Stop or Undeploy.

To view the Job Status and Logs open the corresponding view from the Oracle Cloud entry.


Troubleshooting
If something goes wrong open the Cloud Job View and Logs Tab to check the details, e.g. if a deployment fails. (1) ClassNotFound Exception

Solution in that particular case is: Use com.sun.jersey.spi.container.servlet.ServletContainer instead of org.glassfish.jersey.servlet.ServletContainer.

(2) java.lang.AbstractMethodError: javax.ws.rs.core.UriBuilder.uri(Ljava/lang/String;)Ljavax/ws/rs/core/UriBuilder

Solution: Somehow the generated POM had a fixed reference to JAX-RS Library which is provided from the cloud server. So I changed that dependency

Conclusion
- Having everything setup (Cloud SDK, local WebLogic Servece, DB Objects in the Cloud Service) it is quite easy to build and deploy RESTful services.
- Why is the SDK not bundled with the Netbeans Oracle Cloud Plugin?
- I wish there would be that kind of wizard (RESTful Services from Database) for JDeveloper ;)


Further Information
- See also: http://www.oracle.com/technetwork/articles/java/enterprise-cloud-2227135.html (Build with NetBeans IDE, Deploy to Oracle Java Cloud Service)