0 Replies Latest reply on Apr 12, 2005 11:53 AM by Mark Bruyns

    JBoss 3.0.4 SQLServer2000 Timeouts.

    Mark Bruyns Newbie

      Hi,

      I'm running a query against a Table with around 70 000 rows.
      There are 45 Columns of which 12 are varchars.
      The database query returns 1000 rows.

      Using Query Analizer, the response is sub-second.
      Using our application, JBoss times out.
      The

      PortableRemoteObject.narrow(i.next(),Bean.class);

      method seems to be delaying the response.

      Please can someone suggest how i can prevent timeouts without adjusting the transaction timeout interval in JBoss.

      Thanks,
      Mark.