Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are the drawbacks of JDBC? explain briefly?

Answer Posted / naresh katakam

Usually does not perform as well as type 2 drivers
The vendor client library needs to be installed on the
client machine.
Cannot be used in web-based application due the client side
software needed.
Not all databases have a client side library
This driver is platform dependent
Performance overhead since the calls have to go through the
JDBC overhead bridge to the ODBC driver, then to the native
db connectivity interface.
The ODBC driver needs to be installed on the client
machine.
Considering the client-side software needed, this is not
suitable for applets.
Requires database-specific coding to be done in the middle
tier.
An extra layer added may result in a time-bottleneck. But
typically this is overcome by providing efficient
middleware services described above.
At client side, a separate driver is needed for each
database.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is statement and preparedstatement in java?

832


Why do we need jdbc?

988


What is JDBC DataSource and what are it’s benefits?

1104


Define preparedstatement.

934


Explain the difference between rowset vs. Resultset in jdbc?

943


What are the differences between execute, executequery, and executeupdate?

905


What is odbc and jdbc?

917


What is jdbc and jdbc drivers?

934


Give an example for execution of sql statement.

963


Why do we use jdbc statements?

897


What are the types of jdbc drivers that exist?

949


Why we use jdbc instead of odbc?

919


What is the limitation of PreparedStatement and how to overcome it?

1087


What is statement and resultset in jdbc?

893


Name the new features added in jdbc 4.0.

923