| |
GeekInterview.com > Interview Questions > J2EE > JDBC
| Print | |
Question: What is difference b/w Type-1 and Type-4 JDBC Driver with Example ?
Answer: Give me brief description with small Example |
| July 07, 2008 01:01:14 |
#2 |
| aleemkh |
Member Since: July 2008 Total Comments: 17 |
RE: What is difference b/w Type-1 and Type-4 JDBC Driver with Example ?
|
Type 1 JDBC drivers are comparatively slow. They are not pure java drivers. The JDBC calls are converted to ODBC calls . So they are also called as JDBC-ODBC biridge drivers. The the ODBC interacts with database. The other biggest disadvantage is the client or the server should have ODBC installed in it so they are not pure java drivers. The performance is also very slow
Type 4 JDBC drivers are pure java drivers and they are the fastest drivers available.
They dont require ODBC , the JDBC directly interacts with database which makes the process fast. The only disadavantage with TYPE-4 JDBC drivers is that they are speicific to the database . Oracle thin Driver is TYPE-4 JDBC driver which is speicific to only ORACLE database. But this is not an issue as Database provides their own drivers |
| |
Back To Question | |
