Oracle ESB 10.1.3 Tips

When you create a new “System” from ESB console, it was given a name such as “System0”. It took me a while to figure out how to change the name. You can *actually* click the name (i.e. System0) on the page and change it. Good hiding, Oracle.

A new 10.1.3.3 feature allows you to debatch XML files. Setting up XML debatching requires you to download and configure the XML pull-parsing library(StaX).

1. Download the API (jsr173_1.0_api.jar) and RI (jsr173_1.0_ri.jar) from the following location:

http://jcp.org/aboutJava/communityprocess/final/jsr173/index.html

You must go to the section for “Reference Implementations” and select from the available reference implementations.

2. Copy the two jar files to SOA_ORACLE_HOME\bpel\lib.

3. Register both jar files in server.xml (available under SOA_ORACLE_HOME\j2ee\MID_TIER\config) under the oracle.bpel.common shared library.

<shared-library name="oracle.bpel.common" version="10.1.3">
<code-source path="C:\product\bpel\lib\jsr173_1.0_api.jar"/> 
<code-source path="C:\product\bpel\lib\jsr173_1.0_ri.jar"/>
</shared-library>

* Add to classpath
SOA_ORACLE_HOME\integration\esb\lib\bpm-services.jar
SOA_ORACLE_HOME\integration\esb\lib\xsu12.jar
SOA_ORACLE_HOME\integration\esb\lib\orabpel.jar
* Add namespace to xsl:stylesheet:

<xsl:stylesheet version="1.0"
      xmlns:orcl="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"

* Create sequence in Oracle database:

CREATE SEQUENCE MY_SEQ
 START WITH     1
 INCREMENT BY   1
 ORDER
 NOCYCLE;

* Use orcl:sequence-next-val() function:

<xsl:variable name="seqno" 
  select="orcl:sequence-next-val('MY_SEQ','jdbc:oracle:thin:scott/tiger@localhost:1521:ORCL')"/>
<xsl:value-of select="$seqno" />