Maven based web project runtime error while loading the context -- and resolution

ERROR is given below that is seen in tomcat console:
SEVERE: Error configuring application listener of class org.springframework.web.context.ContextLoaderListener
java.lang.NoClassDefFoundError: org/springframework/context/ApplicationContextException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
at java.lang.Class.getConstructor0(Class.java:2699)
at java.lang.Class.newInstance0(Class.java:326)
at java.lang.Class.newInstance(Class.java:308)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3916)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.lang.ClassNotFoundException: org.springframework.context.ApplicationContextException
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:305)
at java.lang.ClassLoader.loadClass(ClassLoader.java:246)
... 20 more
Dec 11, 2013 7:06:04 PM org.apache.catalina.core.StandardContext listenerStart

Reason: The war files that is going to deployed to the configured tomcat server not including the spring and all other dependent jar files.  Specially if your project is built with maven.

Resolution: In the Eclipse managed tomcat can be solved by adding maven dependencies in the project's web deployment assembly.

1) Open the project's properties (e.g., right-click on the project's name in the project explorer and select "Properties")
2) select "Deployment Assembly"
3) Click the "Add..." button on the right margin
4) Select "Java Build Path Entries" from the menu of Directive Type and click "Next"
5) Select "Maven Dependencies" from the Java Build Path Entries menu and click "Finish".

You should see "Maven Dependencies" added to the Web Deployment Assembly definition.

Working with TABLE TYPE OBJECTS

Some times its necessary that we get the data from the Oracle PL/SQL procedures as a TABLE type objects.  Retrieving the data from the table type objects is not same as we retrieve the data from ResultSet.  So, here a complete example is given for the benefit of PL/SQL and Java developers. 
       
        1.       Create a table EMPLOYEE

  CREATE TABLE EMPLOYEE_MASTER

   (           EMPID                 NUMBER(10,0) PRIMARY KEY,   

FNAME                                 VARCHAR2(20 BYTE), 

                LNAME                 VARCHAR2(20 BYTE),     

DOB_DATE          DATE, 

                SALARY                 NUMBER(10,0), 

                REMARKS            VARCHAR2(50 BYTE)

 ) ;

2.       Create an object and its body for new object creation.  Body is useful for testing the procedure with in the plsql code.

                              CREATE OR REPLACE TYPE EMP_RECORD_OBJ  AS  OBJECT(

FIRSTNAME        varchar2(20),  

LASTNAME         varchar2(20),

SALARY                 number(10),  

DOB                       DATE,  

REMARKS            varchar2(50),

                STATIC FUNCTION GET_OBJ_FUNCTION   RETURN  EMP_RECORD_OBJ

 );

         

         --//  EMP_RECORD_OBJ  body creation helpful for creating  a new object with null values

               CREATE OR REPLACE TYPE BODY EMP_RECORD_OBJ  

IS

   STATIC FUNCTION GET_OBJ_FUNCTION   RETURN EMP_RECORD_OBJ  

   IS

   BEGIN

      RETURN EMP_RECORD_OBJ  (NULL,  NULL,   NULL,  NULL,  NULL  );

   END;

END;

3.       Create a table type (create under a schema directly to call from   jdbc but not inside the package.)

CREATE OR REPLACE    TYPE   EMP_RECORD_OBJ_ARRAY    IS  TABLE OF   EMP_RECORD_OBJ  ;

4.  Create a procedure to return the table type object from the table

CREATE OR REPLACE  PROCEDURE GET_TABLE_OUTPUT (

            START_EMPID     IN NUMBER,

            END_EMPID       IN NUMBER,

            RECORDS_LIST    OUT  EMP_RECORD_OBJ_ARRAY    )

 AS

 v_emp_array                    EMP_RECORD_OBJ_ARRAY;

 emp_rec                             EMPLOYEE_MASTER%rowType;

 rec_index                           NUMBER;

 CURSOR  EMPLOYEE_CUR  IS    SELECT EMPID , FNAME,  LNAME, DOB_DATE,  SALARY,

