Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver

From: Lee Fesperman (firstsql_at_ix.netcom.com)
Date: 08/13/04


Date: Fri, 13 Aug 2004 21:34:19 GMT

Madhur Ahuja wrote:
>
> Hello
> * I have just started JDBC in java. I am still learning the basics. One
> thing I am confused about is the implementation of java.sql.*.
> Are the implementation of java.sql.* class provided by
> the sun itself or they are provided by database vendor.

The interfaces in java.sql.* are implemented by the provider of the JDBC driver (which
need not be the database vendor). The provider may be Sun ... see below. The provider of
the JDBC driver may also subclass certain classes in java.sql.*.

> * I downloaded the level4 driver of mysql and observed that
> it contains classes like DriverManager and all those under
> java.sql.*.

It also provides the interfaces in java.sql.* but with no implementation.

> * I also saw similar files in src.zip of java distribution.
> I am confused, what is the difference between the two and the one
> contained in the src.zip are for which database.
>
> * I saw code which accesses *access database* using this url
> sun.jdbc.odbc.JdbcOdbcDriver . who provides this implementation
> sun or microsoft.

sun.jdbc.odbc.JdbcOdbcDriver and associated implementation of java.sql.* interfaces are
provided by Sun with the SDK. Microsoft and others also provide JDBC/ODBC drivers.

> where can I find the documentation of sun.* classes like I have those of
> java.* classes. I have pdf file of JDBC Api specification but not
> the ones like framed interfaces of java.* html pages.

Often, providers of JDBC drivers will not supply Javadocs for their drivers, depending
on the Javadocs for java.sql.* for primary information. They generally provide
non-Javadoc documentation describing features supported and formats for connection
properties including the connection URL.

-- 
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)


Relevant Pages

  • Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver
    ... > * I have just started JDBC in java. ... The interfaces in java.sql.* are implemented by the provider of the JDBC driver (which ... The provider may be Sun ... ...
    (comp.lang.java.help)
  • Re: OracleDriver load fails from a Web Service On tomcat
    ... considering that Java 1.3 is already obsolete and Java 1.4 is ... Consider upgrading to a current Oracle JDBC driver. ...
    (comp.lang.java.programmer)
  • Stuff the purple heart programmers cook up
    ... C To act like a framework for the JDBC driver developers. ... D To hide the specifics of accessing particular kinds of database ... Topic: Java 2: Survey Author: Chris Mc Devitt ... The JDBC ResultSet is actually an interface java.sql.ResultSet. ...
    (comp.lang.java.programmer)
  • ClassNotFoundException
    ... Java application, using JDBC. ... My Java app is on Windows XP Home; ... Informix Client-SDK 2.81 TC3 is installed on XP; ... Using Informix Client-SDK dbping, every connection are made successfully, ...
    (comp.lang.java)
  • Re: ClassNotFoundException
    ... > Java application, using JDBC. ... > 3) My Java app is on Windows XP Home; ... > driver installed and a CLASSPATH set before running DBPING" ... > c) I know CLASSPATH system variable isn't set. ...
    (comp.lang.java)