Re: JDBC Competitors?

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 05/03/04

  • Next message: Adam Maass: "Re: JDBC Competitors?" 
    Date: Mon, 03 May 2004 13:17:43 -0700
To: Krmathieu <krmathieu@aol.com>

    Krmathieu wrote:

    > I am writing a term paper about JDBC for a Java programming course I am taking
    > and one of the sections of the paper is "competing technologies". My question
    > is are there in fact competitors with JDBC that seek to do the same thing, or
    > is JDBC pretty mcuh the standard that everyone uses? I thought that ODBC would
    > be considered an actual competing technology, but when I asked and database
    > type at work he said that is not the case. Any thought that anyone might have
    > on this would be greatly appreciated. Thanks!
    >
    > Kevin

    Hi. There is no meaningful alternative to JDBC for connecting to DBMSes from Java.
    There are higher-level APIs, but they will be using JDBC internally. At the wire level,
    the protocol to talk to a DBMS is proprietary to the DBMS. Typically the DBMS vendor
    provides a publicly usable native library API. This API is used by type-2 JDBC
    drivers. Type-4 (all-java) drivers understand the wire level protocol and the vendor
    implements the wire level protocol in Java to implement the JDBC calls. Typically DBMS
    vendors provide extensions to JDBC to execute any special functionality that their
    wire-level API offers that goes beyond standard JDBC.
        As such, there is no value in re-implementing the wire-level protocol for a non-JDBC
    API, especially when JDBC is part of the standard that makes Java so productive.

    Joe Weinstein at BEA

  • Next message: Adam Maass: "Re: JDBC Competitors?"

    Relevant Pages

    • Re: Setting Query Timeout through JDBC (CA Driver problem?)
      ... Lockmodes are ... they chose the idea of isolation levels. ... standard isolation levels that JDBC supports, and nothing else, because ... Another thing that's important to understand is that the SQL92 standard ...
      (comp.databases.ingres)
    • SQL shell/terminal application
      ... Java, and working over JDBC. ... The key feature should be ability to read commands from standard input ...
      (comp.lang.java.databases)
    • jdbc 2.0 and Jdbc 3.0 standards compatibility....
      ... Question is If I have a driver which is based on JDBC 2.0 standard, ... will it work properly with the JDK 1.4 or JDBC 3.0 standard?? ...
      (comp.lang.java.databases)
    • Re: Is there a One True Postgres interface? Is Ruby-postgresmaintained?
      ... | there is no such thing as a "Java interface"). ... Because Ruby doesn't really compare to Java in terms of infrastructure ... Both Ruby and the database you want to speak to have to provide an API ... to do that (JDBC is a Java API, and still needs the proper connectors to ...
      (comp.lang.ruby)
    • Re: A book on the Oratcl package
      ... goal of TDBC be to emulate the behavior of JDBC? ... The API is driven by best practices selected ... A mapping of tdbc protocol to oratcl protocol should ...
      (comp.lang.tcl)