Migrate to groovy 1.5.7

If you want to migrate to groovy 1.5.7, do not forget to update your antlr to 2.7.6

That was short, but essential :)

See you soon

JDeveloper on a Mac

In order to provide more information on using Groovy with Oracle Data integrator and moreover with Oracle Products, I installed on a Mac the 10 g version of JDeveloper

If you intend to work with the embeded OC4J, the first tip will be to check if the Tools->Start WebCenter Preconfigured OC4J is working.

You may encounter the following error:

Error# Can not find java executable in /System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home/../bin.

This is easy to correct.
Choose Tools->External Tools



Then Edit Start WebCenter Preconfigured OC4J


Remove the dots after "Home"


Repeat the same with the "Stop WebCenter Preconfigured OC4J" tool and you are set for OC4J.

Next time I'll try to show you interaction between Groovy and OC4J ;)

Some good news

If this blog seems to be quiet, this doesn't mean that nothing is moving ;)

As a first good news, Oracle Data Integrator has modified the BSF component used in the latest 10.1.3.4.2 patchset.

This result in a muuuuch easier process to use groovy in ODI.
To be short:

- ODI has now BSF in its core, no more bsf.jar in oracledi/lib/scripting
- BSF has been upgraded: this means that the language.properties already contains groovy reference

The complete process is now:

1) copy groovy-1.0.jar, antlr-2.7.5.jar, asm-2.2.jar and commons-logging-1.0.4.jar in oracledi/lib/scripting (I will update my groovy as soon as possible to see if nothing breaks)

2) launch Topology on your repository.
All you have to do is create a technology with only one thing in mind : the code must be GROOVY (uppercase is mandatory)

That's all !!!
Someone has to tell this to ODI Product Management ;)

groovy and ODI

You like Groovy ?
you like Oracle Data Integrator ?

How about using both ?

Let's say you installed ODI in C:\Program Files\ODI\
In oracledi\lib you will find the file sunopsis.zip

Extract the file org\apache\bsf\Languages.properties from the zip.
Add the following line :

groovy = org.codehaus.groovy.bsf.GroovyEngine, groovy|gy

Then, put the file back in the zip, replacing the existing Languages.properties file.

Next, copy groovy-1.0.jar, antlr-2.7.5.jar, asm-2.2.jar and commons-logging-1.0.4.jar
This was the version I had on my machine, others may fit.
I have downloaded mine through the groovy zip distribution.

The last step needs you to launch Topology.
All you have to do is create a technology with 2 parameters:
- the code must be GROOVY (uppercase)
- the technology type is set to 'Bean Scripting Framework'



As you see, you have to write the same word as in Languages.properties in uppercase.

Now you're done, you are able to use Groovy as a script language.

To test this, launch a designer from a shell, using the command :

designer.bat --CONSOLE

Create a project.
Insert a procedure.
Insert a new command in the details, use 'groovy' technology created in topology.
Use a simple groovy command like :

print 'groovy is working !'

If you execute this procedure, you will see a nice 'groovy is working !' message in your shell.

That's all folks !