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 resultset in jdbc?

491


How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

530


Is not bound in this context unable to find jdbc spring boot?

495


Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?

468


What is jdbc stand for?

488






Discuss the procedure of retrieving warnings?

559


Is jdbc connection secure?

508


What does executeupdate return in java?

497


How do I find jdbc version?

531


What is ojdbc14 jar?

498


Explain how data flows from view to db and reverse

1630


What are the common JDBC problems that you got and how do you solved them?

1958


What does jdbc setmaxrows method do?

517


How do I find ojdbc jar version?

495


What is the fastest type of JDBC driver?

594