Build your professional network on facebook via our app Go to app
 
 
Posted in Community :

Java Architect

 
Asked by : Sandeep Reddy M, Project Lead, i2 Technologies
Industry : IT Services
Functional Area : Architecture
Keywords : Difference JDBC ODBC
Activity: Question posted: 05 22 2008 23:38:04 +0000, 5 answers, 44055 views, last activity 04 01 2014 23:00:20 +0000
 
Share
 
 
  Rate : 
 
 
 Top Answer :
Rating : +1 

a) OBDC is for Microsoft and JDBC is for Java applications. b) ODBC can’t be directly used with Java because it uses a C interface. c) ODBC makes use of pointers which have been removed totally from Java. d) ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required. e) ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in Java and JDBC code is automatically installable, secure, and portable on all platforms. f) JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.



[ Delete ]
[ Edit ]
Report Abuse
by   Sandeep Sharma, Team Lead, Infosys  | 05 22 2008 23:39:10 +0000
  Answer modified by     Prince Tiwari, B.Tech/B.E. student, GHS Gaura  | 04 01 2014 23:57:32 +0000
[ Delete ]
[ Edit ]
Not Rated

*ODBC access the DataBase using SQL requests, ODBC converts these SQL requests into a request that the DataBase can understand.
*
ODBC is a C interface, So that it can’t be used with Java directly, and it’s for Microsoft, used for desktop applications.
*
ODBC requires “manual” installation of the driver manager and driver on client machine.
*
ODBC uses Object Oriented features.

*JDBC is Java API “Application programming interfac” used for connecting programs that is written in Java to the data in a relational databass.
*
JDBC Task is to : establish the connection with th DB then send SQL statements to the DB and finally process the result sets “Returned Data”.
*
JDBC allows database application to run on different platforms and interact with different DBMS “DatBase Management Servers”.
*
JDBC is used only for connectivity with java.
*
JDBC is Java version of ODBC.
*
JDBC is an API “Application programming interfac” Specification provided by SUN by which any Java Program can communicate with any database server.
*
With JDBC .. There’s no need for “Manual” installation {Unlike ODBC}, Because JDBC code is written automatically and installed and portable on all platforms.

  Answered by     Nirmala Reddy, B.Tech/B.E. student, Z.P.H.SCHOOL BOLLAVARAM  | 02 03 2012 10:29:53 +0000
[ Delete ]
[ Edit ]
Not Rated

A c program can communicate with any DB server by using ODBC api this one is released by Microsoft.Similarly Sun MicroSystem also released JDBC API.BY using This JDBC driver a java program can communicate with any DB server

  Answer modified by     saijyothikiran , Software Developer, osmania university college  | 01 20 2009 18:06:01 +0000
[ Delete ]
[ Edit ]
Not Rated

om sai ram,

hi everybody

can any one send me the classpath to compile jsf on tomcat 6.0 plz?

  Answered by     Hari Prasad, Software Developer, Credit Suisse Group  | 05 23 2008 18:36:20 +0000
[ Delete ]
[ Edit ]
Not Rated

JDBC is the Specification provided by Sun, for the Vendors to implement. Therefore common API can be used for Oracle or Informix or which ever database you like. Vendors provides drivers which is used by Java/J2EE applications

 
Join Distance Education Courses Management
Join Distance Education Courses Management
 
 
 
More From Author
There are specialized search engines like TwitterJobSearch.com . TwitterJobSearch.com is a job search engine that searches Twitter for jobs that match the keywords that you enter.
IBM PRM-IT covers the following: * IT management system * IT customer relationships * IT direction * IT solution development * IT solution deployment * IT operational services * IT resilience * IT administration Since it covers all these it can give...
I guess Gangadhar was showign us the example how everyone hates spam....Well I hate spam because its just waste of time reading or opening such mails and also some mails may contain virus but mail servers do have antivirus which will protect us fro...
more...