If closing the result set requires reading it in full (as JTDS does),
it can take significant time.
You should take thread dumps to see what the threads are doing and
what they are waiting for. (Three thread dumps taken several seconds
apart).
Post them inline, or somewhere else (like pastebin site). Attachments
are usually stripped off by the mailing list software.
2010/12/22 Rhonny David <rhonnyda...@yahoo.com>:
> I won't support your reasoning, because the same JTDS driver version we are
> using for our other site and there the number of concurrent users of the
> application is more than 800 and therefore the volume of concurrent requests
> is
> very high, but we never faced the issue of this nature. Secondly, we have
> recently started using JTD driver and tomcat jndi connection pooling for our
> current site and earlier we used microsoft driver and our own connection
> pooling
> mechaninsm, but the same issue of tomcat hanging was occurring at that time.
>
>
> Regards,
> David
>
>
>
> ________________________________
> From: Konstantin Kolinko <knst.koli...@gmail.com>
> To: Tomcat Users List <users@tomcat.apache.org>
> Sent: Wed, December 22, 2010 6:53:46 PM
> Subject: Re: Tomcat Hangs with variable frequency
>
>> net.sourceforge.jtds.jdbc.JtdsResultSet.close ( JtdsResultSet.java:486 )
>
> I think it is an issue with implementation of JtdsResultSet.close(), [1]
>
> 0485: if (!getConnection().isClosed()) {
> 0486: // Skip to end of result set
> 0487: // Could send cancel but this is safer as
> 0488: // cancel could kill other statements
> in a batch.
> 0489: while (next())
> 0490: ;
> 0491: }
>
> [1]
> http://www.java2s.com/Open-Source/Java-Document/Database-JDBC-Connection-Pool/jTDS/net/sourceforge/jtds/jdbc/JtdsResultSet.java.htm
>
>
> [2]
> http://jtds.svn.sourceforge.net/viewvc/jtds/branches/jTDS%201.2%20%28stable%29/src/main/net/sourceforge/jtds/jdbc/JtdsResultSet.java?revision=1107&view=markup#l467
>
>
> It tries to dispose the resultset by reading through it and hangs in
> the process (or maybe the resultset is too big and reading it takes a
> while).
>
> Best regards,
> Konstantin Kolinko
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
