1 Reply Latest reply on Nov 10, 2003 4:34 PM by Jon Barnett

    Delay Problem ! Urgent !

    amir Newbie

      Hi
      We are developing a Learning managment system on jboss 3.2.0 and MSSQL 2000 and Linux.
      at first we had Linux Redhat 8 and we have a jdbc connection problem , we had to wait 20 seconds for each of our jdbc connections, we upgrade to linux redhat 9, so the problem disappears, but after 2 or 3 days again we have the same problem , I don't know what is it for. consider that :

      1- we are using datasource for getting connection
      2- connection timeout is 20 sec
      3- we get the connection after 20 sec
      4- we have this problem when jboss starts , so it is not a bug in our application,
      5- we set minimum and maximum pool size to reasonable value
      6- we don't have this problem on Windows 2000 Server
      7- consider that jboss gets connections with delay for each connection , even for minimum pool size.
      I'm almost sure that there is something in linux configuratoin or jboss configuration that we dont know about it.

      sorry for poor english
      please help
      it is really important

        • 1. Re: Delay Problem ! Urgent !
          Jon Barnett Master

          Have you tried measuring the time it takes to execute SQL over JDBC for the situation, and also measuring execution speed for rest of critical code? You may need to put in code to test it.

          It sounds like there is a leak somewhere causing the SQL execution to slow down - a guess, but you need to do some more investigation. You may want to see if you can get anything useful from a thread dump from the JVM:
          kill -QUIT process_id

          Other things to try are other JDBC drivers.