Changeset: bc7e42f9e147 for monetdb-java URL: https://dev.monetdb.org/hg/monetdb-java/rev/bc7e42f9e147 Removed Files: tests/BugConcurrent_clients_SF_1504657.java tests/BugConcurrent_sequences.java tests/BugDatabaseMetaData_Bug_3356.java tests/BugDecimalRound_Bug_3561.java tests/BugExecuteUpdate_Bug_3350.java tests/BugResultSetMetaData_Bug_6183.java tests/BugSetQueryTimeout_Bug_3357.java tests/Bug_Connect_as_voc_getMetaData_Failure_Bug_6388.java tests/Bug_IsValid_Timeout_Bug_6782.java tests/Bug_LargeQueries_6571_6693.java tests/Bug_PrepStmtSetObject_CLOB_6349.java tests/Bug_PrepStmtSetString_6382.java tests/Bug_PrepStmt_With_Errors_Jira292.java tests/Test_CallableStmt.java tests/Test_Cautocommit.java tests/Test_CisValid.java tests/Test_Clargequery.java tests/Test_Cmanycon.java tests/Test_Creplysize.java tests/Test_Csavepoints.java tests/Test_Ctransaction.java tests/Test_Dobjects.java tests/Test_FetchSize.java tests/Test_Int128.java tests/Test_PSgeneratedkeys.java tests/Test_PSgetObject.java tests/Test_PSlargebatchval.java tests/Test_PSlargeresponse.java tests/Test_PSmanycon.java tests/Test_PSmetadata.java tests/Test_PSsomeamount.java tests/Test_PSsqldata.java tests/Test_PStimedate.java tests/Test_PStimezone.java tests/Test_PStypes.java tests/Test_Rbooleans.java tests/Test_Rmetadata.java tests/Test_Rpositioning.java tests/Test_Rsqldata.java tests/Test_Rtimedate.java tests/Test_Sbatching.java tests/Test_Smoreresults.java tests/Test_Wrapper.java Branch: default Log Message:
Remove no longer needed individual java JDBC test programs as they are migrated and converted to JDBC_API_Tester program. Note: program SQLcopyinto.java may NOT be removed as it referred to from https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData diffs (truncated from 3944 to 300 lines): diff --git a/tests/BugConcurrent_clients_SF_1504657.java b/tests/BugConcurrent_clients_SF_1504657.java deleted file mode 100644 --- a/tests/BugConcurrent_clients_SF_1504657.java +++ /dev/null @@ -1,180 +0,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 1997 - July 2008 CWI, August 2008 - 2021 MonetDB B.V. - */ - -import java.sql.*; - -public class BugConcurrent_clients_SF_1504657 { - public static void main(String[] args) throws Exception{ - Connection con1 = null, con2 = null, con3 = null; - Statement stmt1 = null, stmt2 = null, stmt3 = null; - ResultSet rs1 = null, rs2= null, rs3 = null; - con1 = DriverManager.getConnection(args[0]); - con2 = DriverManager.getConnection(args[0]); - con3 = DriverManager.getConnection(args[0]); - stmt1 = con1.createStatement(); - stmt2 = con2.createStatement(); - stmt3 = con3.createStatement(); - //DatabaseMetaData dbmd = con.getMetaData(); - - // >> true: auto commit should be on by default - System.out.println("0. true\t" + con1.getAutoCommit()); - System.out.println("0. true\t" + con2.getAutoCommit()); - System.out.println("0. true\t" + con3.getAutoCommit()); - - // test the creation of a table with concurrent clients - try { - System.out.println("1.1. create table t1 using client 1..."); - stmt1.executeUpdate("CREATE TABLE t1 ( id int, name varchar(1024) )"); - System.out.println("passed :)"); - System.out.println("1.2. check table existence in client 2..."); - rs2 = stmt2.executeQuery("SELECT name FROM tables where name LIKE 't1'"); - while (rs2.next()) - System.out.println(rs2.getString("name")); - System.out.println("passed :)"); - System.out.println("1.3. check table existence in client 3..."); - rs3 = stmt3.executeQuery("SELECT name FROM tables where name LIKE 't1'"); - while (rs3.next()) - System.out.println(rs3.getString("name")); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 1 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - con1.close(); - con2.close(); - con3.close(); - System.exit(-1); - } - - // test the insertion of values with concurrent clients - try { - System.out.println("2 insert into t1 using client 1..."); - stmt1.executeUpdate("INSERT INTO t1 values( 1, 'monetdb' )"); - System.out.println("passed :)"); - stmt1.executeUpdate("INSERT INTO t1 values( 2, 'monet' )"); - System.out.println("passed :)"); - stmt1.executeUpdate("INSERT INTO t1 values( 3, 'mon' )"); - System.out.println("passed :)"); - System.out.println("2.1. check table status with client 1..."); - rs1 = stmt1.executeQuery("SELECT * FROM t1"); - while (rs1.next()) - System.out.println(rs1.getInt("id")+", "+ rs1.getString("name")); - System.out.println("passed :)"); - System.out.println("2.2. check table status with client 2..."); - rs2 = stmt2.executeQuery("SELECT * FROM t1"); - while (rs2.next()) - System.out.println(rs2.getInt("id")+", "+ rs2.getString("name")); - System.out.println("passed :)"); - System.out.println("2.3. check table status with client 3..."); - rs3 = stmt3.executeQuery("SELECT * FROM t1"); - while (rs3.next()) - System.out.println(rs3.getInt("id")+", "+ rs3.getString("name")); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 2 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - if (rs3 != null) rs3.close(); - con1.close(); - con2.close(); - con3.close(); - System.exit(-1); - } - - // test the insertion of values with concurrent clients - try { - System.out.println("3 insert into t1 using client 2..."); - stmt2.executeUpdate("INSERT INTO t1 values( 4, 'monetdb' )"); - System.out.println("passed :)"); - stmt2.executeUpdate("INSERT INTO t1 values( 5, 'monet' )"); - System.out.println("passed :)"); - stmt2.executeUpdate("INSERT INTO t1 values( 6, 'mon' )"); - System.out.println("passed :)"); - System.out.println("3.1. check table status with client 1..."); - rs1 = stmt1.executeQuery("SELECT * FROM t1"); - while (rs1.next()) - System.out.println(rs1.getInt("id")+", "+ rs1.getString("name")); - System.out.println("passed :)"); - System.out.println("3.2. check table status with client 2..."); - rs2 = stmt2.executeQuery("SELECT * FROM t1"); - while (rs2.next()) - System.out.println(rs2.getInt("id")+", "+ rs2.getString("name")); - System.out.println("passed :)"); - System.out.println("3.3. check table status with client 3..."); - rs3 = stmt3.executeQuery("SELECT * FROM t1"); - while (rs3.next()) - System.out.println(rs3.getInt("id")+", "+ rs3.getString("name")); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 3 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - if (rs3 != null) rs3.close(); - con1.close(); - con2.close(); - con3.close(); - System.exit(-1); - } - - // test the insertion of values with concurrent clients - try { - System.out.println("4 insert into t1 using client 3..."); - stmt3.executeUpdate("INSERT INTO t1 values( 7, 'monetdb' )"); - System.out.println("passed :)"); - stmt3.executeUpdate("INSERT INTO t1 values( 8, 'monet' )"); - System.out.println("passed :)"); - stmt3.executeUpdate("INSERT INTO t1 values( 9, 'mon' )"); - System.out.println("passed :)"); - System.out.println("4.1. check table status with client 1..."); - rs1 = stmt1.executeQuery("SELECT * FROM t1"); - while (rs1.next()) - System.out.println(rs1.getInt("id")+", "+ rs1.getString("name")); - System.out.println("passed :)"); - System.out.println("4.2. check table status with client 2..."); - rs2 = stmt2.executeQuery("SELECT * FROM t1"); - while (rs2.next()) - System.out.println(rs2.getInt("id")+", "+ rs2.getString("name")); - System.out.println("passed :)"); - System.out.println("4.3. check table status with client 3..."); - rs3 = stmt3.executeQuery("SELECT * FROM t1"); - while (rs3.next()) - System.out.println(rs3.getInt("id")+", "+ rs3.getString("name")); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 4 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - if (rs3 != null) rs3.close(); - con1.close(); - con2.close(); - con3.close(); - System.exit(-1); - } - - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - if (rs3 != null) rs3.close(); - - // cleanup - try { - stmt3.executeUpdate("DROP TABLE t1"); - } catch (SQLException e) { - System.out.println("FAILED to clean up! :( " + e.getMessage()); - } - - con1.close(); - con2.close(); - con3.close(); - } -} diff --git a/tests/BugConcurrent_sequences.java b/tests/BugConcurrent_sequences.java deleted file mode 100644 --- a/tests/BugConcurrent_sequences.java +++ /dev/null @@ -1,176 +0,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 1997 - July 2008 CWI, August 2008 - 2021 MonetDB B.V. - */ - -import java.sql.*; - -public class BugConcurrent_sequences { - public static void main(String[] args) throws Exception { - Connection con1 = null, con2 = null; - Statement stmt1 = null, stmt2 = null; - ResultSet rs1 = null, rs2 = null; - con1 = DriverManager.getConnection(args[0]); - con2 = DriverManager.getConnection(args[0]); - stmt1 = con1.createStatement(); - stmt2 = con2.createStatement(); - - // >> true: auto commit should be on by default - System.out.println("0. true\t" + con1.getAutoCommit()); - System.out.println("0. true\t" + con2.getAutoCommit()); - - // create a table - try { - System.out.print("1. create table t1 using client 1... "); - stmt1.executeUpdate("CREATE TABLE t1 ( id serial, who varchar(12) )"); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (that sux) - System.out.println("FAILED 1 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - con1.close(); - con2.close(); - System.exit(-1); - } - - // test the insertion of values with concurrent clients - try { - System.out.print("2. insert into t1 using client 1 and 2... "); - stmt1.executeUpdate("INSERT INTO t1(who) VALUES('client1')"); - System.out.println("client 1 passed :)"); - con2.setAutoCommit(false); - stmt2.executeUpdate("INSERT INTO t1(who) VALUES('client2')"); - System.out.println("transaction on client 2 :)"); - stmt1.executeUpdate("INSERT INTO t1(who) VALUES('client1')"); - System.out.println("client 1 passed :)"); - try { - con2.commit(); - System.out.println("transaction client 2 PASSED :("); - System.exit(-1); - } catch (SQLException e) { - System.out.println("transaction client 2 failed :)"); - } - con2.setAutoCommit(true); - stmt2.executeUpdate("INSERT INTO t1(who) VALUES('client2')"); - System.out.println("passed :)"); - System.out.println("2.1. check table status with client 1..."); - rs1 = stmt1.executeQuery("SELECT * FROM t1"); - while (rs1.next()) - System.out.println(rs1.getInt("id") + ", " + - rs1.getString("who")); - System.out.println("passed :)"); - System.out.println("2.2. check table status with client 2..."); - rs2 = stmt2.executeQuery("SELECT * FROM t1"); - while (rs2.next()) - System.out.println(rs2.getInt("id") + ", " + - rs2.getString("who")); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 2 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - con1.close(); - con2.close(); - System.exit(-1); - } - - // drop the table (not dropping the sequence) from client 1 - try { - System.out.print("3.1. drop table t1 using client 1... "); - stmt1.executeUpdate("DROP TABLE t1"); - System.out.println("passed :)"); - System.out.print("3.1. recreate t1 using client 1... "); - stmt1.executeUpdate("CREATE TABLE t1 ( id serial, who varchar(12) )"); - System.out.println("passed :)"); - } catch (SQLException e) { - // this means we failed (table not there perhaps?) - System.out.println("FAILED 3 :( " + e.getMessage()); - System.out.println("ABORTING TEST!!!"); - if (rs1 != null) rs1.close(); - if (rs2 != null) rs2.close(); - con1.close(); - con2.close(); - System.exit(-1); - } - - // re-establish connection - try { - System.out.print("x. Reconnecting client 1 and 2... "); - con1.close(); - con2.close(); - con1 = DriverManager.getConnection(args[0]); - con2 = DriverManager.getConnection(args[0]); - stmt1 = con1.createStatement(); - stmt2 = con2.createStatement(); - System.out.println("passed :)"); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
