Applications with SQL Maintained Outside of Stored Procedures

AshokTechnical TipsLeave a Comment

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

amit.guptaTechnical TipsLeave a Comment

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

BPEL Not Good For Rapid Changes

AshokIndustry Trends, Technical Tips1 Comment

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

AshokIndustry Trends, Technical TipsLeave a Comment

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.