Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC

 
Angela Jessi
Ranch Hand
Posts: 428
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I just know that JDBC is Java Database Connectivity. But what is that? How can I download it? How can I attach JDBC to Java application or to database?
Thanks
Angela
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's like ODBC, a standard way of connecting to databases. The necessary libraries come installed with the JDK and there's also a free JDBC-ODBC bridge driver to connect to databases that support ODBC.
I'm hoping someone else will elaborate on this matter.
 
Bosun Bello
Ranch Hand
Posts: 1510
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The easiest way to find out is to download the JDBC tutorial from Sun's site.

Bosun
 
Rick Rodriguez
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Stanley Tan:
It's like ODBC, a standard way of connecting to databases. The necessary libraries come installed with the JDK and there's also a free JDBC-ODBC bridge driver to connect to databases that support ODBC.
I'm hoping someone else will elaborate on this matter.

I hope that I don't ask a stupid question here, but what is ODBC? I'll access the Sun Site to learn more, but is it like an API for a database?
Does every object oriented or non-object oriented programming language have its own ODBC, Java's being JDBC?
I would appreciate any feedback that you could give me. Thanks.
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Um, ODBC stands for Open DataBase Connectivity. Its a standard developed by microsoft for connecting to databases that understand ODBC. So we can interface to a database through ODBC instead of using native calls.
From Microsoft's web site:
<blockquote>
Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.
</blockquote>
A good place to start learning about JDBC would be:
http://java.sun.com/docs/books/tutorial/jdbc/index.html
HTH,
Stanley Tan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic