hi friends,
please let me know which is the efficient JDBC driver of ALL 4 types..

Thanks in advance
kiran

type 4 r the most efficient drivers...

How do you rate efficiency ?

I would say, you need to choose your drivers based on your requirements.

Type 4 are by definition, pure Java code, which means that you can just bundle it with your application and thats it.
At the same time, it will make it a thick client, if you plan to use it in applets. For that, some vendors also provide thin drivers.

Then there are type 2 drivers which use native libraries which might be better suited for pc based applications as opposed to web applications. They are faster in a sense, being native code it will execute faster. But at the same time, hard to port.

I would say, Sun developed these 4 different types for a reason. Not to degrade any other type with respect to other. But just so that the developers get to choose according to their needs.



=======================
hi friends,
please let me know which is the efficient JDBC driver of ALL 4 types..

Thanks in advance
kiran

Use Type 4. This has better performance, easy to use and cheaper solution.