Friday, February 27, 2015

Collection of ADF Programmatic Functions

In this post I write some functions you can use those functions in your ADF application.

Get Viewobject attribute datatype programmatic

This function accept 2 parameters (iterator name, attribute name) and will return the data type of this attribute


Get Viewobject attribute Database Column Name

This function accept 2 parameters (iterator name, attribute name) and will return the database column name which map to the viewobject attribute



Clear Table Filters

If you want to clear table filters programmatically sent table component to this function



Reset af:query fields

If you want to reset af:query sent query component to this function



Show error message on adf component

Sometime you need to remove required property from af:inputText because it may cause some problems and in the same time you need to display error message on the inputText component so you can use the following function just send the error message and the adf component


Sort Table Column Programmatically

If you want to sort column programmatic you can use the following function just send table component and attribute which you would like to sort and the boolean parameter (true for ascending sort and false for descending sort)



Reset Table Sort

After sorting in column and need to reset the sorting you can use the following function just send table component and the iterator name (which the table point to) 


Call database sequence

When you want to get next value from database sequence you can use the following function just send database sequence name and it will return the next value of the sequence



Set Focus to component

If you want to set focus to component( as set cursor to inputText) just send component id to this function (if inputText id =it1 and you use page template with id=pt1 so the id which you have to send to this function is pt1:it1)

Monday, January 5, 2015

Oracle BPM: Display User BPM Tasks Inside ADF Application (Post2)

In my previous post we see how you can display user BPM worklist inside ADF application, but there is one question now, how the bpm worklist know the user which suppose to display his tasks?

You should generate object of IWorkflowContext  using login user information (username and password). To do this follow these steps:

1- In ViewController project add 2 libraries (oracle.bpm.bpm-services.client.jar and oracle.bpm.bpm-services.interface.jar) you can find these jars in (C:\Oracle\Middleware\Oracle_SOA1\soa\modules\oracle.bpm.client_11.1.1)

2- In you ADF application make new class "BPMContextClass.java"


 ////////// BPMContextClass.java ////////////

import java.util.HashMap;
import java.util.Map;
import oracle.bpel.services.bpm.common.IBPMContext;
import oracle.bpel.services.workflow.client.IWorkflowServiceClient;
import oracle.bpel.services.workflow.client.IWorkflowServiceClientConstants;
import oracle.bpel.services.workflow.client.WorkflowServiceClientFactory;
import oracle.bpm.client.BPMServiceClientFactory;
import oracle.bpm.services.client.IBPMServiceClient;

public class BPMContextClass
{
  private static String url = "t3://localhost:7001"; // BPM serverIp:port

  public static BPMServiceClientFactory getBPMServiceClientFactory()
  {
    Map properties = new HashMap();
    properties.put(IWorkflowServiceClientConstants.CONNECTION_PROPERTY.CLIENT_TYPE, WorkflowServiceClientFactory.REMOTE_CLIENT);
    properties.put(IWorkflowServiceClientConstants.CONNECTION_PROPERTY.EJB_PROVIDER_URL, url);
    properties.put(IWorkflowServiceClientConstants.CONNECTION_PROPERTY.EJB_INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
    return BPMServiceClientFactory.getInstance(properties, null, null);
  }

  public static IBPMContext getIBPMContext(String username, String password) throws Exception
  {
    return getBPMServiceClientFactory().getBPMUserAuthenticationService().authenticate(username, password.toCharArray(), null);
  }

  public static IWorkflowServiceClient getIWorkflowServiceClient()
  {
    return getBPMServiceClientFactory().getWorkflowServiceClient();
  }

  public static IBPMServiceClient getBPMServiceClient()
  {
    return getBPMServiceClientFactory().getBPMServiceClient();
  }
}

/////////End BPMContextClass.java///////

3- Follow the previous post to make page display user worklist (e.x. userTasks.jspx).

4- From faces-config.xml make new global navigation rule and set  userTasks.jspx "From Outcome" to "userTasks"


5- Make new login page (login.jspx) as shown


6- In the login button action write this code

