File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "jdbc" Watch "jdbc" New topic
Author

jdbc

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
THERE ARE 4 TYPES OF DRIVERS ARE THERE IN JDBC..WHY MOST OF THEM USING JDBC-ODBDDRIVER..tell me advantages and dis advantages
ANS.....
The JDBC-ODBC Driver is commonly used because it can be used with data source that
supports ODBC. And that is almost everything from Oracle to an Excel spreadsheet. In
addition it comes from Sun for free with the JDK. The disadvantage is the ODBC by itself
is slow and your adding an additional layer (the JDBC layer) on top of that. And of course
the client must have ODBC installed.
I AM NOT SATISFIED WITH ABOVE ANS BECAUSE...HE DIDN'T EXPLAIN
OTHER 3DRIVERS ADV AND DIS ADVANTAGES....

Todd M Bush
Greenhorn

Joined: Apr 26, 2000
Posts: 22
If your not satisfied with the above answer, why don't you look it up yourself until you are brimming over with satisfaction.
Tom P
Ranch Hand

Joined: May 06, 2000
Posts: 88
Well, I'm sorry that you can't write a sentence and make your desires known. You asked why most people use JDBC-ODBC and I answered that question. I would suggest that if you want an in-depth answer that you go read a book.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hey bhaskar49 don't be foolish.Mind your way of presenting questions.
James Beeson
Greenhorn

Joined: Apr 18, 2000
Posts: 18
Check out: http://www.computerworld.com/home/features.nsf/all/991213qs
It gives a very good description of the 4 types of drivers as well as pros and cons to each one.
James
Originally posted by bhaskar49:
THERE ARE 4 TYPES OF DRIVERS ARE THERE IN JDBC..WHY MOST OF THEM USING JDBC-ODBDDRIVER..tell me advantages and dis advantages
ANS.....
The JDBC-ODBC Driver is commonly used because it can be used with data source that
supports ODBC. And that is almost everything from Oracle to an Excel spreadsheet. In
addition it comes from Sun for free with the JDK. The disadvantage is the ODBC by itself
is slow and your adding an additional layer (the JDBC layer) on top of that. And of course
the client must have ODBC installed.
I AM NOT SATISFIED WITH ABOVE ANS BECAUSE...HE DIDN'T EXPLAIN
OTHER 3DRIVERS ADV AND DIS ADVANTAGES....

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc
 
Similar Threads
connectivity
Applet + Access problems
Jaworski Mock Exam Questions !!!
jdbc
advantage of JDBC drivers over JDBC-ODBC bridge