I have seen multiple custom solutions and packaged applications store their SQL outside of stored procedures. I am focusing this article on custom enterprise solutions, which I feel is one of the fastest growing areas in development. Some people who choose to store SQL outside of their database have touted database independence/abstraction, others easier maintenance, and I’m sure many other “excuses” have been communicated. In my opinion, if you have 1) a custom enterprise application and 2) an Oracle database(s) as the backend, all of your SQL — and associated DB logic — should be written, stored, maintained, etc. within … Read More
OID Install in Oracle Enterprise Linux (OEL) 5 – Shared Libraries Error
When installing 10g OID on OEL5, if you run into the following error, you can run the below commands to address the issue: Error: OPMN HTTP process fails to start. When you look in the log file, it says: /Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory To fix, run the following commands: # ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2 # chmod 755 /usr/lib/libgdbm.so.2.0.0 # chmod 755 /usr/lib/libdb.so.2
Visual Studio 2008 (VS2008) – Common Keyboard Shortcuts
When I did a quick search online, I found some keyboard shortcuts for Visual Studio 2008 that didn’t work for me, so thought I would get a post going. Comment and Uncomment Code Blocks Quickly I comment blocks of code in VS2008 with: CTRL-E, C …and I uncomment blocks of code with: CRTL-E, U
BPEL Not Good For Rapid Changes
I am excited about BPEL’s proliferation. But for some organizations (specifically, IT shops), BPEL is being used in areas it is simple not well-suited. For example, some places where IT has gotten ahead of the business, it is used as a process modeling tool. True, BPEL “represents” a process, it is my opinion that proper business modeling tools be used prior to orchestration being defined in BPEL. Another scenario I continue to find is that people are using BPEL for just about every piece of logic that goes into a business process being executed. The fact is, BPEL does very … Read More
Google Apps Reporting API – Not quite this easy with Exchange
I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail, calendaring, contacts, and more. I have been one of those people. However, I have found Google Apps to be getting better and better for use in the enterprise and I will not be surprised to see it begin to take significantly larger chunk of market share from Microsoft over time.
Modular Flex Development – Multiple SWFs
I have been tasked with coming up with a modularized approach for logically separating out an extensive Flex application I am developing. I see Flex 3.4 might have some features I can take advantage of.
Google Custom Search Engine (CSE)
The site search game is changing with Google CSE.
Complete Fusion Middleware 11g environment setup
We have recently been working on and completed an entire Oracle Fusion Middleware 11g environment setup for a customer: Identity Management WebCenter (Framework and Services) SOA Suite UCM This article is part of the recent work short blurb series.