2 Replies Latest reply on Dec 30, 2004 11:20 PM by Elias Ross

    Database connections slow from JBoss

    Jari Timonen Newbie


      I have Jboss 3.2.3. There was an ip change and dns change in server when i noticed this problem.

      I have my own connectionpool which makes connections to MS SQL 2000 database. When i open database connection, it takes so long to open it.

      System.out.println( "Making connection to database");
      long before = System.currentTimeMillis();
      conn = DriverManager.getConnection(url, username, password);
      long after = System.currentTimeMillis();
      long result = after - before;
      System.out.println( "Connection established in " + result + "ms" );

      2004-12-08 12:45:08,593 INFO [STDOUT] Making connection to database tietokantaan
      2004-12-08 12:45:22,843 INFO [STDOUT] Connection established in 14250ms

      In the same server there is Weblogic, I made simple jsp which connects to database. It takes only 78ms.

      What has happened to JBoss? I really need urgent help on this. Any hints are wellcome.

      Thank you,
      Jari Timonen
      Software Designer