Re: JDBC and Oracle

Greg Turner <gturner_at_hooked.net> wrote in article <32190487.7E19_at_hooked.net>...
> Konstantinos Agouros wrote:
> > >You are right that you need an ODBC driver (most likely from
> > Why does he need an ODBC--Driver? If there is a native JDBC-Driver
> > for Oracle you don't have to use ODBC at all.
> >
> > Konstantin
 

> The writer who originated this thread asked about JDBC. JDBC includes
 the
> JdbcOdbc.dll affectionately known as the JdbcOdbc bridge. I assumed that
> the writer when he referred to JDBC was referring to the complete
> package and to use the complete package, a Oracle ODBC driver is needed.

The ODBC bridge is not a basis for JDBC. In fact, ODBC and JDBC are not related at all except that ODBC can act as one possible "transport" for JDBC requests.

Some of the JDBC packages available do JDBC to ODBC bridging, requiring the ODBC piece. Others don't. They are "native" in that they do not go through an ODBC bridge. Weblogic, for example, has drivers that go through SQL*NET (in the case of Oracle) (http://www.weblogic.com)

>
> I am not sure what you mean by the term native JDBC-Driver? If you mean
> a dll that communicates directly between the java classes of JDBC and the
> database, then you are correct that is such a thing exists, it could be
> used. Such a solution bypasses the need the the JdbcOdbc.dll does it
 not?
>
> I don't know what you mean exactly by "for Oracle you don't have to use
 ODBC at all"
> ODBC is a specification that is the basis for the JDBC API, is it not?

No, see above.

>
> --
> Greg Turner, Intelligent Software
> Box 1506 gturner_at_hooked.net
> Mill Valley, CA 94942 http://www.hooked.net/~gturner/
>

Greg Pasquariello
Chief Architect, dbINTELLECT Technologies gpasq_at_dbintellect.com Received on Tue Aug 20 1996 - 00:00:00 CEST