Steve's Blog Technical Information on Oracle Middleware.

In Jdeveloper 11.1.1.1.0, when I am running my web application I am frequently left with the following error from the integrated server:

<Warning> <Socket> <BEA-000449> <Closing socket as no data read from it during the configured idle timeout of 5 secs>

This is because I sometimes have multiple browsers/windows open of same application connections due to stopping and start the server each time opens a new window. Closing down all browsers/windows related to the application connection can avoid the problem.

When deploying a simple ADF application to standalone oc4j for the first time I get this error:

09/07/06 14:11:10 WARNING: DeployerRunnable.run NoClassDefFoundErrororacle.oc4j.admin.internal.DeployerException: NoClassDefFoundError
at oracle.oc4j.admin.internal.DeployerBase.execute(DeployerBase.java:134)
at oracle.oc4j.admin.jmx.server.mbeans.deploy.OC4JDeployerRunnable.doRun(OC4JDeployerRunnable.java:52)
at oracle.oc4j.admin.jmx.server.mbeans.deploy.DeployerRunnable.run(DeployerRunnable.java:81)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NoClassDefFoundError: oracle/jbo/JboException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2357)
at java.lang.Class.getConstructor0(Class.java:2671)
at java.lang.Class.newInstance0(Class.java:321)
at java.lang.Class.newInstance(Class.java:303)
at com.sun.faces.config.ConfigureListener.configure(ConfigureListener.java:731)
at com.sun.faces.config.ConfigureListener.configure(ConfigureListener.java:418)
at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:348)
at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1141)
at com.evermind.server.http.HttpApplication.(HttpApplication.java:741)
at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:414)
at com.evermind.server.Application.getHttpApplication(Application.java:570)
at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1987)
at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.(HttpSite.java:1906)
at com.evermind.server.http.HttpSite.addHttpApplication(HttpSite.java:1603)
at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:238)
at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:99)
at oracle.oc4j.admin.internal.ApplicationDeployer.bindWebApp(ApplicationDeployer.java:547)
at oracle.oc4j.admin.internal.ApplicationDeployer.doDeploy(ApplicationDeployer.java:202)
at oracle.oc4j.admin.internal.DeployerBase.execute(DeployerBase.java:93)
... 4 more

In this example I installed log4j as a shared library to my oc4j instance and then deploy my application from Jdev that utilises this library.

First Download log4j from

http://jakarta.apache.org/log4j/docs/download.html

Deploying log4j as shared library.

1. Unzip the downloaded log4j file.

2. In OAS ASC, select your oc4j instance -> Administration. Under Administration Tasks -> Properties and select Shared Libraries.



3. In Shared Libraries click Create.



4. Enter the library name/version

Shared Library Name = log4j
Shared Library Version = 1.0



5. Select the jar to load into the library.




6. Click finish and see the loaded library.



In Jdev, create a simple web application servlet that uses log4j.



7. My servlet looks like:

package project1;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;


public class Log4jDemoInOAS extends HttpServlet {
    private static final String CONTENT_TYPE = 
        "text/html; charset=windows-1252";
    Logger log = Logger.getLogger("Log4jDemoInOAS.class");

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
        String prefix = getServletContext().getRealPath("/");
        String file = getInitParameter("log4j-prop-file");
        if (file != null) {
            PropertyConfigurator.configure(prefix + file);
        }

    }

    public void doGet(HttpServletRequest request, 
                      HttpServletResponse response) throws ServletException, 
                                                           IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head><title>Log4j Demo In OAS</title></head>");
        out.println("<body>");
        out.println("<h2>Using log4j shared libraries in OAS Demo</h2>");
        System.out.println("=== Log4jDemo ===");
        log.debug("== DEBUG Message ==");
        log.info("== INFO Message ==");
        log.warn("== WARN Message ==");
        log.error("== ERROR Message ==");
        log.fatal("== FATAL Message ==");        
        out.close();
    }
}

   ...
   <imported-shared-libraries>
      <import-shared-library name="log4j"></import-shared-library>
   </imported-shared-libraries>
   ...

An example of deploying an application to a single OC4J instance through the command line.

You can deploy an application using the admin_client.jar from the command line. Either locally or remotely. If you want to deploy from remotely, you will first need to download the Administration Client. Ensure you download the same client version as your OAS version.

10.1.3.0

http://download.oracle.com/otn/java/oc4j/1013/oc4j_admin_client_101300.zip

10.1.3.1

http://download.oracle.com/otn/java/oc4j/101310/oc4j_admin_client_101310.zip

10.1.3.2

http://download.oracle.com/otn/java/oc4j/101320/oc4j_admin_client_101320.zip

10.1.3.3 & 10.1.3.4

http://www.oracle.com/technology/software/products/ias/htdocs/utilsoft.html

In this example I will only deploy locally. Further details can be found here:
http://download-west.oracle.com/docs/cd/B32110_01/web.1013/b28951/adminclient.htm#BABFHIEB

1. Check the instance I want to deploy to is up and running.

[sracanov@sracanov-au D]$ opmnctl status

