It seems like the IBM tools (Rational Software Architect & Rational Application Developer) aren’t very good at communicating with an Oracle database. I’m in the ‘Data’ view, attempting to create a stored procedure. When I ‘CREATE’ the procedure, I was getting warnings but no message about what the warning/error actually was. I fought with the tool for a little while before giving up and installing Oracle SQL Developer which immediately showed me the error.

It turns out my errors were due to syntax.

Update: I just wanted to add that I was also unable to see any of my stored procedures in the database explorer view.

Related Posts

• Oracle SOA Suite 11g - Hello Competition!
• CWSIP0311E: A user is not authorized to delete a durable subscription

When attempting to start an ear after application install on WebSphere v6.1, the following exception occurred:

[28/03/08 9:50:46:673 EST] 00000028 MBeanHelper   E   Could not 
invoke an operation on object:
WebSphere:name=ApplicationManager,process=server1,
platform=dynamicproxy,
node=txuxu-was007Node01,version=6.1.0.15,
type=ApplicationManager,mbeanIdentifier=ApplicationManager,
cell=was007Node01Cell,spec=1.0 because
of an mbean exception:
com.ibm.ws.exception.RuntimeWarning:
javax.resource.ResourceException: CWSIV0900E:
The exception
 com.ibm.wsspi.sib.core.exception.SINotAuthorizedException:
CWSIP0311E: A user  is not
authorized to delete a durable
subscription SUBNAME##SUBID on
destination Default.Topic.Space. was thrown w
hile attempting to
create a listener for destination
Default.Topic.Space on
bus SomeBus using
connection com.ibm.ws.sib.processor.impl.ConnectionImpl@86eef6.

Naturally I turn to google and see that the exception is of format:

CWSIP0311E: A user {0} is not authorized to delete a durable subscription {1} on destination {2}.

Now, it’s probably very hard to see on the internet, but there are two spaces between the words ‘user’ and ‘is’ in the CWSIP0311E: message. This extra space told me that the Authentication Alias used in the EAR was set to a single blank and not ‘null’. We asked the developer to check the field in the deployment descriptor and sure enough, the field was a single space.

We remove the space, re-generated the ear and deployment to our secured server was successful.

It would have reduced our problem determination time is IBM would mandate that all variable values in an exception were surrounded by quotes.

Related Posts

• Tip: WebSphere Process Server - Do not delete the ‘tranlog’ on a production server
• WMVare - Shrink the Dynamic Disk To Retain Performance
• WAS: Resolution to Messages in the SIB locked forever
• BPEL: Beware the use of nested loops in a short running process
• The Support Authority: A systematic approach to problem solving

As I’m sure you can tell, I’m very WebSphere focused. I have a hard enough time keeping up with the zillion WebSphere branded products that get released throughout the year. On my random surfing of the internet (tyvm Technorati) , I turned up Oracle’s entry into the world of SOA: Oracle SOA Suite 11g.

The interesting bit about this product is that it runs in direct competition with WebSphere Integration Developer. It uses the SCA runtime (I assume it’s Apache Tuscany), supports BPEL, Business Rules and even AJAX based Human Task forms. Pretty much the key features that WebSphere Integration Developer lists.

I don’t really know much about the product other than the marketing information found on the oracle site, but I’m all for competition in the marketplace.

The Oracle Assembly diagram:

Pretty much what I would expect to see. Exports on one side, business components in the middle and Imports on the other side. I wonder if Oracle resolved the weirdness in terminology of the “Export” starting your process while the “Import” calls other processes. Most people get confused with that right off the bat.

I also have to laugh at Oracles name for the WPS Failed Event Manager: “Error Hospital”. It’s in quotes in the presentation, so it’s likely it’ll get marketized into something better (and non-infringing on IBM’s FEM).

Oracle also has a “Large Document Handler” which is interesting. Today, most app servers are pretty bad at handling lage industry standard schema’s so it’s good to see Oracle address this up-front rather than trying to tack it on later.

Of course, everything always works without issue in PowerPoint so I’m interested to see how it works in the real world.

Related Posts

• Integrating Oracle BPEL with an HTTP (REST) Service
• Configuring IBM WebSphere Process Server V6.1 with an Oracle Database
• IBM Software Support Lifecycle - General Availability, End Of Marketing, End of Support Dates
• Oracle DBMS_CRYPTO Encryption
• WebSphere DataPower vs WebSphere Enterprise Service Bus