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

Why should we close database connections in java?

1149


How do I stop nullpointerexception?

979


Why do I have to reaccess the database for Array, Blob, and Clob data?

1073


Where is ojdbc14 jar located?

945


How do I load a database driver with JDBC 4.0 / Java 6?

992


What is the use of getGeneratedKeys() method in Statement?

1019


What are the higher level apis under development on top of jdbc currently?

971


How to set NULL values in JDBC PreparedStatement?

979


What is an encrypted internet connection?

935


Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

979


What is device controller?

1064


What are the jdbc api components?

1148


What is jdbc and jpa?

1007


What are dml and ddl?

1002


What is connection data?

914