Processes in Instance: web.sracanov-au.au.oracle.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:OC4J_Apps2    |    4296 | Alive
OC4JGroup:default_group          | OC4J:home          |    2308 | Alive
HTTP_Server                      | HTTP_Server        |    2732 | Alive
ASG                              | ASG                |     N/A | Down

[sracanov@sracanov-au D]$ opmnctl status -port
sracanov-au:6007

[sracanov@sracanov-au D]$ cd %ORACLE_HOME%\j2ee\home

[sracanov@sracanov-au D]$ pwd
D:\Oracle\product\10.1.3.2.0\OracleAS_1\j2ee\home

[sracanov@sracanov-au D]$ dir | grep admin_
11/01/2007  06:53 PM               733 admin_client.jar

[sracanov@sracanov-au D]$ echo %JAVA_HOME%
D:\Oracle\product\10.1.3.2.0\OracleAS_1\jdk

[sracanov@sracanov-au D]$ java -version
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode)

[sracanov@sracanov-au D]$ java -jar admin_client.jar deployer:oc4j:opmn://localhost:6007/OC4J_Apps2
oc4jadmin welcome1 -deploy -file C:\drvtest.ear -deploymentName drvtest -bindAllWebApps
09/05/13 13:23:14 Notification ==>Application Deployer for drvtest STARTS.

09/05/13 13:23:14 Notification ==>Copy the archive to D:\Oracle\product\10.1.3.2.0
\OracleAS_1\j2ee\OC4J_Apps2\applications\drvtest.ear

09/05/13 13:23:14 Notification ==>Initialize D:\Oracle\product\10.1.3.2.0\OracleAS_1
\j2ee\OC4J_Apps2\applications\drvtest.ear begins...

09/05/13 13:23:14 Notification ==>Unpacking drvtest.ear

09/05/13 13:23:14 Notification ==>Done unpacking drvtest.ear

09/05/13 13:23:14 Notification ==>Unpacking drvtest.war

09/05/13 13:23:14 Notification ==>Done unpacking drvtest.war

09/05/13 13:23:14 Notification ==>Initialize D:\Oracle\product\10.1.3.2.0\OracleAS_1
\j2ee\OC4J_Apps2\applications\drvtest.ear ends...

09/05/13 13:23:14 Notification ==>Starting application : drvtest

09/05/13 13:23:14 Notification ==>Initializing ClassLoader(s)

09/05/13 13:23:14 Notification ==>Initializing EJB container

09/05/13 13:23:14 Notification ==>Loading connector(s)

09/05/13 13:23:14 Notification ==>Starting up resource adapters

09/05/13 13:23:14 Notification ==>Initializing EJB sessions

09/05/13 13:23:14 Notification ==>Committing ClassLoader(s)

09/05/13 13:23:14 Notification ==>Initialize drvtest begins...

09/05/13 13:23:14 Notification ==>Initialize drvtest ends...

09/05/13 13:23:14 Notification ==>Started application : drvtest

09/05/13 13:23:14 Notification ==>Binding web application(s) to site default-web-site begins...

09/05/13 13:23:14 Notification ==>Binding drvtest web-module for application drvtest 
to site default-web-site under context root drvtest

09/05/13 13:23:17 Notification ==>Initializing Servlet: 
org.apache.struts.action.ActionServlet for web application drvtest

09/05/13 13:23:17 Notification ==>Binding web application(s) to site 
default-web-site ends...

09/05/13 13:23:17 Notification ==>Application Deployer for drvtest COMPLETES. 
Operation time: 3328 msecs

[sracanov@sracanov-au D]$ opmnctl status -app

Applications in Instance: web.sracanov-au.au.oracle.com

application type: OC4J
-----+-----------+---------+---------+----------------+----------+--------
pid  | name      | state   | rtid    | classification | routable | parent
-----+-----------+---------+---------+----------------+----------+--------
4296 | drvtest   | started | g_rt_id | external       | true     | default
4296 | system    | started | g_rt_id | external       | true     |
4296 | default   | started | g_rt_id | external       | true     | system
4296 | jamagent  | started | g_rt_id | external       | true     | default
4296 | ascontrol | stopped | g_rt_id | external       | false    |
4296 | datatags  | started | g_rt_id | internal       | true     | default
4296 | javasso   | stopped | g_rt_id | internal       | true     |
2308 | system    | started | g_rt_id | external       | true     |
2308 | default   | started | g_rt_id | external       | true     | system
2308 | ascontrol | started | g_rt_id | external       | true     | system
2308 | datatags  | started | g_rt_id | internal       | true     | default
2308 | javasso   | stopped | g_rt_id | internal       | true     |

JDev 11g offers a simple way to export an ADF table to excel in a couple simple steps.

1. Create af:panelCollection on the jspx page.
2. Drag a data control onto af:panelCollection and drop it as table.
3. Set af:table id to table.
4. Expand Panel Collection facets, and drop af:toolbar on toolbar facet.
5. Drop af:commandButton on af:toolbar. Set the text to "Export To Excel"
6. Drop af:exportCollectionActionListener on af:commandButton. And set the following:

