Feeds:
Posts
Comments

Posts Tagged ‘SOA’

Using DB Dynamic Parameter – Pure SQL Operation

Posted in Adapters, Bpel, DB Adapter, tagged , , , , , , , , , , on August 1, 2012| 2 Comments »

DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.

(more…)

Read Full Post »

Internal Exception: java.sql.SQLException: ORA-00911: invalid character

Posted in Adapters, DB Adapter, tagged , , , , , , , , , , on July 8, 2012| Leave a Comment »

I must say that I’ve predicted this error….
One of my customer’s requirements is to run a simple query on Oracle 10g Database.
I’ve developed a simple process in Bpel 10g that uses ‘select’ operation from a DbAdapter.
I ran the process from the BPELConsole,  and got the following error:

WSIF JCA Execute of operation ‘GetDataSelect’ failed due to: DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character
]
; nested exception is:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character

(more…)

Read Full Post »

How To Present HTML On Human Task’s ADF Form

Posted in Bpel, Human Task, tagged , , , , , , , , , on July 8, 2012| Leave a Comment »

In our last EDI project we had to use some Human Tasks and Web Forms for User’s interactions.
For one of the tasks, I had to pass from a bpel process (in the payload) a coded HTML to the ADF form.
On the first try it didn’t work.
After a short check, I found that in order to make it happen, I had to add an attribute (in the field output text) call escape with “false” value.
So, to show HTML on the ADF, just edit the line as follows:

<af:outputText escape=”false” value=”#{bindings.HTML_HEADER.inputValue}” id=”xx1″/>

 

That worked great.

Good Luck!

Read Full Post »

Save A Processed File On An Archive Directory

Posted in FTP Adapter, tagged , , , , , , , , on June 30, 2012| Leave a Comment »

Archiving a file when using FTP Adapter is very important. From some reason a file might be poled but not processed.
To overcome it, there is an option to save a backup file, after the file was polled.
When using FtpAdapter, you can choose to save a backup file on the remote FTP server, or on the local server.
In this post I will explain how to do it.

(more…)

Read Full Post »

Transaction Timed Out On 11g

Posted in Bpel, tagged , , , , , , , , , on June 24, 2012| Leave a Comment »

While running Bpel processes you might run into the following errors:

…

Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out

….

(more…)

Read Full Post »

WebLogic 10.3.6 Installation

Posted in Application Server, tagged , , , , , , on May 26, 2012| 2 Comments »

The Weblogic installed in this demo is ‘Oracle WebLogic Server + Coherence – Package Installer 10.3.6’ (32-bit JVM)

You can find Weblogic Installation here:
http://www.oracle.com/technetwork/middleware/weblogic/overview/index.html

Please follow the next steps in order to install the WebLogic Server:

(more…)

Read Full Post »

Repository Creation Utility (RCU) 11.1.1.6.0 Installation On Windows OS

Posted in Installation, RCU, tagged , , , , , , , , , on May 26, 2012| 29 Comments »

The RCU creates all the needed schemas required by the SOA Suite.
You can find RCU 11.1.1.6.0 installation here:
http://download.oracle.com/otn/nt/middleware/11g/111160/ofm_rcu_win_11.1.1.6.0_disk1_1of1.zip

More information about the RCU and schmeas creation:
http://docs.oracle.com/cd/E23943_01/doc.1111/e14259/rcu.htm#BABIDIBC

(more…)

Read Full Post »

Oracle SOA Suite 11gR1 installation

Posted in SOA Suite, tagged , , , , , , on May 26, 2012| 12 Comments »

After working many years with Oracle SOA Suite 10g/11g on Development & Production mode, I’ve decided to implement and install the last release – Oracle SOA Suite 11gR1 (11.1.1.6.0) on my local machine. I’m curious to see and test the new features Oracle posted on their release from February 2012 (http://www.oracle.com/technetwork/middleware/soasuite/documentation/default-1532821.html).

I must say that Oracle’s Documentations for the full installation are very comprehensible and clear.
To focus the installation into the main parts, I’ve posted this blog that describes, a step by step explanation and description about how to download & install Oracle SOA Suite 11gR1(11.1.1.6.0).

(more…)

Read Full Post »

Oracle Database Express Edition XE 10.2.0.1 Installation On Windows OS

Posted in DB, Installation, tagged , , , , , , , , on May 24, 2012| 1 Comment »

Oracle Database 11g Express Edition is free and can be download from here:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

Please follow the next steps in order to install the DB:

(more…)

Read Full Post »

How To Use Java Embedding Activity – Simple Example

Posted in Activities, Bpel, Java Embedded, tagged , , , , , , , , on May 17, 2012| Leave a Comment »

The following is a simple example of using Java Embedding Activity in Bpel 11g.
In this example, I used a simple asynch’ process, and assign the input parameter into the output parameter.
To implement this example you have to:

(more…)

Read Full Post »

« Newer Posts - Older Posts »