How firefox 3.6 accelerates the phasing out of Jinitiator (and frustrates Metalink..)

By | March 15th, 2010|Categories: App. Server|Tags: , , , |

The customer is using Firefox, 3.5 in this case, and Internet Explorer (6!). Suddenly the application does not work anymore for a lot of clients, as a matter of fact, the firefox-users. They had upgraded their Firefox to 3.6., and got the message that an add-on must me installed ( appears to be the JRE ) . After installing this, it still does not work.

Java-errors in – ORA-29516 and ORA-03113

By | October 19th, 2009|Categories: Database|Tags: , |

Why is it that java is crossing my path so much now and then... After a restore of a database on another node, including renaming him/her, java classes were invalid. Trying to create / replace them, errors popped up: ORA-29516: Aurora assertion failure: Assertion failure at eox.c:317 Uncaught exception Root of all Java exceptions: java.lang.NullPointerException

Sun JRE instead of Jinitiator: Discoverer

By | September 8th, 2009|Categories: App. Server|Tags: , , |

The whole company has to move in the end to Sun Java  instead of Jinitiator (also based on Sun Java by the way), so also the Discoverer – application.

Changed the client from Jinitatior 1.3.2 to Sun 5, update 6 (5.0.6).  You can download it here by the way.

As of this release you can no longer specify the exact JRE release. Only configure the ‘Family CLSID’.

Configure Discoverer, middle-tier:
1. cd $ORACLE_HOME/discoverer/config
2. backup configuration.xml
3. edit configuration.xml
4. comment out the original Sun JRE tag using the comment tags:
For example:
<!– <jvm name=”sun” classid=”clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA” plugin_setup=”http://biserver.domain:7779/jpi/j2re.exe” version=”1.4.2″ versionie=”1,4,2,mn” type=”application/x-java-applet” plugin_page=”” disco_archive=”disco5i.jarjar” d4o_archive=”d4o_double.jarjar”/> –>

5. Insert the new Sun JRE tag:
For example:
<jvm name=”sun” classid=”clsid:CAFEEFAC-0015-0000-FFFF-ABCDEFFEDCBA” plugin_setup=”http://biserver.domain:7779/jpi/jre5u16.exe” version=”1.5″ versionie=”1,5,0,mn” type=”application/x-java-applet” plugin_page=”” disco_archive=”disco5i.jarjar” d4o_archive=”d4o_double.jarjar”/>

Table of the Sun version versus the Family CLSID’s:

1.4.2     : clsid:CAFEEFAC-0014-0002-FFFF-ABCDEFFEDCBA
5.0        : clsid:CAFEEFAC-0015-0000-FFFF-ABCDEFFEDCBA
6.0        : clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA

Oracle quote ———>:

“The behavior will be as follows:

If the user does not have any JRE installed on the client PC, then the JRE installed be what you have configured with the plugin_setup parameter; therefore, we would recommend that you stage the latest minor version within the JRE family.

