server hangs on long transaction

[baumgarten]

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

[triathlon98]

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

[baumgarten]

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>