Automatic continuous compilation of webforms on linux/unix Oracle Headquarters Redwood Shores1 e1698667100526

Automatic continuous compilation of webforms on linux/unix

Automatic continuous compilation of webforms on linux without X-terminal

In the webforms world you it is not uncommon to compile a webforms application on a linux/unix application server, after you’ve build a forms module on your Window development environment. Modules compiled on Windows typically will not run on another operating system, so the binaries must be deployed (i.e. by ftp) to the applicaiton server where they are compiled.

These tasks can be quite a burden if you imagine that every time a module is changed by a developer he/she has to ftp it to an application server, compile it and optionally copy the executable to a directory on the FORMS_PATH. Extra software must be installed on the desktop: an FTP client and optionally, X-terminal software to be able to compile the module in a grafical user interface. On the operating level the developer(s) should be known users on the application server. Finally, the developer(s) should be able to understand some unix/linux commands.

There is an easier way, however! Automatic, continous compilation. The goal is to maximize ease while minimizing the effort for both developers and administrators to deploy new/changed webforms modules to a linux based application server.This can be set up as described here.

The way we generally work at Amis is that all sources are maintained by a versioning system like CVS or subversion. The CVS or subversion client software is also installed on the application server. When a developer finishes developing on a forms module (or library module, menu module, etc), he/she checks-in the module into the versioning system.
And here ends the cycle for the developer (remember minimize ease)!

The application server picks up all changes from the version system via a shell-script scheduled in the crontab. It’s scheduled to run every 10 minutes, but the scheduling can be changed to any required value. The scheduled script is run as oracle-user because on our system the oracle-user is the only user privileged to run oracle software on the iAS. An example is show below.

# Crontab job script for compilation webforms applications
# parameter 1: conn = Oracle connectstring (scott/tiger@orcl)
# parameter 2: os_user = username application owner (each application has os_user as owner)
. /etc/profile
cd /home/$os_user
svn update
/home/$os_user/bin/ $conn $os_user

The compile script that is called obviously compiles all new or changed modules in batch-mode using Then, finally the executables are moved to the FORMS_PATH path. The FORMS_PATH is set in the proper environment file on $MIDTIER_HOME/forms/server.
Using over is crucial if you want to ommit X-terminal. By using crontab we are unable to use X-terminal applications.

An excerpt of the compile script is shown below.

#  Compile recent (< 10 minuten) changes in application
echo Set Oracle environment
export ORACLE_SID=midtier
. oraenv

export TERM=vt220

# copy sources to build directory (code left out)

echo Compilation OFG-library modules ...
for i in `find $PAGONI_HOME/build/ofg*.pll -mmin -10`
  echo Compiling Library $i ....
  $ORACLE_HOME/bin/ userid=$conn module=$i module_type=LIBRARY compile_all=yes window_state=minimize

# repeat for other module types  (code left out)
# move executables to FORMS_PATH in environment file in $MIDTIER_HOME/forms/server.  (code left out)
echo Finished.
exit 0

Summary (pro’s-con’s):

The important pieces are to get it all working are setting ORACLE_TERM, NLS_LANG and FORMS_PATH and use over Further,

– On the application server no developer-user accounts are present.
– No other user-accounts than oracle needed to compile webforms application.
– Developers don’t have to install extra software (FTP-client, putty, X-terminal).
– Developers don’t have to learn linux/unix shell commands.
– Compilation is perfdormed automatically, via the cronjob.
– Compilation is done without the need of an X-terminal.
– Mandatory software on both developers desktop and on application server: versioning software (subversion or CVS).


  1. Ramesh February 18, 2010
  2. Ibrahim June 17, 2009
  3. Arjan Zeeman August 10, 2006
  4. Andre Crone July 31, 2006
  5. Harm Verschuren July 24, 2006
  6. Lucas Jellema July 23, 2006