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
How many ways that we can view a result set?
What causes the "No suitable driver" error?
What is in term of jdbc a datasource?
What is statement and resultset in jdbc?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
How many types of JDBC Drivers are present and what are they?
Result set’s index starts with 0 or 1?
What is jdbc driver manager?
What is sqlwarning and discuss the procedure of retrieving warnings?
What is JDBC RowSet? What are different types of RowSet?
What is jdbc odbc?
What is isolation level? How to set it?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What is url in jdbc connection?
What is jndi lookup?