Re: Q: java - oracle

From: Martin Smith <mfsmith_at_erols.com>
Date: 1997/07/26
Message-ID: <33DA7975.64A071E5@erols.com>#1/1

This is a multi-part message in MIME format.

--------------08E1D469E65B9E8DBEDCA926
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

There are 2 ways to do this:

(1) Use the new Oracle JDBC Type 4 drivers (now in the free download area of www.oracle.com); you install the Oracle driver (which are java class files) on a host. Beacuse of applet security, the host must be the http server that servs the class files AND it must also be the host for the Oracle TCP/Ip listener. There are 2 versions of the Oracle "thin" (Type 4) driver: one for jdk 1.0 and one for 1.1. Caveat: I have not done all of this: so far I have only run the stuff with the class files (1.1) locally--just haven't got round to trying the other way. Caveat 2: The Oracle docco says "this probably won't work if the client is behind a firewall." I *assume* this is related to the known problem with Oracle on NT that the IP listener replies on a different port than the incoming connection. (Brillliant, no?) Firewalls apparently don't like this.

(2) Use any of several "middleware" servers. The SQLNET/ODBC stuff goes there and the client is left thin. My (very limited) experience is with Visual Cafe Pro's DBAnywhere server, hosted with and IIS server on an NT box, which then talks to Oracle on an HP box. Again: the class files and the DBAnywhere sever and IIS and the Oracle ODBC driver and SQL*Net are ALL on the NT box.

Good hunting . . .

mfs

Mark Boon wrote:

> On Wed, 23 Jul 1997 16:58:58 -0400, Larry Magiera <magiera_at_syrres.com>
>
> wrote:
>
> >Hi everone. Does anyone know if the following is possible?
> >
> >I'd like to create a Java applet using JDK 1.0.2. I'd like the
> >applet to run in a Java-enabled browser. I'd like the applet to
> >interface with an Oracle database. I do not want to install *any*
> >software on the client machine, except the browser.
> >
> I had to make a Java program retrieve some stuff from an Oracle
> database.That was a few months ago, and at least at that time there
> was no solution for what you want. I'm not an Oracle expert, or had
> anything to do with databases until then, so take my advice with a
> grain of salt.

--------------08E1D469E65B9E8DBEDCA926
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Martin Smith
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Martin Smith
n:              Smith;Martin
org:            US International Trade Commission
adr:            500 E Street SW;;;Washington;DC;20436;USA
email;internet: mfsmith_at_erols.com
title:          Director, Information Services
tel;work:       (202) 205-3258
tel;fax:        (202) 205-2024
tel;home:       (703) 734-1039

x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard

--------------08E1D469E65B9E8DBEDCA926-- Received on Sat Jul 26 1997 - 00:00:00 CDT