  public String loginAction()
  {
    FacesContext ctx = FacesContext.getCurrentInstance();
    HttpServletRequest request = (HttpServletRequest)ctx.getExternalContext().getRequest();
    String usernameValue = null;
    try
    {
      usernameValue = usernameInputText.getValue().toString();
      String passwordValue = passwordInputText.getValue().toString();
      Subject subject = Authentication.login(new URLCallbackHandler(usernameValue, passwordValue));
      weblogic.servlet.security.ServletAuthentication.runAs(subject, request);
      IWorkflowContext workflowContext = initBPMContext(usernameValue, passwordValue);
      setManagedBeanValue("sessionScope.workflowContext", workflowContext);
      IBPMContext ibpmContext = BPMContextClass.getIBPMContext(usernameValue, passwordValue);
      setManagedBeanValue("sessionScope.ibpmContext", ibpmContext);
    }
    catch (Exception e)
    {
      // TODO: Add catch code
      e.printStackTrace();
      return null;
    }
 
    return "userTasks";
  }

8- In the login backbean write this code (this code will be used by login button action "loginAction()")

  public IWorkflowContext initBPMContext(String userName, String password) throws WorkflowException
  {
    IWorkflowServiceClient wfSvcClient = WorkflowServiceClientFactory.getWorkflowServiceClient(WorkflowServiceClientFactory.REMOTE_CLIENT);
    ITaskQueryService querySvc = wfSvcClient.getTaskQueryService();
    IWorkflowContext ctx = querySvc.authenticate(userName, password.toCharArray(), null);
    return ctx;
  }

  public void setManagedBeanValue(String beanName, Object newValue)
  {
    StringBuffer buff = new StringBuffer("#{");
    buff.append(beanName);
    buff.append("}");
    setExpressionValue(buff.toString(), newValue);
  }

  public void setExpressionValue(String expression, Object newValue)
  {
    FacesContext facesContext = FacesContext.getCurrentInstance();
    Application app = facesContext.getApplication();
    ExpressionFactory elFactory = app.getExpressionFactory();
    ELContext elContext = facesContext.getELContext();
    ValueExpression valueExp = elFactory.createValueExpression(elContext, expression, Object.class);
    Class bindClass = valueExp.getType(elContext);
    if (bindClass.isPrimitive() || bindClass.isInstance(newValue))
    {
      valueExp.setValue(elContext, newValue);
    }
  }



7- deploy the application to SOA server and after login you will find user worklist.



You can download the sample application from here.

Tuesday, December 30, 2014

Oracle BPM: Display User BPM Tasks Inside ADF Application (Post 1)

If you need to display Oracle BPM worklist inside ADF page follow these steps:

1- Be sure ADF application is developed by JDev 11g R1.
2- In ADF project go to project properties --> Libraries and Classpath and add these libraries:

  * bpm-services.jar (\Middleware\jdeveloper\soa\modules\oracle.soa.workflow_11.1.1)
  * adflibTaskListTaskFlow.jar (\Middleware\jdeveloper\soa\modules\oracle.soa.worklist_11.1.1)
  * adflibWorklistComponents.jar (\Middleware\jdeveloper\soa\modules\oracle.soa.worklist_11.1.1)

