jdbc drivers?

Answer Posted / manish kushwaha

Hi All, i have gone through above answers they all are quit
well,

you can refer any ans i would like to add few points

1) JDBC-ODBC driver(TYPE-1) : this is performance wise okay,
maintenance is acceptable but the biggest problem is
platform dependency (so use only when your application is OD
specific).

2) Partial java and Partial native(TYPE-2): this is the
fastest driver available in market in java, the reason is it
is directly interacting with java library to database
library but maintenance wise it is not acceptable it is very
costly in maintenance(over all not acceptable because
maintenance cost is more).

3) net protocol driver(IDS server)(TYPE-3): this is not much
fast but maintenance is improve because they placed one IDS
server between the java library to database library(over all
not acceptable because performance is down)

4) pure java driver (TYPE-4): this is much good in both
performance and maintenance wise because driver is directly
interacting with db library.it is the second fast driver
among above four drivers.

for any other query you can drop me mail on
mails.manish1@gmail.com
i will love to solve your problem if i have solution :)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scope or life time of instance variables?

645


What is the += operator called?

571


What is a constructor, constructor overloading in java?

520


How do you replace all in word?

513


Is there a case when finally will not execute?

557






What is the use of StringTokenizer class?

602


What is mysql driver class name?

545


What does pointer mean?

537


What are thread safe functions?

502


java program with complete 4 oops concepts implemented example

2723


Does the order of public and static declaration matter in main method?

604


How do you clear an arraylist in java?

487


Why do we need strings in java?

517


What are the types of exceptions?

581


Can a class have an interface?

541