Thursday, April 24, 2014

Unlocking HR Account in Oracle XE Database

In this post I will be showing the steps to how to unlock HR account in Oracle XE database. After some days, when you try to access HR schema, it says Account Locked. 

I always forget the steps in order to unlock the HR schema, so that's the reason I am writing this simple post.

Open command prompt and enter the command as follows :

sqlplus / as sysdba

This will not ask password and will open the SQL plus prompt.

Tuesday, April 22, 2014

Consuming SOAP Service without creating/using RequestVO/ResponseVO on Client Side

Many times in ADF/Webcenter implementation projects, consuming SOAP services is one of the requirement. Web Services are consumed in ADF by creating Web Service Data Control or by generating proxys.

Some of the services expect very few input parameters may be 2-4 but most of the Web Services expect more parameters. For services which expect more number of parameters, most of the times, all the input variables are a part of RequestVO POJO object. Since this RequestVO is required to provide input to the WebService, the structure with attributes of POJO or VO expected by the service needs to be shared to the client making the request.

For example, in this post we will be taking a simple example of EmployeeService.

Friday, April 4, 2014

Too Many Open Files Exception while running application on Unix

While working on client side and running Webcenter portal application on the Unix System, we saw exception stating : error = 24 , Too Many Open Files.

Caused by: java.io.IOException: java.io.IOException: error=24, Too many open files
    at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
    at java.lang.ProcessImpl.start(ProcessImpl.java:65)
    at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
    ... 40 more