svn commit: r685599 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java

[my...@apache.org]

Author: myrnavl
Date: Wed Aug 13 09:18:15 2008
New Revision: 685599

URL: http://svn.apache.org/viewvc?rev=685599&view=rev
Log:
DERBY-3797; forgot to add the actual converted test, metadataMultiConnTest.java

Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java   (with props)

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java?rev=685599&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java Wed Aug 13 09:18:15 2008
@@ -0,0 +1,117 @@
+/*
+
+   Derby - 
+   Class org.apache.derbyTesting.functionTests.tests.jdbcapi.metadataMultiConnTest
+
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+   Unless required by applicable law or agreed to in writing, software
+   distributed under the License is distributed on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+   See the License for the specific language governing permissions and
+   limitations under the License.
+
+ */
+
+package org.apache.derbyTesting.functionTests.tests.jdbcapi;
+
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import junit.framework.Test;
+import junit.framework.TestSuite;
+
+import org.apache.derbyTesting.junit.BaseJDBCTestCase;
+import org.apache.derbyTesting.junit.JDBC;
+
+public class metadataMultiConnTest extends BaseJDBCTestCase {
+
+	
+	public metadataMultiConnTest(String name) {
+		super(name);
+	}
+
+	public static Test suite() {
+		return new TestSuite(metadataMultiConnTest.class);
+	}
+
+
+	public void testMetadataMultiConn() throws SQLException {
+
+		Connection conn1 = openDefaultConnection();
+		metadataCalls(conn1);
+
+		Connection conn2 = openDefaultConnection();
+		metadataCalls(conn2);
+
+		Connection conn3 = openDefaultConnection();
+		metadataCalls(conn3);
+
+		conn1.commit();
+		conn2.commit();
+
+		checkConsistencyOfAllTables(conn3);
+	}
+
+	public void metadataCalls(Connection conn) throws SQLException {
+		DatabaseMetaData dmd = conn.getMetaData();
+		getTypeInfo(dmd);
+		getTables(dmd);
+		getColumnInfo(dmd);
+		getPrimaryKeys(dmd);
+		getExportedKeys(dmd);
+	}
+
+	public void getTypeInfo(DatabaseMetaData dmd) throws SQLException {
+		ResultSet rs = dmd.getTypeInfo();
+		JDBC.assertDrainResults(rs);
+	}
+
+	public void getTables(DatabaseMetaData dmd) throws SQLException {
+		String types[] = new String[1];
+		types[0] = "TABLE";
+		ResultSet rs = dmd.getTables(null, null, null, types);
+		JDBC.assertDrainResults(rs);
+	}
+
+	public void getColumnInfo(DatabaseMetaData dmd) throws SQLException {
+		ResultSet rs = dmd.getColumns(null, null, "%", "%");
+		JDBC.assertDrainResults(rs);
+	}
+
+	public void getPrimaryKeys(DatabaseMetaData dmd) throws SQLException {
+		ResultSet rs = dmd.getPrimaryKeys(null, null, "%");
+		JDBC.assertDrainResults(rs);
+	}
+
+	public void getExportedKeys(DatabaseMetaData dmd) throws SQLException {
+		ResultSet rs = dmd.getExportedKeys(null, null, "%");
+		JDBC.assertDrainResults(rs);
+	}
+
+
+	public void checkConsistencyOfAllTables(Connection conn)
+			throws SQLException {
+
+		Statement s = conn.createStatement();
+		ResultSet rs = s.executeQuery("SELECT schemaname, tablename, "
+				+ "SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename) "
+				+ "FROM sys.sysschemas s, sys.systables t "
+				+ "WHERE s.schemaid = t.schemaid");
+		while (rs.next()) {
+			assertTrue(rs.getBoolean(3));
+		}
+		rs.close();
+		s.close();
+	}
+}

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadataMultiConnTest.java
------------------------------------------------------------------------------
    svn:eol-style = native