jdbc help:sun.jdbc.odbc.JdbcOdbcDriver
Madhur Ahuja
* 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.
* I downloaded the level4 driver of mysql and observed that
it contains classes like DriverManager and all those under
java.sql.*.
* 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.
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.
--
Winners dont do different things, they do things differently.
Madhur Ahuja
India
Homepage : http://madhur.netfirms.com
Email : madhur<underscore>ahuja<at>yahoo<dot>com
Lee Fesperman
>
> 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)
Keith Wansbrough
> * I saw code which accesses *access database* using this url
> sun.jdbc.odbc.JdbcOdbcDriver . who provides this implementation
> sun or microsoft.
Sun provides a JDBC driver for ODBC. Microsoft provides an ODBC
driver for Access. The two together mean a Java program can access
an Access database.
> 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.
The sun.* classes are deliberately undocumented; they are internal to
Sun's implementation of (some of) the java.* classes, and subject to
change without notice. You should only ever depend on the java.*
classes, and never need to know about the sun.* classes.
--KW 8-)
--
Keith Wansbrough <kw...@cl.cam.ac.uk>
http://www.cl.cam.ac.uk/users/kw217/
University of Cambridge Computer Laboratory.