ExportId: table
Type: excelHTML
Filename: Emp.xls
Title: Employees.

The exportId needs to bind to the af:table id. Which we set as 'table' in step 3

7. Run the jspx page and test the export button.


This is how the my final code looks like:

<panelCollection>
  <facet name="menus"/>
  <facet name="toolbar">
    <toolbar>
      <commandButton text="Export To Excel">
        <exportCollectionActionListener exportedId="table" type="excelHTML"
                                        filename="Emp.xls" title="Employees"/>
      </commandButton>
    </toolbar>
  </facet>
  <facet name="statusbar"/>
  <table value="#{bindings.EmpView1.collectionModel}" var="row"
         rows="#{bindings.EmpView1.rangeSize}"
         emptyText="#{bindings.EmpView1.viewable ? 'No rows yet.' : 'Access Denied.'}"
         fetchSize="#{bindings.EmpView1.rangeSize}" filterVisible="false"
         id="table">
    <column sortProperty="Empno" sortable="false"
            headerText="#{bindings.EmpView1.hints.Empno.label}"
            filterable="false">
      <outputText value="#{row.Empno}">
        <convertNumber groupingUsed="false"
                       pattern="#{bindings.EmpView1.hints.Empno.format}"/>
      </outputText>
    </column>
    ...
    ...
    ...
  </table>
</panelCollection>

With Jdev 11g, after generating a Web Service from a java class, the WSDL contains the following 
parameter names:

...
<xsd:complexType name="sayHello">
  <xsd:sequence>
     <xsd:element name="arg0" type="xsd:string"/>
     <xsd:element name="arg1" type="xsd:string"/>
  </xsd:sequence>
</xsd:complexType>
...

My java code function looks like:
...
public String sayHello(String firstname, String lastname) {
  return "Hello " + firstname + " " + lastname;
}
...

With Jdev 10g , the same code generates the appropriate values:
...
<xsd:complexType name="sayHello">
  <xsd:sequence>
     <xsd:element name="firstname" type="xsd:string"/>
     <xsd:element name="lastname" type="xsd:string"/>
  </xsd:sequence>
</xsd:complexType>
...

To workaround this in 11g, I need to create my java class as follows:

package project1;

import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebService;

@WebService
public class Class1 {
    @WebMethod
    public String sayHello(@WebParam(name = "fname") String firstname,
                           @WebParam(name = "lname") String lastname) {
        return "Hello " + firstname + " " + lastname;
    }
}

And now my generated WSDL looks like:
...
<xsd:complexType name="sayHello">
  <xsd:sequence>
     <xsd:element name="fname" type="xsd:string"/>
     <xsd:element name="lname" type="xsd:string"/>
  </xsd:sequence>
</xsd:complexType>
...

http://java.sun.com/javaee/5/docs/api/javax/jws/WebParam.html

After running jpub using the 'get joke' web service and then calling the web service in sqlplus, I get the following error:

[sracanov@sracanov-au D]$ jpub -user=scott/tiger -sysuser=sys/welcome1
-proxywsdl=getjoke.asmx.xml 
-endpoint=http://interpressfact.net/webservices/getjoke.asmx
tmp\src\genproxy\GetJokeSoapClientJPub.java
plsql_wrapper.sql
plsql_dropper.sql
plsql_grant.sql
plsql_revoke.sql
Executing plsql_dropper.sql
Executing plsql_wrapper.sql
Executing plsql_grant.sql
Loading plsql_proxy.jar

[sracanov@sracanov-au D]$ sqlplus scott/tiger
Logging into sqlplus - scott @orcl

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 25 14:06:32 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

scott@orcl> select jpub_plsql_wrapper.getjoke('') from dual;
select jpub_plsql_wrapper.getjoke('') from dual
                                           *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.RemoteException: java.rmi.RemoteException:; nested exception is:
HTTP transport error: javax.xml.soap.SOAPException:
java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message
send failed: Connection refused

[sracanov@sracanov-au D]$ jpub -user=scott/tiger -sysuser=sys/welcome1 
-proxywsdl=http://interpressfact.net/webservices/getjoke.asmx?WSDL 
-endpoint=http://interpressfact.net/webservices/getjoke.asmx 
-httpproxy=www-proxy:8080
tmp\src\genproxy\GetJokeSoapClientJPub.java
plsql_wrapper.sql
plsql_dropper.sql
plsql_grant.sql
plsql_revoke.sql
Executing plsql_dropper.sql
Executing plsql_wrapper.sql
Executing plsql_grant.sql
Loading plsql_proxy.jar

[sracanov@sracanov-au D]$ sqlplus scott/tiger
Logging into sqlplus - scott @orcl

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 25 14:02:50 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

scott@orcl> select jpub_plsql_wrapper.getjoke('') from dual;

JPUB_PLSQL_WRAPPER.GETJOKE('')
--------------------------------------------------------------------------------
Q: How many `Real Men' does it take to change a light bulb?
A: None:  `Real Men' aren't afraid of the dark.