Re: Database programming with Java

From: Tony Morris (dibblego_at_optusnet.com.au)
Date: 01/15/04 

Date: Thu, 15 Jan 2004 14:08:41 +1000

There is only one way to access a database from Java, and that is JDBC.
JDBC is not equivalent to ODBC except that provides a common functionality
(the ability to access a database).

If one were to attempt to issue database commands using the proprietrary
database protocol (which is possible), one would effectively be writing a
JDBC driver that is non-compliant with the specification.

If you are going to use JDBC, it would pay to learn how it works, the
specification, and the API involved. 

-- 
Tony Morris
(BInfTech, Cert 3 I.T., SCJP[1.4], SCJD)
Software Engineer
IBM Australia - Tivoli Security Software
(2003 VTR1000F)
"Gerbrand van Dieijen" <gerbrand@twistedPUNTwarande.net> wrote in message
news:slrnc0c214.kpa.gerbrand@bellatrix.students.cs.uu.nl...
> On Wed, 14 Jan 2004 22:41:39 GMT, Christophe Vanfleteren wrote:
> >John O'Conner wrote:
>
> >It won't matter which DB you'll use (you can even use Acces), you only
need
> >to learn JDBC, which will behave the same for all RDBMS's out there (the
> >actual SQL you'll write is dependent on the DB offcourse).
> >You can find a JDBC tutorial at
> >http://java.sun.com/docs/books/tutorial/jdbc/
> >
>
> This is not true, you can access databases under Java in many ways.
> JDBC is just a standard equivalent of ODBC, and mostly used probably,
> but not the only one.
> Many database access libraries for Java use JDBC underneith them, but
> you'll won't have to learn JDBC to use them.
>
> -- 
> Gerbrand van Dieijen
>

Relevant Pages

  • 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)
  • Re: How to modify a MySQL database...
    ... and then update them with Java. ... To learn how to create a MySQL database, ... you will need to learn JDBC. ...
    (comp.lang.java.programmer)
  • Unable to load JdbcOdbc library
    ... I am trying to connect to an Informix database on a stand-alone ... On a PC I set up a system DSN for the database under ODBC, ... On the Solaris side, ... JDBC to ODBC Bridge: Checking security ...
    (comp.lang.java.databases)
  • Re: Connecting to MySQL using Open Office Base via ODBC...
    ... Also I can choose to connect to my database using ODBC or JDBC. ... BTW if you are configuring a new server, I highly recommend Webmin: ...
    (Ubuntu)
  • Re: Mixing P/R philosophy with OO (within J2EE).
    ... I have observed the work of literally hundreds of Java developers. ... Treating a database like a mere "persistence storage mechanisms" is on ... JDBC - Never before in history were so many database API's ... Topmind, if you're reading this, isn't this a good example of OOP? ...
    (comp.object)