REMARKS FROM EMPLOYEE_MASTER;

 BEGIN

  IF  v_emp_array.EXISTS(1)         THEN    v_emp_array.DELETE();   END IF;

  v_emp_array       :=      EMP_RECORD_OBJ_ARRAY();

  rec_index         :=      0;

  OPEN   EMPLOYEE_CUR;

   LOOP

     FETCH EMPLOYEE_CUR INTO emp_rec;

     EXIT WHEN EMPLOYEE_CUR%NOTFOUND;

     IF emp_rec.empid >= start_empid and  emp_rec.empid <= end_empid THEN

      v_emp_array.EXTEND();

      rec_index := rec_index+1;

      v_emp_array(rec_index) := EMP_RECORD_OBJ.GET_OBJ_FUNCTION();

      v_emp_array(rec_index).FIRSTNAME      := emp_rec.fname;

      v_emp_array(rec_index).LASTNAME       := emp_rec.lname;

      v_emp_array(rec_index).SALARY := emp_rec.salary;

      v_emp_array(rec_index).DOB            := emp_rec.dob_date;

      v_emp_array(rec_index).REMARKS        := emp_rec.remarks;

     -- DBMS_OUTPUT.PUT_LINE(emp_rec.fname || 'is -->> ' || emp_rec.remarks);

     END IF;

   END LOOP;

   CLOSE EMPLOYEE_CUR;

                RECORDS_LIST    := v_emp_array;

  EXCEPTION WHEN OTHERS THEN

                RECORDS_LIST    := NULL;

END;

5.       Now enter some master records for testing

INSERT INTO EMPLOYEE_MASTER VALUES (1, 'KHALEEL','SHAIK', SYSDATE-9000, 10000, 'PRACTICE HEAD');

INSERT INTO EMPLOYEE_MASTER VALUES (2, 'RAJA','RAO', SYSDATE-8000, 99000, 'MANAGER');

INSERT INTO EMPLOYEE_MASTER VALUES (3, 'RANGA','RAJU', SYSDATE-9200, 9000, 'LEAD');

INSERT INTO EMPLOYEE_MASTER VALUES (4, 'RAMANA','REDDY', SYSDATE-9100, 11000, 'MANAGER PROJECTS');

INSERT INTO EMPLOYEE_MASTER VALUES (5, 'MOHAN','RAO', SYSDATE-9100, 20000, 'SOLARIS ADMIN');

INSERT INTO EMPLOYEE_MASTER VALUES (6, 'PRANEETH','M', SYSDATE-6000, 8000, 'PROGRAMMER');

INSERT INTO EMPLOYEE_MASTER VALUES (7, 'SHIVA','REDDY', SYSDATE-8500, 11000, 'PROGRAMMER');

INSERT INTO EMPLOYEE_MASTER VALUES (8, 'SURENDER','KUMAR', SYSDATE-9000, 10000, 'LEAD PROGRAMMER');

INSERT INTO EMPLOYEE_MASTER VALUES (9, 'MUNNA','BHAI', SYSDATE-10000, 20000, 'BHAI');

INSERT INTO EMPLOYEE_MASTER VALUES (10, 'RANI','RARU', SYSDATE-3000, 10000, 'HR');

 COMMIT;

6.       Testing the procedure from PL/SQL

SET serveroutput on;

DECLARE

TEST_emp_array              EMP_RECORD_OBJ_ARRAY;

                BEGIN

                                GET_TABLE_OUTPUT (1, 4,   TEST_emp_array);

FOR index  IN 1 .. TEST_emp_array.COUNT

LOOP

DBMS_OUTPUT.PUT_LINE('Here is a last name: '|| TEST_emp_array (index).LASTNAME);

END LOOP;

                END;

                Note: Now you should be able to see the below output:

                        Here is a last name: SHAIK

Here is a last name: RAO

Here is a last name: RAJU

Here is a last name: REDDY

         7.       Testing the procedure from java through JDBC call.

import java.sql.Array;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;
import java.sql.Struct;
import java.sql.Types;
import java.text.SimpleDateFormat;
import java.util.Date;

import oracle.sql.StructDescriptor;

