Innovation + Product Development

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 […]

The JIRA has been a powerful and useful tracking tool for most agile projects. It is being evolved to provide more convenient features onward. In past half year I and my team just worked on a TM1 project where we managed and tracked all requirements, tasks and efforts in JIRA tool between multiple teams. TM1 […]

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 […]

Duplicate records are occasionally found in source data. Due to primary key constraints on a target database, only one version of a duplicate source record should be loaded into the target. The following methods demonstrate some of the most efficient ways to deal with duplicate source data. 1. Aggregator Transformation When to use Any time […]

We have been using a number of database management system (DBMS) such as SQL Server, DB2, and Oracle, but probably we don’t care about how the data is stored and organized in disk. Actually most of popular DBMS are built upon the row-oriented structure which stores its content by row; while today’s DB market, column-oriented […]

Problem: Following error occurs when a Common Table Expression (WITH) has been used as SQL override, when connecting to SQL database: RR_4035 : SQL Error [Microsoft OLE DB Provider for SQL Server: Statement(s) could not be prepared. SQL State: 42000 Native Error: 8180 State: 1 Severity: 16 SQL Server Message: Statement(s) could not be prepared. Microsoft OLE DB Provider for SQL […]

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 […]

Let’s see what Data Driven testing is? “It is an automation framework where test input and/or output values are read from data files. The different data files may include ODBC sources, csv files, Excel files, ADO objects, etc. The data is then loaded into variables in recorded or manually coded scripts.” Now let’s take an […]

 As we know, in MSSQL, we could set column identity property as yes to get incremental value, and we could also use sql function RowNumber() to get this. But in SSIS, there is no RowNumber() function, and setting column identity property is also not very flexible, and here is another way that using script to […]

In Sitecore, the MVC framework provides a “default” model type that does some very necessary work. To support the view, Sitecore’s default model type Sitecore.Mvc.Presentation.RenderingModel provides you access to The “current” item – passed via a datasource or the context item if no datasource is used The PageContext item (which may be different if a […]

Enabling persistent object mapping is a relatively straight-forward process. It differs from transient object mapping in only a few ways: libRKCoreData.a must be linked into your target Apple’s CoreData.framework must be linked to your target A Data Model Resource must be added to your target and configured within Xcode The RestKit Core Data headers must […]

“A Test Automation framework is a set of assumptions, concepts and tools that provide support for automated software testing”. So why do we need Automation framework. Can’t we just record the steps of any test case using the automation tool and playback whenever we want to execute the testcase? The answer is ‘NO’. Let’s see the Record/Playback Myth. […]