Re: Linking Oracla and Java

In article fp_at_m1.cs.man.ac.uk, patels_at_cs.man.ac.uk (Sandeep Patel) writes:
> Hello All,
> I need some tools to link a Java fornt end to an Oracle DB.
> Does anyone know of any that can do this?
>
>
> Thanks
> Sandeep Patel
>

Look at JAM Web 2.0 and Prolifics from Prolifics (www.prolifics.com). It will allow you to use Pro*C, OCI, or ODBC (though this is pretty much hidden from you), and will generate HTML, Java-script, etc for you. It uses business graphics, and even has a three-tier version, so you can call services on lots of machines.

It runs on Unix (Solaris, AIX, SunOS, DG-UX, etc), NT, Windows-95, etc. I'm not sure about Mac yet (though there is a native JAM for the Mac for both PPC and 68000).

You can add your own Java and Java-script calls, or custom HTML, etc, or let JAM and Prolifics generate it. It'll generate SQL for you, or you can write your own SQL or Stored Procedures. It has a C-like 4gl called JPL, so you don't really have to write a bunch of C or C++ calls (though it comes with a library of hundreds of functions, plus you can link in your own). I usually use JPL %99 of the time.

Also call Oracle and see if there is a version of jdbc for Oracle yet.

Good luck,
Mark McNulty

Note- these views are mine and not those of JP Morgan or JYACC. Received on Sun Nov 10 1996 - 00:00:00 CST