public class TestOracleTableOfResult {

public static void main(String...a) throws Exception {
Class.forName("oracle.jdbc.OracleDriver");
Connection connection = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1521:XE");

final String typeName = "EMP_RECORD_OBJ";
final String typeTableName = "EMP_RECORD_OBJ_ARRAY";
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");

// Get a description of your type (Oracle specific)
final StructDescriptor structDescriptor = StructDescriptor.createDescriptor(typeName.toUpperCase(), connection);
final ResultSetMetaData metaData = structDescriptor.getMetaData();

// Call the procedure (or whatever else) that returns the table of a custom type
CallableStatement cs = connection.prepareCall("{call GET_TABLE_OUTPUT(?, ?, ?)}");
cs.setInt(1, 1);
cs.setInt(2, 5);
// Result is an java.sql.Array...
cs.registerOutParameter(3, Types.ARRAY, typeTableName);
cs.execute();

// Now who's elements are java.sql.Structs
Object[] data = (Object[]) ((Array) cs.getObject(3)).getArray();
for(Object tmp : data) {
Struct row = (Struct) tmp;
// Attributes are index 1 based...
int idx = 1;
for(Object attribute : row.getAttributes()) {
System.out.print(metaData.getColumnName(idx) + " = " + attribute);

//Use the below switch block to populate into a POJO object.
switch (idx){
case 1 : System.out.println(" <<===>> as Column FirstName index = " + idx + " , value = " + attribute.toString()); break;
case 2 : System.out.println(" <<===>> as Column LastName index = " + idx + " , value = " + attribute.toString()); break;
case 3 : System.out.println(" <<===>> as Column Salary index = " + idx + " , value = " + Integer.parseInt(""+attribute.toString())); break;
case 4 : System.out.println(" <<===>> as Column Date Of Birth index = " + idx + " , value = " + df.parse(attribute.toString())); break;
case 5 : System.out.println(" <<===>> as Column Remarks index = " + idx + " , value = " + attribute.toString()); break;
}

++idx;

}
System.out.println("----------------------------");
}
cs.close();
connection.close();
}
}

The output of the Java program will be:

FIRSTNAME = KHALEEL <<===>> as FirstName index = 1 , => KHALEEL

LASTNAME = SHAIK <<===>> as LastName index = 2 , => SHAIK

SALARY = 10000 <<===>> as Salary index = 3 , => 10000

DOB = 1989-04-20 15:44:36.0 <<===>> as DOB index = 4 , => Thu Apr 20 15:44:36 IST 1989

REMARKS = PRACTICE HEAD <<===>> as Remarks index = 5 , => PRACTICE HEAD

----------------------------

FIRSTNAME = RAJA <<===>> as FirstName index = 1 , => RAJA

LASTNAME = RAO <<===>> as LastName index = 2 , => RAO

SALARY = 99000 <<===>> as Salary index = 3 , => 99000

DOB = 1992-01-15 15:44:36.0 <<===>> as DOB index = 4 , => Wed Jan 15 15:44:36 IST 1992

REMARKS = MANAGER <<===>> as Remarks index = 5 , => MANAGER

----------------------------

FIRSTNAME = RANGA <<===>> as FirstName index = 1 , => RANGA

LASTNAME = RAJU <<===>> as LastName index = 2 , => RAJU

SALARY = 9000 <<===>> as Salary index = 3 , => 9000

DOB = 1988-10-02 15:44:36.0 <<===>> as DOB index = 4 , => Sun Oct 02 15:44:36 IST 1988

REMARKS = LEAD <<===>> as Remarks index = 5 , => LEAD

----------------------------

FIRSTNAME = RAMANA <<===>> as FirstName index = 1 , => RAMANA

LASTNAME = REDDY <<===>> as LastName index = 2 , => REDDY

SALARY = 11000 <<===>> as Salary index = 3 , => 11000

DOB = 1989-01-10 15:44:36.0 <<===>> as DOB index = 4 , => Tue Jan 10 15:44:36 IST 1989

REMARKS = MANAGER PROJECTS <<===>> as Remarks index = 5 , => MANAGER PROJECTS

----------------------------

FIRSTNAME = MOHAN <<===>> as FirstName index = 1 , => MOHAN

LASTNAME = RAO <<===>> as LastName index = 2 , => RAO

SALARY = 20000 <<===>> as Salary index = 3 , => 20000

DOB = 1989-01-10 15:44:36.0 <<===>> as DOB index = 4 , => Tue Jan 10 15:44:36 IST 1989

REMARKS = SOLARIS ADMIN <<===>> as Remarks index = 5 , => SOLARIS ADMIN

----------------------------

                ==  END ==

SOA Vs API Management

API management is concerned with managing external APIs where consumers are unknown. SOA Governance, on the other hand, is about managing services with known consumers.

