sers List" <[EMAIL PROTECTED]>
Sent: Monday, November 19, 2001 11:42 AM
Subject: Re: AW: Java program interferring with Tomcat
> > Not with SQL Server. If thread A has a write lock on a table, thread b
> will
> > wait until the write is completed before reading. If threa
, 2001 2:42 PM
> To: Tomcat Users List
> Subject: Re: AW: Java program interferring with Tomcat
>
>
> > Not with SQL Server. If thread A has a write lock on a
> table, thread b
> will
> > wait until the write is completed before reading. If
> thread A is i
> Not with SQL Server. If thread A has a write lock on a table, thread b
will
> wait until the write is completed before reading. If thread A is in a
> transaction that is long running then a perfectly funcitoning application
> can seem to hang. Its also possible that some form of infinite loop
> -Original Message-
> From: David Frankson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 19, 2001 1:42 PM
> To: Tomcat Users List
> Subject: Re: AW: Java program interferring with Tomcat
>
>
> Only Tomcat hangs, the other program continues on.
David Frankson wrote:
> Only Tomcat hangs, the other program continues on. I thought a database
> deadlock only happens when both threads are trying to write and holding a
> lock on each other's data? The external java process is read-only.
Hmm. That's why I asked. Sounds like maybe the
ce on
Win2k?
Dave
- Original Message -
From: "Denis Haskin" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, November 19, 2001 12:09 PM
Subject: Re: AW: Java program interferring with Tomcat
> Ralp
Ralph Einfeldt wrote:
> Sounds like a deadlock on the database.
>
> To verify that have a look at the server manager
> to see if there are locks.
I agree with Ralph, that the problem is probably in your SQL access.
Do *both* processes hang (e.g. Tomcat & the scheduled job) or only
Tomcat?
I wo
Sounds like a deadlock on the database.
To verify that have a look at the server manager
to see if there are locks.
Which SQL Server Version do you use?
Which transaction level do you use?
(java.sql.Connection.getTransactionIsolation())
> -Ursprüngliche Nachricht-
> Von: David Franks