  * WSRP Container
  * BPM Worklist Components
  * BPM Services





3- Make new .jspx page and from component palette select adflibTaskListTaskFlow.jar -->Regions.
4- Drag taskList-task-flow-definition from component palette and drop it in the .jspx page as region


5- From task flow parameters set these 2 parameters




6- In ADF application Add new deployment Descriptor weblogic-application.xml (in ADF project right click ---> new --> Deployment Descriptor -->  Weblogic Deployment Descriptor


7- From opening dialog select weblogic-application.xml


8- Open weblogic-application.xml and write 

    oracle.soa.workflow


9- Now you can run ADF application and after user login you have to generate IWorkflowContext with  username and password and the user will see his tasks. (In next post i will explain how to   generate IWorkflowContext).

Thursday, October 23, 2014

Dealing With Dates in Java

Many developers sometimes face a problems when they dealing with dates. In java there are many types of dates as:

- java.util.Date
- java.sql.Date
- java.sql.Timestamp
- oracle.jbo.domain.Date
- oracle.jbo.domain.Timestamp

ADF developers sometimes need to:

- Get current date (oracle.jbo.domain.Date or  oracle.jbo.domain.Timestamp) to set attribute in ViewObject programmatically .

- Convert between dates types.

- Add/Subtract some days from date.

- Display current date on the screen (as string) in specific format.

- Display name of current day in this week (Saturday - Sunday - ...... - Friday).

- Get current time.

- Get current day.

- Get current month.

- Get current year.

- Compare between two dates.

- Get the number of days difference between two dates.

All these previous functions developers need to know so, I made a set of functions to help developers to deal with dates.

  /** function return current date time in format (dd / MM / yyyy - HH:mm:ss) */
  public static String getDisplayedDateTime()
  {
    Calendar cal = Calendar.getInstance();
    String dateFormat = "dd / MM / yyyy - HH:mm:ss";
    SimpleDateFormat sdf = new SimpleDateFormat(dateFormat);
    return sdf.format(cal.getTime());
  }

  /** function return current date or time depending on the format which you are want. Just send a format and the function will return the current date or time depending on the 
      format which you are sent (e.g. getDisplayedDateFormat("yyyy-mm-dd") it will return 2013-11-18 */
  public static String getDisplayedDateFormat(String dateFormat)
  {
    Calendar cal = Calendar.getInstance();
    SimpleDateFormat sdf = new SimpleDateFormat(dateFormat);
    return sdf.format(cal.getTime());
  }

  /** function return the index of current day in this week (if today is Sunday it will retun 1 and if the today is Monday this function will return 2 and so on... 
      till Saturday it will return 7) */
  public static int getCurrentDayOfWeek()
  {
    Calendar cal = Calendar.getInstance();
    return cal.get(Calendar.DAY_OF_WEEK);
  }

  /** function return the name of current day in this week (Saturday - Sunday - ...... - Friday) */
  public static String getCurrentDayOfWeekName()
  {
    int numberOfDay = getCurrentDayOfWeek();
    if(numberOfDay == 7)
    {
      return "Saturday";
    }
    else if(numberOfDay == 1)
    {
      return "Sunday";
    }
    else if(numberOfDay == 2)
    {
      return "Monday";
    }
    else if(numberOfDay == 3)
    {
      return "Tuesday";
    }
    else if(numberOfDay == 4)
    {
      return "Wednesday";
    }
    else if(numberOfDay == 5)
    {
      return "Thursday";
    }
    return "Friday";
  }

  /** function return current day. ( e.g. today is 2013/11/18 this function will return 18) */
  public static int getCurrentDay()
  {
    Calendar cal = Calendar.getInstance();
    return cal.get(Calendar.DAY_OF_MONTH);
  }

  /** function return current month. ( e.g. today is 2013/11/18 this function will return 11) */
  public static int getCurrentMonth()
  {
    Calendar cal = Calendar.getInstance();
    return cal.get(Calendar.MONTH) + 1;
  }

  /** function return current year. ( e.g. today is 2013/11/18 this function will return 2013) */
  public static int getCurrentYear()
  {
    Calendar cal = Calendar.getInstance();
    return cal.get(Calendar.YEAR);
  }

  /** function will return current date as an oracle Date object */
  public static oracle.jbo.domain.Date getCurrentOracleDate()
  {
    return new oracle.jbo.domain.Date(oracle.jbo.domain.Date.getCurrentDate());
  }

  /** function will return current date and time as an oracle Date object */
  public static oracle.jbo.domain.Date getCurrentOracleDateTime()
  {
    return new oracle.jbo.domain.Date(new java.sql.Timestamp(System.currentTimeMillis()));
  }

  /** function will return current date and time as an oracle Timestamp object */
  public static oracle.jbo.domain.Timestamp getCurrentOracleTimestampDateTime()
  {
    return new oracle.jbo.domain.Timestamp(new java.util.Date().getTime());
  }

  /** function will return current time */
  public static String getCurrentTime()
  {
    return  getDisplayedDateFormat("HH:mm");
  }

  /** function receive oracle date and return true or false (if sent date greater than current date it will return true 
      but if sent date less than or equal current date it will return false */
  public static boolean isDateGreaterThanCurrentDate(oracle.jbo.domain.Date d)
  {
    if(d == null)
      return false;
 
    oracle.jbo.domain.Date currentDate = new oracle.jbo.domain.Date(oracle.jbo.domain.Date.getCurrentDate());
    if(d.compareTo(currentDate) > 0)
      return true;
 
    return false;
  }

  /** function receive two oracle dates and return true or false (if first date greater than second date it will return true 
      but if first date less than or equal second date it will return false */
  public static boolean isFirstDateGreaterThanSecondDate(oracle.jbo.domain.Date d1, oracle.jbo.domain.Date d2)
  {
    if(d1 == null && d2 == null)
      return false;
 
    if(d1 == null && d2 != null)
      return false;
 
    if(d1 != null && d2 == null)
      return true;
 
    if(d1.compareTo(d2) > 0)
      return true;
 
    return false;
  }

  /** function receive three oracle dates and return true or false (if first date greater than or equal second date and first date less than or equal third date it will return true. 
      otherwise it will return false */
  public static boolean isFirstDateBetweenTwoDates(oracle.jbo.domain.Date d1, oracle.jbo.domain.Date d2, oracle.jbo.domain.Date d3)
  {
    if(d1 == null || d2 == null || d3 == null)
      return false;
 
    if(d1.compareTo(d2) >= 0 && d1.compareTo(d3) <= 0)
      return true;
 
    return false;
  }

  /** function receive date and integer then add the integer to the date then return the result date.
      (e.g. if you send 2013/07/13 and 5 to this function the function will return 2013/07/18 */
  public static Date addDayToOracleDate(oracle.jbo.domain.Date date, int days)
  {
    if (date != null)
    {
      Calendar c1 = Calendar.getInstance();
      c1.setTime(date.getValue());
      c1.add(Calendar.DATE, days);
      java.util.Date javaUtilDate = c1.getTime();
      long javaMilliseconds = javaUtilDate.getTime();
      java.sql.Date javaSqlDate = new java.sql.Date(javaMilliseconds);
      return new oracle.jbo.domain.Date(javaSqlDate);
    }
    return null;
  }

  /** function receive two oracle dates then return the number of days difference between them. (e.g. if you send 2013/07/20 , 2013/07/13 to the function the function will return 7 */
  public static long getDifferenceDaysBetweenTwoDates(oracle.jbo.domain.Date d1, oracle.jbo.domain.Date d2)
  {
    if(d1 != null && d2 != null)
    {
      return (d1.getValue().getTime() - d2.getValue().getTime())/(24 * 60 * 60 * 1000);
    }
    return 0;
  }

  /** function receive oracle date and convert it to java.util date then return java.util date */
  public static java.util.Date convertOracleDateToJavaUtilDate(oracle.jbo.domain.Date oracleDate)
  {
    if(oracleDate == null)
      return null;
 
    java.sql.Date javaSqlDate = oracleDate.dateValue();
    long javaMilliSeconds = javaSqlDate.getTime();
    return new java.util.Date(javaMilliSeconds);
  }

  /** function receive oracle date and convert it to java.sql date then return java.sql date */
  public static java.sql.Date convertOracleDateToJavaSqlDate(oracle.jbo.domain.Date oracleDate)
  {
    if(oracleDate == null)
      return null;
 
    return oracleDate.dateValue();
  }

  /** function receive java.util date and convert it to oracle date then return oracle date */
  public static Date convertJavaUtilDateToOracleDate(java.util.Date javaUtilDate)
  {
    if(javaUtilDate == null)
      return null;
 
    long javaMilliseconds = javaUtilDate.getTime();
    java.sql.Date javaSqlDate = new java.sql.Date(javaMilliseconds);
    return new oracle.jbo.domain.Date(javaSqlDate);
  }

  /** function receive java.sql date and convert it to oracle date then return oracle date */
  public static Date convertJavaSqlDateToOracleDate(java.sql.Date javaSqlDate)
  {
    if(javaSqlDate == null)
      return null;
 
    return new oracle.jbo.domain.Date(javaSqlDate);
  }

  /** function receive java.util date and convert it to java.sql date then return java.sql date */
  public static java.sql.Date convertJavaUtilDateToJavaSqlDate(java.util.Date javaUtilDate)
  {
    if(javaUtilDate == null)
      return null;
 
    long javaMilliseconds = javaUtilDate.getTime();
    return new java.sql.Date(javaMilliseconds);
  }

  /** function receive java.sql date and convert it to java.util date then return java.util date */
  public static java.util.Date convertJavaSqlDateToJavaUtilDate(java.sql.Date javaSqlDate)
  {
    if(javaSqlDate == null)
      return null;
 
    long javaMilliseconds = javaSqlDate.getTime();
    return new java.util.Date(javaMilliseconds);
  }

Thursday, June 5, 2014

Deploy ADF Application Using Side-by-Side Deployment

This technique is used for deploying applications with versions. In first time you deploy application it will take version1. If you make some changes of that application and you want to re-deploy it again, side-by-side deployment manage you to re-deploy application without losing the connection to the application.
assume you deploy application with version1 and some of user connect to the application and you want to redeploy the application with version2, the connection user still connect to version1 but every user close the connection and reconnect to the application again it will connect to the version2.
After all user connect to version2 and no one connect to version1 the application of version1 status will become "Retail" at this moment you can delete version1.

Note : 
- Side-by side deployment allow you to make only two versions. It means you should delete old version before you make new version.(for example: you deploy application with version1 and you redeploy it with version2, if you want to redeploy it with version3 you should first delete version1).

- Deploying application will done from command prompt not from console.

To deploy ADF Application:
1- Open cmd and go to the admin domain folder and set domain environment as shown


   2-.     write this (you should changes the bold words )
D:\Oracle\Middleware\user_projects\domains\modamoDomain>java weblogic.Deployer -adminurl t3://localhost:7001 -user weblogic -password weblogic1 -deploy -name myEar -source D:\Deploy\myEar.ear -targets MyServer -stage -appversion 1.0


localhost:7001 ---> admin domain address and admin domain port
weblogic ---> username of the admin weblogic server
weblogic1 ---> password of the admin weblogic server
myEar ---> name of the application which will display in the console.
D:\Deploy\ttEar.ear --> location of the ear file (you should write the full path of the location of the ear).
MyServer ---> Name of the server which you will deploy the application in. if you want to deploy the application in the cluster type the name of the cluster.
1.0 ---> version number of the application which will appear beside the application on the console.


Now you can open the console and you will find your application deployed.

To re-deploy the application:
1- Open cmd and go to the admin domain folder and set domain environment as in picture



2-  write this (you should changes the bold words )
java weblogic.Deployer -adminurl t3://localhost:7001 -user weblogic -password weblogic1 -redeploy -name myEar -source D:\Deploy\myEar.ear -targets MyServer -appversion 1.1


Wednesday, May 7, 2014

Apply SSL (Https) To Weblogic Managed Server

This post will help you to apply ssl (https) protocol to managed server, I made a document explain how to do that.

you can download this document from this link

http://www.mediafire.com/view/9i4xc0ag5k1474a/ApplySSL.doc

Wednesday, April 23, 2014

Deploy ADF Application To Glassfish (Step-by-Step)

In this post I will explain how you can deploy ADF Application to Glassfish server.

I made a document file explain this in easy way (Step by Step) you can download this file from this link

http://www.mediafire.com/view/riy5xt56cga0yh0/Deploy_ADF_Application_To_Glassfish.doc

Tuesday, April 22, 2014

Apply Patches To Weblogic (Step-by-Step)

If you want to deploy ADF Application developed using JDeveloper 11.1.2.x.x you should apply patches to the weblogic (10.3.6).

after applying patches to weblogic (10.3.6) you can deploy any ADF Application (11.1.1.x.x or 11.1.2.x.x).

I uploaded a documentations step by step to do that.

http://www.mediafire.com/view/sdugiufsc9wv79a/Apply_Patches_To_Weblogic.doc


You can download Patches from

http://www.mediafire.com/download/j17e214j0b4rnfr/WLPatchesFor2.3.rar

this patches suitable for applications developed using JDeveloper 11.1.2.3.0 or JDeveloper 11.1.2.4.0

Setup and configure weblogic environment (Step-by-Step)

In this post I will explain how to setup and configure weblogic for deploying ADF Applications. I made a documentation explain how to setup and configure weblogic in easy way step by step.

You can download this document from this URL:

http://www.mediafire.com/view/nozijs14a9cst1e/Steps_to_Establish_Weblogic_Environment.doc

Note :After you finish weblogic setup and configuration you can deploy only ADF Applications which is developed using JDeveloper 11.1.1.x.x.

If you want to deploy ADF Applications developed using JDeveloper 11.1.2.x.x. you should apply patches to the weblogic.

To know how to apply batches to weblogic refer to this post

http://sameh-nassar.blogspot.ie/2014/04/apply-patches-to-weblogic.html




Tuesday, December 3, 2013

Easy Way To Clear ADF Table Columns Filters

In ADF table you can enable column filters just when you drag viewobject to the page and choose Table --> ADF Table
Just select Enable Filtering
Now when you run the page you will find inputtext above every cloumn in the table
You can filter the data using these inputtext above every cloumn. If you want to clear all the filters inputtext just add new cloumn to the table (put it as a first column)




 Select the new cloumn and from Property Inspector (Appearance section) set Width to "14" and RowHeader to "true"

Now run the page again you will find new icon above first column when you press this icon it will clear all columns filters and re-execute the view object query.