SOA and API management are the same but different approach.  SOA has its reusability and loose coupling, web based access values, but it may not suitable for every enterprise.  SOA work will maintain its worth because it is always amenable to use in the newer Web technologies, for both development and integration.  API Management is about connecting different parts of a hybrid IT infrastructure including social, mobile and cloud.

o   API Management solution needs to integrate with SOA (at least Enterprise Service Bus) for sharing the metadata about the available enterprise data.

o   APIs are created as business approach to reach new markets with BYOD model, where are SOA is to reach web customers.

o   APIs provide SOA with a way to reach beyond the controlled environment of the enterprise, while SOA provides APIs with acceleration and proven design principles.

o   Defining a strategy for how to merge SOA and API management will be important(long term) to the enterprises.

o   So, we can say that both have close relation and both help customers for business agility. 

Comparisons

API Management	SOA Services
API Management is natural extension of SOA.  All API are services, but not all APIs are good services.	A set of components which can be invoked, and whose interface descriptions can be published and discovered.
API management is concerned with managing external APIs where consumers are unknown	SOA Governance, on the other hand, is about managing services with known consumers.
Web APIs more truly reflect the nature of the Web	SOA reflects the nature of  Web services
More suitable for cloud, mobile, big data platforms to involve external world to innovate new ideas.	More suitable within the enterprise integration
API management enables enterprise services through channels and new forms of innovative products and services.	A business centric architectural approach.
The API security model says ‘good old SSL is good enough.	Security is handles with high standards at the message lever in a complex way.
Its more on REST and JSON services	Its standards based and mostly on SAOP
In a lot of ways, you can think of it as the web for machine-to-machine communication	Its machine-to-machine and machine-to-people as well
Doesn’t require you to sit down and install special infrastructure or libraries to do machine-to-machine communication	Needs special software
Designed for reuse by many apps platforms.  API provides	Designed to reuse in standards basis over the web/connectors

Enabling SOA Integration with ISG

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides a customer-focused robust communication and integration infrastructure between an external system and ISG for inbound and outbound communication that does not require a special class of middleware software.  This will not only save license costs but also reduce maintenance costs as the existing EBS system support team can maintain the infrastructure easily. This infrastructure not only enables greater and effective business integration with standard SOA concept between heterogeneous applications, but also facilitates the development and execution of complex business processes into highly flexible and reusable Web services. With this standardized and interoperable Web service platform, ISG provides a powerful framework that accelerates publishing of custom PL/SQL procedures as web services over the Web.

Integration Architecture

ISG Integrations require some configurations and customizations to enable the functionality in the ISG module.  The functionality would be written in PL/SQL procedures and then enabled as a web service.  The Outbound calls are made using the Service Invocation Framework (SIF) of EBS, which internally uses built-in Business Events for initiating the transaction or web service call.  Organizations would not need to hire new resources to develop this functionality as Apps technical resources possessing PL/SQL skills can easily deploy this functionality. This helps the firm in saving recruitment and resource management costs.  This cross-industry integration can be performed on EBS versions R12.1 and above. 

Implementation Steps

Here is a detailed illustration of web services implementation and calling web services from EBS.  Oracle E-Business Suite (R12.1.3) must be installed and ready to use for Integrated SOA Gateway (ISG) setup and implementation.  This implementation requires some setup configuration and development of several components for Inbound and Outbound as given below:

Inbound

1.    ISG Setup

a.    Enable ASADMIN user

b.    Create ISGUSER

2.    Write a Custom PL/SQL procedure

3.    Write the annotation into Procedure

4.    Generate and Upload the ILDT file

5.    View the Published Custom Web Service developed

6.    Monitoring SOA Requests

Outbound

1.    Run SQL script for Security Parameters to Support UsernameToken based WS-Security WSSE password   (If the external services are WSSE enabled only)

2.    Creating Business Events

3.    Creating Invoke Web Service Subscriptions

4.    Creating Error Notification Subscriptions

5.    Creating Call back event Subscriptions in PL/SQL

6.    Testing the Setup (Don’t DO in the production environments)

7.    Resubmitting Failed Business Events

Note: For detailed implementations details contact me.

How to get the element name in BPEL of a XML using the XPath

Use the expression as follows will work out to get the element name from the variable of message type.

local-name(bpws:getVariableData('Receive_InputVariable',   'body',   '/ns2:OrderElement/*[$VariableIndex]'))   will returns the element name.

Here  "VariableIndex"  is an integer variable which tell the array index of the element you need get the name.