Deciding where to use BPEL vs ESB

AshokTechnical TipsLeave a Comment

I just had a discussion with an M&S SOA Architect about the advantages and disadvantages of BPEL vs ESB, and more importantly, where to use which in practical business scenarios. This article is part of the recent work short blurb series.

Convert INT to BOOLEAN in a SQL SELECT for Multi-Tiered Sorting

john.kingTechnical Tips1 Comment

We have a family tree. Some people have children, while others do not. We want to sort results by alphabetically listing individuals with children in an initial group, and then those without children in a second group — also alphabetically. Let’s assume there is not an isParent column (nor the equivalent) on the table, but there is a way to determine how many children each individual has.

BPA 10.1.3.4 Windows Install with XE

kevin.landonTechnical TipsLeave a Comment

I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine. There were no inherent issues with the product itself, but some gotchas that I thought I might point out. For the following, I assumed you are installing on a single machine for testing/evaluation purposes like I was.

For one, if you were familiar with BPA 10.1.3.3, there is no longer an auto-installable olite database option. You must use Oracle XE Universal (or better) and you should have it installed locally prior to installing BPA. Note: You should use XE Universal specifically so you get the AL32UTF8 character set that is expected by the BPA install.

After I got the character set squared away, I continued to receive a database connection error

Oracle APEX – Returned, Reloaded, and Ready

kevin.landonIndustry TrendsLeave a Comment

It’s a well known and established fact that one of the only constants in life is change

It wasn’t that long ago (it seems) that I was asked to look at Oracle APEX and Oracle XE for work, and devise a tutorial for it’s installation and beginner use. It has been almost a year since then, and I find myself revisiting it after my last project. In that short amount of time there have been a few rather large changes. While Oracle XE is still at 10g, where it was originally, the APEX system itself has undergone 2 fairly large updates, going from the 3.0.1 version I orginally was working with to, 3.1, and now 3.2 being the current version.

Upgrading from 3.0.1 to 3.2 is supposed to be smooth, but we shall test and see for ourselves.

After all, if I can’t change with the times, the times won’t stop changing for me.