How to run SQL code against an Oracle databse

Context: ILINX Capture, ILINX Release and Oracle IPM 11g

Problem: A customer wanted the ability to run some custom SQL code against an Oracle database after a doc has been released to Oracle IPM 11g.

Solution: Place the built-in DatabaseLookup IXM after Release and use the return value from Release to call Oracle. Below is a screen shot of the workflow:

phong

Phong Hoang
Development Manager
ImageSource, Inc.

Adventures with IPM 11g continued (Part 2)

I thought it would be simple. Take the very first example from the Oracle examples for IPM 11g, compile it, and start adding my own code. This is my standard way to learn a new API (and probably yours, too). Start with the examples and keep adding functions to exercise features.

Well, I followed the instructions provided with the example programs (basically copy down some Jar files and put them on your classpath), and while the program compiles fine, I get a NoClassDefFoundError, which is common enough in Java when you use dynamic loading (Class.forName was something I used quite a bit in the old days).

However, the class it can;t find is weblogic.xml.jaxp.RegistryParser which should be in one of the Weblogic jar files; but I cannot find it. Oracle tech support also can’t locate it. I am waiting to hear back from their 2nd line support. Is it really that hard?

Anybody else out there used the examples?

 

 

Adventures with Oracle IPM 11g (part 1)

Part 1

Oracle starting shipping its latest IPM product, 11g earlier this quarter. As a company, ImageSource has been working as a partner with Oracle on this next step in their ECM evolution. I, personally, am a little late to the 11g game, so I will be sharing with you my impressions as a relative newcomer to the 11g world.

Continue reading