5 Replies Latest reply: Sep 30, 2011 2:31 PM by jschellSomeoneStoleMyAlias RSS

    JDBC

    860105

      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
          Definitely not 1, probably 2.
          • 2. Re: JDBC
            jorge pesquera
            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
              jorge pesquera wrote:
              [...] for performance, C is always more efficient than java.
              Be carefull with such statements...

              bye
              TPD
              • 4. Re: JDBC
                Joe Weinstein-Oracle
                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
                  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.