* For 1.5, it will be 1.5.0_16 (

This would require the Discoverer Administrator to:

* Download the latest jre family Windows executable you plan to use on the Windows clients
* copy or ftp (binary) the executable to the Discoverer middle-tier server at: $ORACLE_HOME/jpi/bin/
You may name it whatever you wish, for example: jre142u18.exe or jre150u16.exe
* Update the plugin_setup=”http://biserver.domain:7779/jpi/jre5u16.exe” (in the file configuration.xml), making sure the executable names match

”   <——— end of Oracle quote.


The curious case of the left-handed mouse in webforms

By | July 6th, 2009|Categories: App. Server|Tags: , , , |

In OAS (, webforms, when using a left-handed mouse to expand a menu, the tree node is not expanding. No error is given.
For example, in ‘Material Workbench’ select the ‘+’ to expand ‘Organizations’ in the menu.
Left and right button does not do anything.
Also, the left handed users are having difficulties […]

Creating PDF's with PL/SQL and itext

By | June 20th, 2009|Categories: Database|Tags: , , |

There are several ways to create PDF's, on the client (e.g. PDFCreator) or on the middletier. But to create PDF's merely with packages in the database, that's another story. Even Apex uses some Java on the middletier. The product PLPDF on the other hand is a well known utility which provides this functionality (using open-source 'itext'), but.. you have to pay for this. So why not do it ourselves with itext, open-source (answer: a lot of work and knowledge of Java...).

Discoverer Plus decreased interaction-performance with Sun JRE 1.6.0_03

By | May 10th, 2009|Categories: App. Server|Tags: , |

User reported a very slow interacting on his new laptop with Discoverer Plus.  Changing tabs, opening workbook wizard e.g. Other laptops / workstation had no problems.

He was the only one who had a ‘modern’ Java version on his laptop : above 1.6.   So it had to be Java.  And that […]

Signing jar-files

By | April 29th, 2009|Categories: App. Server|Tags: , , |

A project is using Sferyx in Webforms, and the file HTMLEditorLight.jar is used. But 'copy and paste' from outside the form to the editor is not working. Cause: the jar-file need to be signed. To sign a jar-file the tools 'keytool' and 'jarsigner' is needed. But... why not use a script from e.g. webutil: With a few adjustments it's a quite common, usable script.

Internet Explorer crashes with Oracle forms / Jinitiator

By | April 3rd, 2009|Categories: App. Server|Tags: , , |

Problem: when running form modules using Internet Explorer and JInitiator 1.3.1.x, the browser window opens and crashes immediately before the applet starts. When using Mozilla Firefox, there’s no problem at all.

Several notes on Metalink about this:  602001.1, 430359.1, 550301.1
The issue does not occur when using Sun JRE version 1.4, 1.5 and 1.6.

This issue is first logged as JInitiator Bug 5643502 – INTERNET EXPLORER WITH WINDOWS LIVE TOOLBAR PLUG-IN CRASHES, but based on Sun Bug 4741238, the bug occurs in JRE version 1.3 (JInitiator is based on JRE 1.3) and the bug is fixed in JRE versions 1.4 and higher.

Solution according the notes
To avoid the crash,
(1) Use Sun JRE 1.4 and higher
– OR –
(2) Uninstall Windows Live Toolbar (or other software what you suspect is the cause)
– OR –
(3) Disable the toolbar’s associated Add-ons as the following:
1. Open Internet Explorer
2. From the menu open Tools -> Manage Add-ons -> Enable or Disable Add-ons
3. Select the following Add-ons and disable each of them by clicking the “Disable” button

– Windows Live Sign-In Helper
– Windows Live Toolbar
– Windows Live Toolbar Helper
– Windows Messenger
4. Restart Internet Explorer
– OR –
(4) Disable 3rd-party browser extensions as follows:
– From the browser menu Tools -> Internet Options -> Advanced
– Uncheck “Enable third-party browser extensions”

First I chose for the last option, the policy was changed by the Windows system administrators for all the clients in the network, and done.. But there were (un)expected side-affects, like a particular SSO-application could’nt be reached anymore. People didn’t appreciate this  😉


Sun JRE instead of Jinitiator with Forms and Webutil

By | January 26th, 2009|Categories: App. Server|Tags: , , , , |

Running Forms and Webutil with Sun Java 5.0.6 instead of Jinitiator.

And you know what:  it’s faster and has more functionality I’ve been told…
First you need the java-file. In this case: jre15006.exe.

Initially I found it hard to find on the site of Sun – didn’t even know the name of the file I was looking for…
Found it at but if you keep searching the Sun-website, you will find it here:

Then: where shall I put the file? The application server expects the file in /forms/jinitiator.
In forms.conf this is defined as:
AliasMatch ^/forms/jinitiator/(..*) “/software/oracle/middle/jinit/$1”

Next thing is the configuration in formsweb.cfg (at the end of this post is the configuration what worked for me,
but first some explanation, quoted from some notes):