Discussions

TSS feedback: which is the effiecient JDBC driver?

  1. which is the effiecient JDBC driver? (3 messages)

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

    Thanks in advance
    kiran
  2. which is the effiecient JDBC driver?[ Go to top ]

    type 4 r the most efficient drivers...
  3. 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
  4. Use Type 4. This has better performance, easy to use and cheaper solution.