tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rhonny David <rhonnyda...@yahoo.com>
Subject Re: Tomcat Hangs with variable frequency
Date Wed, 22 Dec 2010 14:31:24 GMT
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.kolinko@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


      
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message