0 Replies Latest reply on Sep 27, 2006 12:46 AM by Mujahid Basha

    Case of Queries taking long execution time?

    Mujahid Basha Newbie

      Hi all,
      I am using jboss-4.0.4.G.A version. When execution of SQL queries takes long time, say 5 to 8 hrs. My application is showing "Page cannot be displayed" error when the server is still running. What may be the problem? Is it problem with JBoss?

      My Connection Pool settings are:


      <local-tx-datasource>
      <jndi-name>myjndi</jndi-name>
      <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:myjnditest</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>myuser</user-name>
      mypwd
      <!--pooling parameters-->
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>5</idle-timeout-minutes>
      </local-tx-datasource>


      Even I had tried increasing/decreasing <blocking-timeout-millis> and <idle-timeout-minutes>. But no use...
      Any solution for this will be appreciated ?