Owen Wang

Blogs from this Author

Maven Build Failure – Unknown packaging: content-package

If you are running a Maven application, in some cases, you may encounter an “Unknown packaging:content-package” issue when you try to build the app. We can’t determine the reason based on this error description. I will guide you through a method for determining the possible root cause and a related solution for this issue step […]

Email Notification failed in BPEL global transaction

Scenario: Sometimes BPEL application need to send out the email alert to let people know what’s the detail error information, then people can analysis the root cause. But if your sync bpel application got an error and bpel throw the exception in Error Handler, it will cause the global transaction rollback, so email will not […]

Omit WS-Address of header in BPEL

Scenario: Sometimes bpel application need to invoke the web service, due to some reasons, some web service can not handle the extra header information, but BPEL application send the message with WS-Address by default.  When BPEL application invoke the web service, it send the message with WS-Address header by default, if web service can not […]

Transaction usage in Oracle Service Bus

Scenario: As we all know transaction concept in DB means several operations commit together, one step failed, it will roll back all the changes in DB. So this kind of technology could be used in Oracle Service Bus too.  OSB service has request pipeline and response pipeline, When an OSB  proxy service consume a file […]

Unlock user accounts in Oracle weblogic

Scenario:  Sometimes people may input the wrong password several times, that will cause user locked by weblogic console, even reset password for this specific user in Admin console, still doesn’t work. So we need to unlock this user in Oracle weblogic console. Solution: Login to Oracle weblogic Admin console with other user account, click Lock & […]

OSB JCA file adapter cannot consume messages with UTF-16 schema

Scenario: There is a requirement that need to consume file message from a file location, but the message schema for consume file was using UTF-16 encoding. Generate the JCA adapter in Jdeveloper with a UTF-16 xsd schema defined at the last step, then you will get a wsdl associate with this xsd schema, then import […]

PL/SQL inserts a long XML string to DB table

You want to insert an XML payload record in DB table, but the content for that column is too long and you can’t insert it into table. The traditional SQL: “insert into table (field1) values (‘yourxml’)” will fail because of the long characters. How do you handle this situation? Scenario:  client requires to insert a XSLT/XQuery […]

Easily Import MQ Adapter into the Oracle Service Bus

Scenario: At the first installation of the Fusion middle ware, the MQ transport protocol will not be included in the Oracle Service Bus. If you want to import a OSB project(jar file) which contains the MQ transport configuration, you will get the error, “Transport provider with id ‘mq’ is not registered.”

General Introduction of oracle business rules

Oracle Business Rules is a high performance lightweight business rules product that addresses the requirements for agility, business control, and transparency. It is part of the Fusion Middleware stack and integrates seamlessly across the entire Oracle SOA Suite and BPM Suite stack. It is also a core component for present and future Oracle Fusion Middleware […]

Insert a long XML string to DB table with PL/SQL

You want to insert an XML payload record in DB table, but the content for that column is too long and you can’t insert it into table. The traditional SQL: “insert into table (field1) values (‘yourxml’)” will fail because of the long characters. How do you handle this situation? Scenario:  client requires to insert a XSLT/XQuery […]

Exposed two interface for Oracle BPEL application

Sometimes, OSB call BPEL application need to use SOA-direct protocol. But while you use this protocol, you can’t debug and test your BPEL application in the enterprise manager (EM), because direct binding interface disabled the “Test” button in the EM. Can we use SOA-direct protocol for OSB call to BPEL and also debug the BPEL […]

Oracle Service Bus Proxy Service listening on the Database table

Author   Owen Wang   SR. Engineer Case Scenario: If one of the DB record is updated, insert or delete in DB table, applications need to capture these changes and send request message to notify the back end application. Most of people know how to listen on a database table in the BPEL, because BPEL has a […]