Re: Oracle Type 4 JDBC driver & firewalls

From: Martin Smith <mfsmith_at_erols.com>
Date: 1997/08/10
Message-ID: <33EE8F31.A93E15EF@erols.com>#1/1

This is a multi-part message in MIME format.

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

Yeah, that's more or less what I thought. I have not got a "oh, yeah, that's in the works" from Oracle. In fact, their jdbc folks suggested I put in a TAR. :-{

I was hoping to keep down the number of tiers, but maybe not. I guess I'll have to learn about CORBA and what that can do for me. Does your servlet just do protocol conversion or does it do database work?

Thanks for the response.

Martin Smith

Thornton Prime wrote:

> Martin Smith <mfsmith_at_erols.com> wrote:
> ...
> : The JDBC Thin driver cannot connect to a database from behind a
> : firewall. The firewall prevents the
> : browser from opening a TCP/IP socket to the database.
 ...
> : So: does this mean that this product cannot be used in an extranet
> : application (meaning one where I have people in other orgs (behind
> : firewalls, typically) to whom I want to give access to my database.)
>
> You have a few options (some of which really suck),
>
> 1. You can require that all your extranet members use SQL*Net compiant
>
> firewalls.
>
> 2. You can wait until Oracle provides middleware to tunnel through
> some other
> protocol (preferably HTTP, or you'll probably have problems with
> proxies
> too).
>
> 3. You can buy middleware that already tunnels through HTTP.
>
> 4. You can write your applets without JDBC and pass the data to your
> applets
> using RMI, CORBA, or some other firewall-compatible method. I
> personally use
> Servlets to connect to Java applets and pass all my data back and
> forth using
> HTTP.
>
> --
> +__ ___/+ __ \ __ \_ _/ |++ | ___|
> Thornton K. Prime +++ /++++ /++/ / /++/ / / |+ | |++++
> thor_at_primenet.com ++ /++++ ____ / __/ / /| | /| | _|++
> + /++++ /++++ /+ |++ / /+| /+| | |++++
> _/ _/+ _/++++ _/++_|____/_/++|_/++|_|_____|

--------------1B8E5294C3FCBBAC254AEA50
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

--------------1B8E5294C3FCBBAC254AEA50-- Received on Sun Aug 10 1997 - 00:00:00 CDT