This discussion is archived
5 Replies Latest reply: Sep 30, 2011 12:31 PM by jschellSomeoneStoleMyAlias RSS

JDBC

860105 Newbie
Currently Being Moderated
Which is the best method for connecting java and Oracle/Mysql ?
1. JDBC:ODBC driver
2. JDBC Thin driver
3. JDBC OCI driver


Please any one tell me .!

Thanks ..!

Edited by: pavan1989 on Sep 4, 2011 11:34 AM
  • 1. Re: JDBC
    EJP Guru
    Currently Being Moderated
    Definitely not 1, probably 2.
  • 2. Re: JDBC
    jorge pesquera Newbie
    Currently Being Moderated
    depends on the configuration you have, if you use rac oci the is the best option is to use high availability and load balancing, with the option TAF. oci also lets you set up connections through ldap. for performance, C is always more efficient than java.
  • 3. Re: JDBC
    TPD-Opitz-Consulting-com Expert
    Currently Being Moderated
    jorge pesquera wrote:
    [...] for performance, C is always more efficient than java.
    Be carefull with such statements...

    bye
    TPD
  • 4. Re: JDBC
    Joe Weinstein Expert
    Currently Being Moderated
    There is no one product.
    You can/should connect to Oracle via the Oracle thin driver.
    You can/should connect to MySQL via the driver supplied by MySQL.

    And that assumes you are connecting from Java. Avoid C code
    if at all possible in that case. There is typically nowadays no difference
    in performance, and C code bugs can kill a JVM and C libraries have
    a brittle relationship with the Java portion of the driver and if you
    misconfigure or mismatch you can get inscrutable failures.

    Java exists because C code sucks.

    Joe

    Edited by: Joe Weinstein on Sep 29, 2011 10:19 AM
  • 5. Re: JDBC
    jschellSomeoneStoleMyAlias Expert
    Currently Being Moderated
    jorge pesquera wrote:
    ... for performance, C is always more efficient than java.
    For performance requirements, architecture and design are always (excluding niches) going to provide far more performance than language choice.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points