• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

What is JDBC Database?

 
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey Guys!

Can any body of you know about the JDBC Database. I have seen this term in java site.
Please let me know if any one of you know it.

Thanks in adavance.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That term is a bit odd. JDBC is the Java API for accessing databases. But it's not the database that implements JDBC, it's the database driver (which is a Java library). So what may be meant by that term is a database for which a JDBC driver exists, and which thus can be accessed by Java code using JDBC.

Just about any widely used database (Oracle, SQLServer, DB2, Sybase, Informix, MySql, PostgreSQL, ...) has a JDBC driver available, so in that sense any such database is a "JDBC database".
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi

JDBC is not a separate database. Its called Java Data base conectivity.
Java uses JDBC API to talk to any database like oracle,SQL,DB2 etc.,
You can execute SQL queries using JDBC. A typical JDBC code looks like below

Connection con = DriverManager.getConnection
( "jdbc:myDriver:wombat", "myLogin","myPassword");

Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table1");
while (rs.next()) {
int x = rs.getInt("a");
String s = rs.getString("b");
float f = rs.getFloat("c");
}

For more details kindly go through this link
http://java.sun.com/docs/books/tutorial/jdbc/
 
Ranch Hand
Posts: 1325
Android Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
JDBC stand for (Java Database Connectivity)

as Ulf already discussed this question very clearly, if still you have some confusion than feel free to visit this URL http://java.sun.com/products/jdbc/overview.html to get more clear yourself.

Thanks,
 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey Guys

Let me clear on this topic. I have seen this term in one article(Features included in Java6):

Database
For a great out-of-the-box development experience with database applications, the Java SE 6 development kit � though not the Java Runtime Environment (JRE) � co-bundles the all-Java JDBC database, Java DB based on Apache Derby. No more need to find and configure your own JDBC database when developing a database application! Developers will also get the updated JDBC 4.0, a well-used API with many important improvements, such as special support for XML as an SQL datatype and better integration of Binary Large OBjects (BLOBs) and Character Large OBjects (CLOBs) into the APIs.



That's the matter. Now,
Are they going to introduce JDBC Database?
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
As was pointed out before, that is not a commonly used term. If you want to know why the writer chose to use it, you need to ask him or her. There is a JDBC-capable database, or a JDBC-enabled database, but no such thing as a JDBC database.

What's being talked about here is the fact that JDK 6 comes bundled with the Derby database, which is written in Java and has a JDBC driver. For more about it, have a look at its home page.
 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Then what do they mean by:

Java DB based on Apache Derby



Is that doesn't mean are they going for Java DB similer to Apache Derby???
[ August 23, 2007: Message edited by: Shashidhar Rao ]
 
Bartender
Posts: 1155
20
Mac OS X IntelliJ IDE Oracle Spring VI Editor Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
No its just two terms for the same product.

The original database was called developed by Informix and called Cloudscape. IBM now own all of the old Informix products, and a few years back gave the source code of Cloudscape (in Java) to the Apache open source community. Apache then created a new project - called "Derby" hence the name.
Sun decided to bundle this database within the latest edition of Java. Not sure why they use the term "Java DB" - but its the same as Apache Derby.
[History lesson over] :p
 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Peter!

But they shouldn't use the term JDBC DB. Any how I got understood
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic