webforms

Searching in source-code in Designer-repository

Especially for those who loves Designer, or who are forced to work with it.. :-( ,  2 scripts to search in de source-code of Designer (version 10.1.2.4):

Script 1 can be used for searching text-strings in the source of pl/sql in Designer.
Script 2 can be used to search for the use of column-names in modules.

Run this as the owner of the repository.

With thanks to Timo Schijf,  developer.

Script1 : Searching in  pl-sql code

set feedback off
set pages 50000
set lines 300
set trimspool on
set verify off

break on modulename skip 1

select name “Workareas:”
from sdd_workareas
;

prompt
prompt
accept workarea_name default ‘GLOBAL SHARED WORKAREA’ char prompt ‘Name of Workarea [Default: GLOBAL SHARED WORKAREA] : ‘

prompt
prompt
accept searchstring char prompt ‘Text-string : ‘

begin
jr_context.set_workarea (’&&workarea_name’);
end;
/

select distinct name “Applications in this workarea:”
from ci_application_systems
;

By |August 14th, 2009|Categories: Database|Tags: , , |0 Comments

The curious case of the left-handed mouse in webforms

In OAS (10.1.2.0.2), 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 in moving screens with the mouse.

Oracle states that this is a bug (note 196844.1, bug 2200274), in Jinitiator (we are using 1.3.1.22)
Just to be sure, I installed Jinitator 1.3.1.30:  same behaviour.

Solutions
1 Install  Sun Java (5.0.6)  instead of  Jinitiator. This definitely works. Wrote another post on this matter to use Sun instead of Jinitiator.
2 Update of the (Microsoft Intellipoint) mouse-driver. Did not work for us. Problems with the mouse-driver in our environment
3 Oracle work-around in the note: use a right-handed mouse… => no comment.
4 Use the keyboard for that part of the functionality. We got unexpected results from this. At first it seems to be working, but the results didn’t match the results when we use the (right-handed) mouse. Also you have to program the ‘focus’ of the mouse or cursor in that case.

As there is no support for Jinitiator anymore, and the Intellipoint didn’t do what we expected, we’ve chosen for nr 1.

Sources:

Note: 274100.1 – Left Hand Mouse Does Not Expand Tree Node In Oracle Forms

Note: 760250.1Diagnosing Forms Mouse Focus Problems Using JRE in Release 11i

Note: 290807.1 - Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i

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

Signing jar-files

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:  sign_webutil.sh? With a few adjustments it’s a quite common, usable script.

Below is the script. In bold the variables which you need to adjust. Beware of the different paths for ‘keytool’ / ‘jarsigner’ !

#!/bin/sh
#
# sign_jar.sh
#
# Copyright (c) 2002, 2004, Oracle. All rights reserved.
#
#   NAME
#      sign_jar.sh – Sample script to sign jar-files
#   USAGE
#      sign_jar.sh <jar_file>
#      jar_file : Path of the jar file to be signed. Prefer to use forward
#                 slash instead of back-slash. Otherwise, some characters may
#                 be strangely escaped. e.g. \f may be printed as ‘female’
#                 symbol character on some systems.
#   NOTES
#      This script uses keytool and jarsigner utilities, which usually comes
#      along with JDK in its bin directory. These two utilities must be
#      available in the PATH for this script to work. Otherwise, signing
#      will fail even though the script may show a successful signing.
#
# The following are the Distinguished Names for keytool. You can change them
# to generate your own key.
# CN = Common Name
# OU = Organization Unit
# O  = Organization
# C  = Country code
#
# Certificate settings:
# These are used to generate the initial signing certificate
# Change them to suite your organisation
#
DN_CN=”Example Firm”
DN_OU=”Development Tools”
DN_O=Mydomain
DN_C=nl

#
# Give your keystore file
KEYSTORE=/home/oracle/dba/key/.keystore
#
# If KEYSTORE already exists, old KEYSTORE_PASSWORD for the keystore file must
# be correctly given here. If KEYSTORE does not already exist, any password
# given here will be taken for the new KEYSTORE file to be created.
#
KEYSTORE_PASSWORD=<keystore_passw>
#
# Give your alias key here.
#
JAR_KEY=<app_name>
#
# Key Password for the given key to be used for signing.
#
JAR_KEY_PASSWORD=<file_passw>
#
# Number of days before this certificate expires
#
VALIDDAYS=360

#
# Signing script starts here…
#
if test $# -lt 1
then
echo Jar file name not given for signing. Use
echo “$0 <jar-file>”
exit 1
elif test $# -ne 1
then
echo Incorrect parameters. Use
echo “$0 <jar-file>”
exit 1
fi

echo “Generating a self signing certificate for key=$JAR_KEY…”
error_text=`$ORACLE_HOME/jre/1.4.2/bin/keytool -genkey -dname “CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C” \
-alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \
-storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS`
# Check for any error
found=`echo “$error_text” | grep -c “already exists”`
isError=`echo “$error_text” | grep -c “error”`

if test $found -ne 0
then
# Let us show this as warning.
echo “Warning: $JAR_KEY already present in $KEYSTORE”
elif test $isError -ne 0
then
echo $error_text
else
echo “…successfully done.”
fi

echo “\n”
# Signing the jar
echo “Backing up $1 as $1.old…”
cp -f $1 $1.old
echo “\n”
echo “Signing $1 using key=$JAR_KEY…”
error_text=`$ORACLE_HOME/jdk/bin/jarsigner -keystore $KEYSTORE -storepass $KEYSTORE_PASSWORD -keypass $JAR_KEY_PASSWORD \
$1 $JAR_KEY`
# Check for any error
if test “$error_text” != “”
then
echo $error_text
echo “Signing $1 failed.”
else
echo “…successfully done.”
fi

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

Internet Explorer crashes with Oracle forms / Jinitiator

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  ;-)

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

Sun JRE instead of Jinitiator with Forms and Webutil

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 http://www.muangyacctv.com/download/JAVA but if you keep searching the Sun-website, you will find it here:

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProduct
Detail-Start?ProductRef=jre-1.5.0_06-oth-JPR@CDS-CDS_Developer

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):

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