Re: Oracle/JDBC through Gauntlet Firewall

For the thin drivers to work you need to accomplish a numer of things: - they need privilege to connect from the client (an issue with Applet Security if the web server is different from the Oracle server) --> you will get some sort of Applet Security exception if your Applet does not have such privilege
- they need to be able to connect thru the firewall inbound. Default port used is 1521. If this port is closed - no Oracle outside - remember thin drivers do not use SQL*NET client configuration. URL looks something like jdbc:oracle:thin:@myserver:1521:orcl, *not* jdbc:oracle:thin:@mylocalalias
- you need to provide for proper domain name resolution, i.e. your client out in the world shoud know that myserver is behind your firewall. Else use numeric IP addresses.

Hope this helps

Andreas
procopio2247_at_my-dejanews.com wrote in message <6ruru7$fbi$1_at_nnrp1.dejanews.com>...
>HELP :)
>
>We have an Oracle DB inside a Gauntlet firewall. On the Service Net segment
>we have a web server. From the Web server I can connect via SQLPLUS to the
>internal Oracle Server.
>
>However, we have another application that uses Oracle JDBC drivers.
>What modifications to a normal connect string do I need to make for the
>JDBC driver to treat the Gauntlet Firewall as a connection manager?
>
>For sqlplus, we created a file called TNSNAV.ORA which does the trick...
>
>Do I need to use the JDBC OCI drivers? I've been told that it can be
>accomplished using the thin client version...
>
>
>Thanks.
>procopio_at_interstat.net
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 27 1998 - 02:26:19 CDT