FIX: The SQL Server 2000 Driver for JDBC may spawn a new thread when you call the setQueryTimeout function on a connection object, and performance may decrease when you repeatedly call the setQueryTimeout function (894552)

MORE INFORMATION

import java.*;
import java.sql.*;
import java.util.*; 
import java.text.*;
import com.microsoft.jdbcx.sqlserver.SQLServerDataSource;

public class timeout_defect
{
	// Constructor
	public timeout_defect()
	{
	}

	public static void main(String[] args) throws Exception
	{
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

		int timeout=0;
		int displaytimeout=9999;

		ThreadGroup       group = null;
		Thread[]          threadList = null;
		int               activeThreads;
		int               numThreads;
		int               timeoutThreads = 0;

		//Connect to the SQL Server
		java.sql.Connection conn = null;
		try 
		{
			Properties p = new Properties();
			p.put("user", "<UserID>");
			p.put("password","<Password>");
			p.put("selectMethod", "direct");
			p.put("DatabaseName", "pubs");
			
			conn = java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://<Server>:1433", p);
			System.out.println("Connected to database.");
			System.out.println(" ");

			java.sql.Statement stmt1 = conn.createStatement();
			
			// Do not set Query Timeout (default to 0). 			
			System.out.println("Using default Query Timeout -- 0.");
			System.out.println(" ");

			//	timeout = 1;
			//	stmt1.setQueryTimeout(timeout);

			displaytimeout = stmt1.getQueryTimeout();

			System.out.println("Query Timeout set to  " + displaytimeout);
			System.out.println(" ");

			// Examine the threads.
			group = Thread.currentThread().getThreadGroup();
			activeThreads = group.activeCount();
			threadList = new Thread[activeThreads];
			numThreads = group.enumerate(threadList);

			for (int index = 0; index < numThreads; index++)
			{
				if (threadList[index].getName().equals("Connect Query Timeout-Thread"))
				{
					timeoutThreads++;
				}
			}
			System.out.println("Num Query Timeout threads: " + timeoutThreads);
			System.out.println(" ");

			stmt1.close();
			stmt1 = conn.createStatement();

			// Set the Query Timeout to 1.  			
			System.out.println("Setting query timeout to 1.");
			System.out.println(" ");
			timeout = 1;
			stmt1.setQueryTimeout(timeout);

			displaytimeout = stmt1.getQueryTimeout();

			System.out.println("Query timeout set to " + displaytimeout);
			System.out.println(" ");

			// Examine the threads.
			group = Thread.currentThread().getThreadGroup();
			activeThreads = group.activeCount();
			threadList = new Thread[activeThreads];
			numThreads = group.enumerate(threadList);

			for (int index = 0; index < numThreads; index++)
			{
				if (threadList[index].getName().equals("Connect Query Timeout-Thread"))
				{
					timeoutThreads++;
				}
			}
			System.out.println("Num Query Timeout threads: " + timeoutThreads);
			System.out.println(" ");

			stmt1.close();
			stmt1 = conn.createStatement();

			// Set the Query Timeout to 0  			
			System.out.println("Setting Query Timeout to 0.");
			System.out.println(" ");
			timeout = 0;
			stmt1.setQueryTimeout(timeout);

			displaytimeout = stmt1.getQueryTimeout();

			System.out.println("Query Timeout set to " + displaytimeout);
			System.out.println(" ");

			// Examine the threads.
			group = Thread.currentThread().getThreadGroup();
			activeThreads = group.activeCount();
			threadList = new Thread[activeThreads];
			numThreads = group.enumerate(threadList);

			for (int index = 0; index < numThreads; index++)
			{
				if (threadList[index].getName().equals("Connect Query Timeout-Thread"))
				{
					timeoutThreads++;
				}
			}
			System.out.println("Num Query Timeout threads: " + timeoutThreads);
			System.out.println(" ");

			stmt1.close();
		} 
		catch (java.sql.SQLException s) 
		{
			s.printStackTrace();
		}
		finally
		{
			// Cleanup
			if (conn!=null)
				conn.close();
			conn=null;
		}
	}
}