Feeds:
Posts
Comments

Posts Tagged ‘bpel’

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 »

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 »

How to See Messages Printed On Java Embedding Activity In EM

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

When the Java Embedding activity is being used, you sometimes want to print a message that will be displayed in EM.

To do so, use the following expression (inside the Java Embedding Activity):

addAuditTrailEntry(“TEST 123” );

The printed message will be shown in the process flow.

 

 

 

Read Full Post »

‘Auto Recovery’ – faulted instances

Posted in Enterprise Manager, tagged , , , , , , , , , on April 25, 2012| 4 Comments »

When running a bpel processes, you can sometimes end up with a fault state.
Later on, from “unknown reason” you see the faulted process being initiate again, and being run from the beginning.

(more…)

Read Full Post »

« Newer Posts