Re: Bypassing SQLNet client side?

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Fri, 16 Aug 2002 16:25:18 -0400
Message-ID: <ajjn3f$2f93$1@genma.iac.net>

> From what I could tell from the GUI setup tool they showed me, it's using
a JDBC
> connection. I have zero experience with JDBC.
>
> Anyone have any experience with the Vitria product? Can anyone explain
what
> they think might be going on that it needs IP and listener port? Is there
some
> way of bypassing the client side SQLNET software?

I have never heard of Vitria (but that doesn't mean much ;o)) but it sounds like they are using the thin JDBC driver. This driver does not require an Oracle client installation. All of the functionality normally handled by the OCI dlls/libraries is coded in Java within the JDBC driver.

When connecting to a database using the thin driver, you essentially pass the entire tnsnames entry (IP address, port, SID/service name, etc.) to the driver along with the username and password. This would explain why they wanted this information, although I think you are correct in being leery about just giving it out. Received on Fri Aug 16 2002 - 15:25:18 CDT