This content has been marked as final.
Show 2 replies
-
1. Re: server hangs on long transaction
triathlon98 Nov 3, 2005 4:06 PM (in response to baumgarten)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
baumgarten Nov 4, 2005 1:42 AM (in response to 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>