2 Replies Latest reply on Nov 4, 2005 1:42 AM by Sven Baumgarten

    server hangs on long transaction

    Sven Baumgarten Newbie

      Hi

      I use JBoss 4.0.3SP1 with CMP. If I invoke a Session Bean method from a Java Client that starts a long transaction (e.g. 1 minute) the server hangs. That means that if any other client invokes a method the server does not answer till the first method call is finished. Does JBoss not handle multiple method invocations parallel? Could this be a configuration problem?

      regards
      Sven

        • 1. Re: server hangs on long transaction
          Joachim Van der Auwera Expert

          I had similar problems at some point. Which database are you using? Which transaction isolation level?

          Have you checked cpu usage during this time?

          Kind regards,
          Joachim

          • 2. Re: server hangs on long transaction
            Sven Baumgarten Newbie

            I use MS SQL 2000. All bean methods are defined as "transaction required". My datasource for entities is defined in this way:
            <?xml version="1.0" encoding="UTF-8"?>
            <local-tx-datasource>
            <jndi-name>AFPSDB</jndi-name> <connection-url>jdbc:jtds:sqlserver://192.168.1.102:1433/AfpsEntwicklung;tds=8.0;lastupdatecount=true</connection-url>
            <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
            <user-name>AfpsServer</user-name>
            <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
            <type-mapping>MS SQLSERVER2000</type-mapping>
            </local-tx-datasource>