1 Reply Latest reply on Aug 1, 2012 8:01 AM by EJP

    ojdbc6 drive for connection time slowly

    952719

      Lasted three machine
      1, database machine : RedHat6 system
      2, Testing a machine 1 : RedHat6 system
      3, Testing a machine 2 : winxp system

      Test database connection time
      Testing a machine 1: RedHat6 jdk1.6.0 _17 ojdbc6
      Testing a machine 2: winxp jdk1.6.0 _17 ojdbc6

      Class.forName("oracle.jdbc.driver.OracleDriver");
      String url = "jdbc:oracle:thin:@192.168.1.2:1521:test";
      String user = "test";
      String pwd = "test";
      long s = System.currentTimeMillis();
      Connection c = DriverManager.getConnection(url, user, pwd);
      long e = System.currentTimeMillis();
      System.out.println("time:"+(e-s));

      1,testing a machine 1: database connection time of 20-50 seconds
      2,testing a machine 2: database connection time for 200-300 milliseconds

      In the test machine 1, appear for connection time slowly, I try to be ojdbc6 replacement for ojdbc14, connect time change very quickly. About 200-300 milliseconds.
      Testing a machine 1: RedHat6 jdk1.6.0 _17 ojdbc14

      I also try to update the JDK6U33, the latest ojdbc6, did not solve the problem for connection time very slow.
      So I will drive replacement for ojdbc14, only to replace it, get the database connection time to quickly

      Don't know why ojdbc6 in redhat6 in get connection time slow reason, can you help me,Thank you!