view tests/Test_Csendthread.java @ 833:e890195256ac

Update copyright for the new year, move to MonetDB Foundation, add SPDX.
author Sjoerd Mullender <sjoerd@acm.org>
date Fri, 29 Dec 2023 14:37:42 +0100 (15 months ago)
parents aeb268156580
children d416e9b6b3d0
line wrap: on
line source
/*
 * SPDX-License-Identifier: MPL-2.0
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0.  If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * Copyright 2024 MonetDB Foundation;
 * Copyright August 2008 - 2023 MonetDB B.V.;
 * Copyright 1997 - July 2008 CWI.
 */

import java.sql.*;

public class Test_Csendthread {
	public static void main(String[] args) throws Exception {
		System.out.println("0. active threads: " + Thread.activeCount());

		StringBuilder sb = new StringBuilder();
		sb.append("SELECT 1");
		for (int i = 0; i < 256; i++) {
			sb.append("-- ADDING DUMMY TEXT AS COMMENT TO MAKE THE QUERY VERY VERY VERY VERY LONG\n");
		}
		sb.append(";\n");
		String longQuery = sb.toString();

		for (int i = 0; i < 10; i++) {
			for (int j = 0; j < 10; j++) {
				Connection conn = DriverManager.getConnection(args[0]);
				try {
					Statement st = conn.createStatement();
					st.execute(longQuery);
					st.close();
				} finally {
					conn.close();
				}
			}
			System.out.println("1. active threads: " + Thread.activeCount());
		}
		System.out.println("2. active threads: " + Thread.activeCount());
	}
}