Notes for WWW team on leaving in 1992

Files

I have written up to this day two gates for ORACLE, HTOraclegood1.pc and HTOraclemostlygood2.pc .

To compile them, you should copy one of them in HTOracle.pc, then use Makefile with the command: "make HTOracle.exe".

Be sure that you are using the right Makefile, also saved as MakefileHTtemp for the moment (it depends on the login and password to an ORACLE Database).

The tests are done under the Database vmdb1, accessed through ORION.

I have also made HTOracle.h, which defines the function HTOracle called by HTRetrieve.c and written in HTOracle.pc .

The extension .pc means that you first have to precompile through the Pro*C ORACLE Precompiler before you get a .c file.

HTOraclegood1.pc works in any circumstances so far. HTOraclemostlygood.pc still has bugs with a few tables such as SALES under the vmdb1 Database, but the tables usually look better: the titles are underlined and the titles of number columns are justified to the right, as in ORACLE.

y.pc is a file very similar to HTOraclemostlygood2.pc, since he prints the tables like it, but on your orion terminal (so not through WWW). So far, "y" has worked with any table, including SALES.

I haven't yet worked on the other ORACLE requests (apart from SELECT). Some may work, but might anyway have a printed error message: so you should check whether or not the job was done. It shouldn't be a problem to forbid any request other than SELECT, but I haven't yet done it.

Testing at CERN

For direct pointers, see the test page.

To test the program HTOraclegood1 under ORION, the HREF is up to now http://orion:5035/Oracle?

To test the program HTOraclemostlygood2 under ORION, the HREF is till now http://orion:5070/Oracle?

In any ORACLE request, omit the usual ";" at the end.

To test the program, you should use "select * from cat", which will show you all the ORACLE tables that you have at your disposal, and you can then select one of them by typing, for exemple, "select * from animal".

To test, there must be background programs running under ORION, which are

HTOracle -v -R -a \*:5035 & (e.g. for running HTOraclegood1)

and HTOracle -v -R -a \*:5070 & (e.g. for running HTOraclemostlygood2).

Currently, you can log on to ORION with the login "www1ext", and you can log on to vmdb1 by the login "temp" .

The files that should be kept for sources or information are:

HTOracle.pc

HTOraclegood1.pc

HTOraclemostlygood2.pc

y.pc

HTOracle

HTRetrieve.c

HTOracle.h

Makefile

Anyway, you should expect some difficulties if you try to compile the two HTOracle files under another machine than ORION. So:

WWW files are here declared as being located in WWWCommon,

WWWDaemon, WWW.

ORACLE files are declared as being located somewhere in the disk (good luck).

It is currently not possible to use two Makefile, one to precompile with ORACLE, and one to compile the whole WWWserver, since even in HTOracle.c, you will have to call ORACLE files during compilation.

If you have any problem to log on ORION or on vmdb1, and that should happen about twice a month, contact Mr. Sergio SANTIAGO (41-34), or Mrs. Catherine MAGNIN (50-03).