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

Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?

998


Explain about the Try Block?

985


Which type of JDBC driver is the fastest one?

1088


What are the ddl statements?

853


What is the return type of execute, executequery and executeupdate?

1110


Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

1086


What is meant by connection string?

989


What is JDBC RowSet? What are different types of RowSet?

1093


What is an escape syntax?

992


What are the differences between stored procedure and functions?

1036


What is the most common example type 1 driver?

1029


What is a jdbc connection pool?

934


What is jdbc and its advantages?

1062


What is transaction processing in jdbc?

1011


What is jdbc driver?

906