So you want to learn SQL. Not a problem. You want to learn Oracle SQL, not a problem. You have no knowledge of SQL, not a real problem. All you need is some patience, access to a computer and the internet, and a little bit a familiarity with how to use a computer.
Oracle BPEL – Wait Activity Stuck or Hanging – Never Returns to Console
This is a very, very common complaint I hear from Oracle BPEL developers, testers, and production support.
I find there are a couple reasons that this can happen:
1. The flow has faulted sometime after the wait activity, but never…
domain.log File Growing Fast – Filesystem Full
Are you running out of disk space because your domain.log is growing too fast? Open BPEL_HOME/domains//config/log4j-config.xml Change the appender class from com.collaxa.cube.util.CXRollingFileAppender to org.apache.log4j.RollingFileAppender Add a new parameter: 1 <param value="50MB" name="MaxFileSize" /><param value="50MB" name="MaxFileSize" /> Here is an example of what the file should look like in the end: 1 2 3 4 5 6 7 <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender class="org.apache.log4j.RollingFileAppender" name="A1"> <param value="true" name="ImmediateFlush" /> <param value="false" name="Append" /> <param value="D:/soa/product/10.1.3.1/as_1/bpel/domains/default/logs/domain.log" name="File" /> <param value="50MB" name="MaxFileSize" /> <param value="10? name="MaxBackupIndex" /><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender class="org.apache.log4j.RollingFileAppender" name="A1"> <param value="true" name="ImmediateFlush" /> <param value="false" name="Append" /> <param value="D:/soa/product/10.1.3.1/as_1/bpel/domains/default/logs/domain.log" name="File" /> <param value="50MB" … Read More
Microsoft CRM 3.0 – Hide Links in Left Navigation – Example Code
Here is an example of code to get stripped down contact and account forms. This code is placed in the onLoad event of the respective forms. Note: this is not supported, but a common way to hide left navigation links on specific entities (since normal site map customization does not affect these).
Oracle XE and APEX: Initial Impressions
It seems that Oracle has seen a need for, and developed a product for the entry level business that doesn’t require a huge investment in hardware or software knowledge. This is Oracle APEX, or APplication EXpress. At first glance it seems to be a streamlined melding of other Oracle products (I can see bits of Application Server and Portal in it) It requires much less knowledge of PL/SQL or Oracle Architecture to build applications, which makes it ideal, doubly for getting people into using Oracle Products. The better part is it will work with any Oracle Database install version after 9.2 without issue, including a little gem called XE.
Oracle Database Express Edition (currently version 10g) is a wonderful little setup. Designed for…
HTML – Writing An Oracle Install Guide with Screenshots
I was handed a task to build an install guide from the higher ups. They asked for clear instructions, documented steps and screenshots to go with it all. I was already looking forward to it.
Conditionally Purge BPEL Instances on 10.1.3.x
Marc Kelderman wrote a helpful article on this topic: http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html One of the users there notes: Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date. Trying to do something more elaborate we have noticed that if you use the script in this article as a basis then rows in xml_document table are not removed. We have written code to conditionally purge BPEL instances in a sophisticated manner, taking into account custom logic, scheduling, and performance for multiple customers in SOA/BPEL versions 10.1.2 and 10.1.3.x. … Read More
Oracle BAM – SQL to List Users and Roles
I don’t really like what Oracle did with BAM user/roles and authentication. I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a look at your users and their roles as BAM understands them: 1 2 3 4 SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur WHERE iur."UserID" = iu."SysIterID" ORDER BY iu."SysIterName"SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur … Read More