aspose file tools*
The moose likes JDBC and the fly likes What is JDBC Database? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "What is JDBC Database?" Watch "What is JDBC Database?" New topic
Author

What is JDBC Database?

Shashidhar Yarabati
Ranch Hand

Joined: Jun 17, 2007
Posts: 175
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.


Shashidhar<br /> SCJP 1.5<br /> SCWCD 5.0
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41524
    
  53
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".


Ping & DNS - my free Android networking tools app
Ramanjulu Balamurugan
Greenhorn

Joined: Aug 18, 2007
Posts: 3
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/


Bala
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

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,


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Shashidhar Yarabati
Ranch Hand

Joined: Jun 17, 2007
Posts: 175
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
Marshal

Joined: Mar 22, 2005
Posts: 41524
    
  53
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

Joined: Jun 17, 2007
Posts: 175
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 ]
Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 802

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


Regards Pete
Shashidhar Yarabati
Ranch Hand

Joined: Jun 17, 2007
Posts: 175
Thanks Peter!

But they shouldn't use the term JDBC DB. Any how I got understood
 
Consider Paul's rocket mass heater.
 
subject: What is JDBC Database?