You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/04/11 01:24:00 UTC
svn commit: r393115 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests:
UpgradeTester.java Upgrade_10_1_10_2.java
Author: fuzzylogic
Date: Mon Apr 10 16:23:58 2006
New Revision: 393115
URL: http://svn.apache.org/viewcvs?rev=393115&view=rev
Log:
Set svn:eol-style on upgrade java files
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java (contents, props changed)
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java (contents, props changed)
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java?rev=393115&r1=393114&r2=393115&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java Mon Apr 10 16:23:58 2006
@@ -1,700 +1,700 @@
-/*
-
-Derby - Class org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeTester
-
-Copyright 1999, 2006 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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.upgradeTests;
-
-import java.net.URLClassLoader;
-import java.net.URL;
-import java.net.MalformedURLException;
-import java.util.Properties;
-import java.io.File;
-
-import java.sql.Connection;
-import java.sql.ResultSet;
-import java.sql.Statement;
-import java.sql.PreparedStatement;
-import java.sql.SQLException;
-import javax.sql.DataSource;
-
-
-/**
- * Tests upgrades including soft upgrade. Test consists of following phases:
-
- <OL>
- <LI> Create database with the <B>old</B> release.
- <LI> Boot the database with the <B>new</B> release in soft upgrade mode.
- Try to execute functionality that is not allowed in soft upgrade.
- <LI> Boot the database with the <B>old</B> release to ensure the
- database can be booted by the old release after soft upgrade.
- <LI> Boot the database with the <B>new</B> release in hard upgrade mode,
- specifying the upgrade=true attribute.
- <LI> Boot the database with the <B>old</B> release to ensure the
- database can not be booted by the old release after hard upgrade.
- </OL>
- <P>
- That's the general idea for GA releases. Alpha/beta releases do not
- support upgrade unless the derby.database.allowPreReleaseUpgrade
- property is set to true, in which case this program modifies the expected
- behaviour.
- <P>
- Currently checking for pass/failure is a manual process of looking
- at the output.
-
- <P>
- This tests the following specifically.
-
- 10.1 Upgrade issues
-
- <UL>
- <LI> Routines with explicit Java signatures.
- </UL>
-
- Metadata tests
- */
-public class UpgradeTester {
-
- /**
- * Phases in upgrade test
- */
- private static final String[] PHASES =
- {"CREATE", "SOFT UPGRADE", "POST SOFT UPGRADE", "UPGRADE", "POST UPGRADE"};
-
-
- /**
- * Create a database with old version
- */
- static final int PH_CREATE = 0;
- /**
- * Perform soft upgrade with new version
- */
- static final int PH_SOFT_UPGRADE = 1;
- /**
- * Boot the database with old release after soft upgrade
- */
- static final int PH_POST_SOFT_UPGRADE = 2;
- /**
- * Perform hard upgrade with new version
- */
- static final int PH_HARD_UPGRADE = 3;
- /**
- * Boot the database with old release after hard upgrade
- */
- static final int PH_POST_HARD_UPGRADE = 4;
-
- /**
- * Use old release for this phase
- */
- private static final int OLD_RELEASE = 0;
- /**
- * Use new release for this phase
- */
- private static final int NEW_RELEASE = 1;
-
- // Location of jar file of old and new release
- private String oldJarLoc;
- private String newJarLoc;
-
- // Class loader for old and new release jars
- private URLClassLoader oldClassLoader;
- private URLClassLoader newClassLoader;
-
- // Major and Minor version number of old release
- private int oldMajorVersion;
- private int oldMinorVersion;
-
- // Major and Minor version number of new release
- private int newMajorVersion;
- private int newMinorVersion;
-
- // Indicate if alpha/beta releases should support upgrade
- private boolean allowPreReleaseUpgrade;
-
- // We can specify more jars, as required.
- private String[] jarFiles = new String [] { "derby.jar",
- "derbynet.jar",
- "derbyclient.jar",
- "derbytools.jar"};
-
- // Test jar
- private String testJar = "derbyTesting.jar";
-
- /**
- * Constructor
- *
- * @param oldJarLoc Location of old release jar files
- * @param newJarLoc Location of new version jar files
- * @param oldMajorVersion Major version number of old release
- * @param oldMinorVersion Minor version number of old release
- * @param newMajorVersion Major version number of new release
- * @param newMinorVersion Minor version number of new release
- * @param allowPreReleaseUpgrade If true, set the system property
- * 'derby.database.allowPreReleaseUpgrade' to indicate alpha/beta releases
- * to support upgrade.
- */
- public UpgradeTester(String oldJarLoc, String newJarLoc,
- int oldMajorVersion, int oldMinorVersion,
- int newMajorVersion, int newMinorVersion,
- boolean allowPreReleaseUpgrade) {
- this.oldJarLoc = oldJarLoc;
- this.newJarLoc = newJarLoc;
- this.oldMajorVersion = oldMajorVersion;
- this.oldMinorVersion = oldMinorVersion;
- this.newMajorVersion = newMajorVersion;
- this.newMinorVersion = newMinorVersion;
- this.allowPreReleaseUpgrade = allowPreReleaseUpgrade;
- }
-
- /**
- * This method creates two class loaders - one for old release and
- * other for new release.
- *
- * @throws MalformedURLException
- */
- private void createClassLoaders() throws MalformedURLException{
- oldClassLoader = createClassLoader(oldJarLoc);
- newClassLoader = createClassLoader(newJarLoc);
- }
-
- /**
- * Create a class loader using jars in the specified location. Add all jars
- * specified in jarFiles and the testing jar.
- *
- * @param jarLoc Location of jar files
- * @return class loader
- * @throws MalformedURLException
- */
- private URLClassLoader createClassLoader(String jarLoc)
- throws MalformedURLException {
- URL[] url = new URL[jarFiles.length + 1];
-
- for(int i=0; i < jarFiles.length; i++) {
- url[i] = new File(jarLoc + File.separator + jarFiles[i]).toURL();
- }
-
- // Add derbyTesting.jar. Added from newer release
- url[jarFiles.length] = new File(newJarLoc + File.separator + testJar).toURL();
-
- // Specify null for parent class loader to avoid mixing up
- // jars specified in the system classpath
- return new URLClassLoader(url, null);
- }
-
- /**
- * Set the context class loader
- * @param classLoader class loader
- */
- private static void setClassLoader(URLClassLoader classLoader) {
- Thread.currentThread().setContextClassLoader(classLoader);
- }
-
- /**
- * Set the context class loader to null
- */
- private static void setNullClassLoader() {
- Thread.currentThread().setContextClassLoader(null);
- }
-
- /**
- * Runs the upgrade tests by calling runPhase for each phase.
- * @throws Exception
- */
- public void runUpgradeTests() throws Exception{
- // Set the system property to allow alpha/beta release
- // upgrade as specified
- if(allowPreReleaseUpgrade)
- System.setProperty("derby.database.allowPreReleaseUpgrade",
- "true");
- else
- System.setProperty("derby.database.allowPreReleaseUpgrade",
- "false");
-
- createClassLoaders();
- runPhase(OLD_RELEASE, PH_CREATE);
- runPhase(NEW_RELEASE, PH_SOFT_UPGRADE);
- runPhase(OLD_RELEASE, PH_POST_SOFT_UPGRADE);
- runPhase(NEW_RELEASE, PH_HARD_UPGRADE);
- runPhase(OLD_RELEASE, PH_POST_HARD_UPGRADE);
- }
-
- /**
- * Runs each phase of upgrade test.
- * 1. Chooses the classloader to use based on the release (old/new)
- * 2. Gets a connection.
- * 3. If connection is successful, checks the version using metadata,
- * runs tests and shuts down the database.
- *
- * @param version Old or new version
- * @param phase Upgrade test phase
- * @throws Exception
- */
- private void runPhase(int version, int phase)
- throws Exception{
- System.out.println("\n\nSTART - phase " + PHASES[phase]);
-
- URLClassLoader classLoader = null;
- switch(version) {
- case OLD_RELEASE:
- classLoader = oldClassLoader;
- break;
- case NEW_RELEASE:
- classLoader = newClassLoader;
- break;
- default:
- System.out.println("ERROR: Specified an invalid release type");
- return;
- }
-
- boolean passed = true;
- Connection conn = null;
- String dbName = "wombat";
-
- setClassLoader(classLoader);
-
- try {
- conn = getConnection(classLoader, dbName, phase);
- } catch (SQLException sqle) {
-
- }
-
- if(conn != null) {
- passed = caseVersionCheck(version, conn);
- passed = caseReusableRecordIdSequenceNumber(conn, phase,
- oldMajorVersion, oldMinorVersion) && passed;
- passed = caseInitialize(conn, phase) && passed;
- passed = caseProcedures(conn, phase, oldMajorVersion,
- oldMinorVersion) && passed;
- runMetadataTest(classLoader, conn);
- conn.close();
- shutdown(classLoader, dbName);
- }
- setNullClassLoader();
-
- System.out.println("END - " + (passed ? "PASS" : "FAIL") +
- " - phase " + PHASES[phase]);
- }
-
- /**
- * Get a connection to the database using the specified class loader.
- * The connection attributes depend on the phase of upgrade test.
- *
- * @param classLoader Class loader
- * @param dbName database name
- * @param phase Upgrade test phase
- * @return connection to the database
- * @throws Exception
- */
- private Connection getConnection(URLClassLoader classLoader, String dbName,
- int phase) throws Exception{
- Connection conn = null;
- Properties prop = new Properties();
- prop.setProperty("databaseName", dbName);
-
- switch(phase) {
- case PH_CREATE:
- prop.setProperty("connectionAttributes", "create=true");
- break;
- case PH_SOFT_UPGRADE:
- case PH_POST_SOFT_UPGRADE:
- case PH_POST_HARD_UPGRADE:
- break;
- case PH_HARD_UPGRADE:
- prop.setProperty("connectionAttributes", "upgrade=true");
- break;
- default:
- break;
- }
-
- try {
- conn = getConnectionUsingDataSource(classLoader, prop);
- } catch (SQLException sqle) {
- if(phase != PH_POST_HARD_UPGRADE)
- throw sqle;
-
- // After hard upgrade, we should not be able to boot
- // the database with older version. Possible SQLStates are
- // XSLAP, if the new release is alpha/beta; XSLAN, otherwise.
- if(sqle.getSQLState().equals("XJ040")) {
- SQLException nextSqle = sqle.getNextException();
- if(nextSqle.getSQLState().equals("XSLAP") ||
- nextSqle.getSQLState().equals("XSLAN") )
- System.out.println("Expected exception: Failed to start" +
- " database with old version after hard upgrade");
- }
- }
-
- return conn;
- }
-
- /**
- * Get a connection using data source obtained from TestUtil class.
- * Load TestUtil class using the specified class loader.
- *
- * @param classLoader
- * @param prop
- * @return
- * @throws Exception
- */
- private Connection getConnectionUsingDataSource(URLClassLoader classLoader, Properties prop) throws Exception{
- Connection conn = null;
-
- Class testUtilClass = Class.forName("org.apache.derbyTesting.functionTests.util.TestUtil",
- true, classLoader);
- Object testUtilObject = testUtilClass.newInstance();
-
- // Instead of calling TestUtil.getDataSourceConnection, call
- // TestUtil.getDataSource and then call its getConnection method.
- // This is because we do not want to lose the SQLException
- // which we get when shutting down the database.
- java.lang.reflect.Method method = testUtilClass.getMethod("getDataSource", new Class[] { prop.getClass() });
- DataSource ds = (DataSource) method.invoke(testUtilClass, new Object[] { prop });
- conn = ds.getConnection();
-
- return conn;
- }
-
- /**
- * Verify the product version from metadata
- * @param version Old or new version
- * @param conn Connection
- * @throws SQLException
- */
- private boolean caseVersionCheck(int version, Connection conn)
- throws SQLException{
- boolean passed = false;
- int actualMajorVersion;
- int actualMinorVersion;
-
- if (conn == null)
- return false;
-
- actualMajorVersion = conn.getMetaData().getDatabaseMajorVersion();
- actualMinorVersion = conn.getMetaData().getDatabaseMinorVersion();
-
- switch(version) {
- case OLD_RELEASE:
- passed = (actualMajorVersion == oldMajorVersion) && (actualMinorVersion == oldMinorVersion);
- break;
- case NEW_RELEASE:
- passed = (actualMajorVersion == newMajorVersion) && (actualMinorVersion == newMinorVersion);
- break;
- default:
- passed = false;
- break;
- }
-
- System.out.println("complete caseVersionCheck - passed " + passed);
- return passed;
- }
-
- /**
- * In 10.2: We will write a ReusableRecordIdSequenceNumber in the
- * header of a FileContaienr.
- *
- * Verify here that a 10.1 Database does not malfunction from this.
- * 10.1 Databases should ignore the field.
- */
- static boolean caseReusableRecordIdSequenceNumber(Connection conn,
- int phase,
- int dbMajor, int dbMinor)
- throws SQLException
- {
- boolean runCompress = dbMajor>10 || dbMajor==10 && dbMinor>=1;
- final boolean passed;
- switch(phase) {
- case PH_CREATE: {
- Statement s = conn.createStatement();
- s.execute("create table CT1(id int)");
- s.execute("insert into CT1 values 1,2,3,4,5,6,7,8,9,10");
- conn.commit();
- passed = true;
- break;
- }
- case PH_SOFT_UPGRADE:
- if (runCompress) {
- System.out.println("caseReusableRecordIdSequenceNumber - Running compress");
- PreparedStatement ps = conn.prepareStatement
- ("call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?,?,?,?,?)");
- ps.setString(1, "APP"); // schema
- ps.setString(2, "CT1"); // table name
- ps.setInt(3, 1); // purge
- ps.setInt(4, 1); // defragment rows
- ps.setInt(5, 1); // truncate end
- ps.executeUpdate();
- conn.commit();
- }
- passed = true;
- break;
- case PH_POST_SOFT_UPGRADE: {
- // We are now back to i.e 10.1
- Statement s = conn.createStatement();
- ResultSet rs = s.executeQuery("select * from CT1");
- while (rs.next()) {
- rs.getInt(1);
- }
- s.execute("insert into CT1 values 11,12,13,14,15,16,17,18,19");
- conn.commit();
- passed = true;
- break;
- }
- case PH_HARD_UPGRADE:
- passed = true;
- break;
- default:
- passed = false;
- break;
- }
- System.out.println("complete caseReusableRecordIdSequenceNumber - passed " + passed);
- return passed;
- }
-
- /**
- * Perform some transactions
- *
- * @param conn Connection
- * @param phase Upgrade test phase
- * @return true if the test passes
- * @throws SQLException
- */
- private boolean caseInitialize(Connection conn, int phase)
- throws SQLException {
-
- boolean passed = true;
-
- switch (phase) {
- case PH_CREATE:
- conn.createStatement().executeUpdate("CREATE TABLE PHASE" +
- "(id INT NOT NULL, ok INT)");
- conn.createStatement().executeUpdate("CREATE TABLE TABLE1" +
- "(id INT NOT NULL PRIMARY KEY, name varchar(200))");
- break;
- case PH_SOFT_UPGRADE:
- break;
- case PH_POST_SOFT_UPGRADE:
- break;
- case PH_HARD_UPGRADE:
- break;
- default:
- passed = false;
- break;
- }
-
- PreparedStatement ps = conn.prepareStatement("INSERT INTO PHASE(id) " +
- "VALUES (?)");
- ps.setInt(1, phase);
- ps.executeUpdate();
- ps.close();
-
- // perform some transactions
- ps = conn.prepareStatement("INSERT INTO TABLE1 VALUES (?, ?)");
- for (int i = 1; i < 20; i++)
- {
- ps.setInt(1, i + (phase * 100));
- ps.setString(2, "p" + phase + "i" + i);
- ps.executeUpdate();
- }
- ps.close();
- ps = conn.prepareStatement("UPDATE TABLE1 set name = name || 'U' " +
- " where id = ?");
- for (int i = 1; i < 20; i+=3)
- {
- ps.setInt(1, i + (phase * 100));
- ps.executeUpdate();
- }
- ps.close();
- ps = conn.prepareStatement("DELETE FROM TABLE1 where id = ?");
- for (int i = 1; i < 20; i+=4)
- {
- ps.setInt(1, i + (phase * 100));
- ps.executeUpdate();
- }
- ps.close();
- System.out.println("complete caseInitialize - passed " + passed);
- return passed;
- }
-
- /**
- * Procedures
- * 10.1 - Check that a procedure with a signature can not be added if the
- * on-disk database version is 10.0.
- *
- * @param conn Connection
- * @param phase Upgrade test phase
- * @param dbMajor Major version of old release
- * @param dbMinor Minor version of old release
- * @return true, if the test passes
- * @throws SQLException
- */
- private boolean caseProcedures(Connection conn, int phase,
- int dbMajor, int dbMinor)
- throws SQLException {
-
- boolean signaturesAllowedInOldRelease =
- dbMajor > 10 || (dbMajor == 10 && dbMinor >= 1);
-
- boolean passed = true;
-
- switch (phase) {
- case PH_CREATE:
- break;
- case PH_SOFT_UPGRADE:
-
- try {
- conn.createStatement().execute("CREATE PROCEDURE GC() " +
- "LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME" +
- " 'java.lang.System.gc()'");
- if (!signaturesAllowedInOldRelease)
- {
- System.out.println("FAIL : created procedure with " +
- "signature");
- passed = false;
- }
- } catch (SQLException sqle) {
- if (signaturesAllowedInOldRelease
- || !"XCL47".equals(sqle.getSQLState())) {
- System.out.println("FAIL " + sqle.getSQLState()
- + " -- " + sqle.getMessage());
- passed = false;
- }
- }
- break;
- case PH_POST_SOFT_UPGRADE:
- try {
- conn.createStatement().execute("CALL GC()");
- if (!signaturesAllowedInOldRelease)
- System.out.println("FAIL : procedure was created" +
- " in soft upgrade!");
-
- } catch (SQLException sqle)
- {
- if (signaturesAllowedInOldRelease)
- System.out.println("FAIL : procedure was created not in " +
- "soft upgrade!" + sqle.getMessage());
- }
- break;
- case PH_HARD_UPGRADE:
- if (!signaturesAllowedInOldRelease)
- conn.createStatement().execute("CREATE PROCEDURE GC() " +
- "LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME " +
- "'java.lang.System.gc()'");
- conn.createStatement().execute("CALL GC()");
- break;
- default:
- passed = false;
- break;
- }
-
- System.out.println("complete caseProcedures - passed " + passed);
- return passed;
- }
-
- /**
- * Run metadata test
- *
- * @param classLoader Class loader to be used to load the test class
- * @param conn Connection
- * @throws Exception
- */
- private void runMetadataTest(URLClassLoader classLoader, Connection conn)
- throws Exception{
- Statement stmt = conn.createStatement();
-
- Class metadataClass = Class.forName("org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata",
- true, classLoader);
- Object metadataObject = metadataClass.newInstance();
- java.lang.reflect.Field f1 = metadataClass.getField("con");
- f1.set(metadataObject, conn);
- java.lang.reflect.Field f2 = metadataClass.getField("s");
- f2.set(metadataObject, stmt);
- java.lang.reflect.Method method = metadataClass.getMethod("runTest",
- null);
- method.invoke(metadataObject, null);
- }
-
- /**
- * Shutdown the database
- * @param classLoader
- * @param dbName
- * @throws Exception
- */
- private void shutdown(URLClassLoader classLoader, String dbName)
- throws Exception {
- Properties prop = new Properties();
- prop.setProperty("databaseName", dbName);
- prop.setProperty("connectionAttributes", "shutdown=true");
-
- try {
- getConnectionUsingDataSource(classLoader, prop);
- } catch (SQLException sqle) {
- if(sqle.getSQLState().equals("08006")) {
- System.out.println("Expected exception during shutdown: "
- + sqle.getMessage());
- } else
- throw sqle;
- }
- }
-
- /**
- * Display the sql exception
- * @param sqle SQLException
- */
- public static void dumpSQLExceptions(SQLException sqle) {
- do
- {
- System.out.println("SQLSTATE("+sqle.getSQLState()+"): "
- + sqle.getMessage());
- sqle = sqle.getNextException();
- } while (sqle != null);
- }
-
- // The main method is only used for testing on command-line. This class is
- // not intended to be used for adding to the harness. For harness tests,
- // create individual tests for each old/new combination.
- // e.g: Upgrade_10_1_10_2
- public static void main(String[] args) {
-
- if(args.length != 6) {
- System.out.println("USAGE: java UpgradeTester <location of old jars> <location of new jars> <old major version> <old minor version> <new major version> <new minor version>");
- System.out.println("e.g: java UpgradeTester C:\\derby\\10.1\\lib C:\\derby\\trunk\\lib 10 1 10 2");
- return;
- }
-
- String oldJarLoc = args[0];
- String newJarLoc = args[1];
- int oldMajorVersion = Integer.valueOf(args[2]).intValue();
- int oldMinorVersion = Integer.valueOf(args[3]).intValue();
- int newMajorVersion = Integer.valueOf(args[4]).intValue();
- int newMinorVersion = Integer.valueOf(args[5]).intValue();
- boolean allowPreReleaseUpgrade = true;
-
- try {
- UpgradeTester upgradeTester = new UpgradeTester(oldJarLoc, newJarLoc, oldMajorVersion, oldMinorVersion, newMajorVersion, newMinorVersion, allowPreReleaseUpgrade);
- upgradeTester.runUpgradeTests();
- } catch(MalformedURLException mue) {
- System.out.println("MalformedURLException: " + mue.getMessage());
- mue.printStackTrace();
- } catch (SQLException sqle) {
- System.out.println("SQLException:");
- dumpSQLExceptions(sqle);
- } catch (Exception e) {
- System.out.println("Exception: " + e.getMessage());
- e.printStackTrace();
- }
- }
-}
+/*
+
+Derby - Class org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeTester
+
+Copyright 1999, 2006 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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.upgradeTests;
+
+import java.net.URLClassLoader;
+import java.net.URL;
+import java.net.MalformedURLException;
+import java.util.Properties;
+import java.io.File;
+
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.Statement;
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+import javax.sql.DataSource;
+
+
+/**
+ * Tests upgrades including soft upgrade. Test consists of following phases:
+
+ <OL>
+ <LI> Create database with the <B>old</B> release.
+ <LI> Boot the database with the <B>new</B> release in soft upgrade mode.
+ Try to execute functionality that is not allowed in soft upgrade.
+ <LI> Boot the database with the <B>old</B> release to ensure the
+ database can be booted by the old release after soft upgrade.
+ <LI> Boot the database with the <B>new</B> release in hard upgrade mode,
+ specifying the upgrade=true attribute.
+ <LI> Boot the database with the <B>old</B> release to ensure the
+ database can not be booted by the old release after hard upgrade.
+ </OL>
+ <P>
+ That's the general idea for GA releases. Alpha/beta releases do not
+ support upgrade unless the derby.database.allowPreReleaseUpgrade
+ property is set to true, in which case this program modifies the expected
+ behaviour.
+ <P>
+ Currently checking for pass/failure is a manual process of looking
+ at the output.
+
+ <P>
+ This tests the following specifically.
+
+ 10.1 Upgrade issues
+
+ <UL>
+ <LI> Routines with explicit Java signatures.
+ </UL>
+
+ Metadata tests
+ */
+public class UpgradeTester {
+
+ /**
+ * Phases in upgrade test
+ */
+ private static final String[] PHASES =
+ {"CREATE", "SOFT UPGRADE", "POST SOFT UPGRADE", "UPGRADE", "POST UPGRADE"};
+
+
+ /**
+ * Create a database with old version
+ */
+ static final int PH_CREATE = 0;
+ /**
+ * Perform soft upgrade with new version
+ */
+ static final int PH_SOFT_UPGRADE = 1;
+ /**
+ * Boot the database with old release after soft upgrade
+ */
+ static final int PH_POST_SOFT_UPGRADE = 2;
+ /**
+ * Perform hard upgrade with new version
+ */
+ static final int PH_HARD_UPGRADE = 3;
+ /**
+ * Boot the database with old release after hard upgrade
+ */
+ static final int PH_POST_HARD_UPGRADE = 4;
+
+ /**
+ * Use old release for this phase
+ */
+ private static final int OLD_RELEASE = 0;
+ /**
+ * Use new release for this phase
+ */
+ private static final int NEW_RELEASE = 1;
+
+ // Location of jar file of old and new release
+ private String oldJarLoc;
+ private String newJarLoc;
+
+ // Class loader for old and new release jars
+ private URLClassLoader oldClassLoader;
+ private URLClassLoader newClassLoader;
+
+ // Major and Minor version number of old release
+ private int oldMajorVersion;
+ private int oldMinorVersion;
+
+ // Major and Minor version number of new release
+ private int newMajorVersion;
+ private int newMinorVersion;
+
+ // Indicate if alpha/beta releases should support upgrade
+ private boolean allowPreReleaseUpgrade;
+
+ // We can specify more jars, as required.
+ private String[] jarFiles = new String [] { "derby.jar",
+ "derbynet.jar",
+ "derbyclient.jar",
+ "derbytools.jar"};
+
+ // Test jar
+ private String testJar = "derbyTesting.jar";
+
+ /**
+ * Constructor
+ *
+ * @param oldJarLoc Location of old release jar files
+ * @param newJarLoc Location of new version jar files
+ * @param oldMajorVersion Major version number of old release
+ * @param oldMinorVersion Minor version number of old release
+ * @param newMajorVersion Major version number of new release
+ * @param newMinorVersion Minor version number of new release
+ * @param allowPreReleaseUpgrade If true, set the system property
+ * 'derby.database.allowPreReleaseUpgrade' to indicate alpha/beta releases
+ * to support upgrade.
+ */
+ public UpgradeTester(String oldJarLoc, String newJarLoc,
+ int oldMajorVersion, int oldMinorVersion,
+ int newMajorVersion, int newMinorVersion,
+ boolean allowPreReleaseUpgrade) {
+ this.oldJarLoc = oldJarLoc;
+ this.newJarLoc = newJarLoc;
+ this.oldMajorVersion = oldMajorVersion;
+ this.oldMinorVersion = oldMinorVersion;
+ this.newMajorVersion = newMajorVersion;
+ this.newMinorVersion = newMinorVersion;
+ this.allowPreReleaseUpgrade = allowPreReleaseUpgrade;
+ }
+
+ /**
+ * This method creates two class loaders - one for old release and
+ * other for new release.
+ *
+ * @throws MalformedURLException
+ */
+ private void createClassLoaders() throws MalformedURLException{
+ oldClassLoader = createClassLoader(oldJarLoc);
+ newClassLoader = createClassLoader(newJarLoc);
+ }
+
+ /**
+ * Create a class loader using jars in the specified location. Add all jars
+ * specified in jarFiles and the testing jar.
+ *
+ * @param jarLoc Location of jar files
+ * @return class loader
+ * @throws MalformedURLException
+ */
+ private URLClassLoader createClassLoader(String jarLoc)
+ throws MalformedURLException {
+ URL[] url = new URL[jarFiles.length + 1];
+
+ for(int i=0; i < jarFiles.length; i++) {
+ url[i] = new File(jarLoc + File.separator + jarFiles[i]).toURL();
+ }
+
+ // Add derbyTesting.jar. Added from newer release
+ url[jarFiles.length] = new File(newJarLoc + File.separator + testJar).toURL();
+
+ // Specify null for parent class loader to avoid mixing up
+ // jars specified in the system classpath
+ return new URLClassLoader(url, null);
+ }
+
+ /**
+ * Set the context class loader
+ * @param classLoader class loader
+ */
+ private static void setClassLoader(URLClassLoader classLoader) {
+ Thread.currentThread().setContextClassLoader(classLoader);
+ }
+
+ /**
+ * Set the context class loader to null
+ */
+ private static void setNullClassLoader() {
+ Thread.currentThread().setContextClassLoader(null);
+ }
+
+ /**
+ * Runs the upgrade tests by calling runPhase for each phase.
+ * @throws Exception
+ */
+ public void runUpgradeTests() throws Exception{
+ // Set the system property to allow alpha/beta release
+ // upgrade as specified
+ if(allowPreReleaseUpgrade)
+ System.setProperty("derby.database.allowPreReleaseUpgrade",
+ "true");
+ else
+ System.setProperty("derby.database.allowPreReleaseUpgrade",
+ "false");
+
+ createClassLoaders();
+ runPhase(OLD_RELEASE, PH_CREATE);
+ runPhase(NEW_RELEASE, PH_SOFT_UPGRADE);
+ runPhase(OLD_RELEASE, PH_POST_SOFT_UPGRADE);
+ runPhase(NEW_RELEASE, PH_HARD_UPGRADE);
+ runPhase(OLD_RELEASE, PH_POST_HARD_UPGRADE);
+ }
+
+ /**
+ * Runs each phase of upgrade test.
+ * 1. Chooses the classloader to use based on the release (old/new)
+ * 2. Gets a connection.
+ * 3. If connection is successful, checks the version using metadata,
+ * runs tests and shuts down the database.
+ *
+ * @param version Old or new version
+ * @param phase Upgrade test phase
+ * @throws Exception
+ */
+ private void runPhase(int version, int phase)
+ throws Exception{
+ System.out.println("\n\nSTART - phase " + PHASES[phase]);
+
+ URLClassLoader classLoader = null;
+ switch(version) {
+ case OLD_RELEASE:
+ classLoader = oldClassLoader;
+ break;
+ case NEW_RELEASE:
+ classLoader = newClassLoader;
+ break;
+ default:
+ System.out.println("ERROR: Specified an invalid release type");
+ return;
+ }
+
+ boolean passed = true;
+ Connection conn = null;
+ String dbName = "wombat";
+
+ setClassLoader(classLoader);
+
+ try {
+ conn = getConnection(classLoader, dbName, phase);
+ } catch (SQLException sqle) {
+
+ }
+
+ if(conn != null) {
+ passed = caseVersionCheck(version, conn);
+ passed = caseReusableRecordIdSequenceNumber(conn, phase,
+ oldMajorVersion, oldMinorVersion) && passed;
+ passed = caseInitialize(conn, phase) && passed;
+ passed = caseProcedures(conn, phase, oldMajorVersion,
+ oldMinorVersion) && passed;
+ runMetadataTest(classLoader, conn);
+ conn.close();
+ shutdown(classLoader, dbName);
+ }
+ setNullClassLoader();
+
+ System.out.println("END - " + (passed ? "PASS" : "FAIL") +
+ " - phase " + PHASES[phase]);
+ }
+
+ /**
+ * Get a connection to the database using the specified class loader.
+ * The connection attributes depend on the phase of upgrade test.
+ *
+ * @param classLoader Class loader
+ * @param dbName database name
+ * @param phase Upgrade test phase
+ * @return connection to the database
+ * @throws Exception
+ */
+ private Connection getConnection(URLClassLoader classLoader, String dbName,
+ int phase) throws Exception{
+ Connection conn = null;
+ Properties prop = new Properties();
+ prop.setProperty("databaseName", dbName);
+
+ switch(phase) {
+ case PH_CREATE:
+ prop.setProperty("connectionAttributes", "create=true");
+ break;
+ case PH_SOFT_UPGRADE:
+ case PH_POST_SOFT_UPGRADE:
+ case PH_POST_HARD_UPGRADE:
+ break;
+ case PH_HARD_UPGRADE:
+ prop.setProperty("connectionAttributes", "upgrade=true");
+ break;
+ default:
+ break;
+ }
+
+ try {
+ conn = getConnectionUsingDataSource(classLoader, prop);
+ } catch (SQLException sqle) {
+ if(phase != PH_POST_HARD_UPGRADE)
+ throw sqle;
+
+ // After hard upgrade, we should not be able to boot
+ // the database with older version. Possible SQLStates are
+ // XSLAP, if the new release is alpha/beta; XSLAN, otherwise.
+ if(sqle.getSQLState().equals("XJ040")) {
+ SQLException nextSqle = sqle.getNextException();
+ if(nextSqle.getSQLState().equals("XSLAP") ||
+ nextSqle.getSQLState().equals("XSLAN") )
+ System.out.println("Expected exception: Failed to start" +
+ " database with old version after hard upgrade");
+ }
+ }
+
+ return conn;
+ }
+
+ /**
+ * Get a connection using data source obtained from TestUtil class.
+ * Load TestUtil class using the specified class loader.
+ *
+ * @param classLoader
+ * @param prop
+ * @return
+ * @throws Exception
+ */
+ private Connection getConnectionUsingDataSource(URLClassLoader classLoader, Properties prop) throws Exception{
+ Connection conn = null;
+
+ Class testUtilClass = Class.forName("org.apache.derbyTesting.functionTests.util.TestUtil",
+ true, classLoader);
+ Object testUtilObject = testUtilClass.newInstance();
+
+ // Instead of calling TestUtil.getDataSourceConnection, call
+ // TestUtil.getDataSource and then call its getConnection method.
+ // This is because we do not want to lose the SQLException
+ // which we get when shutting down the database.
+ java.lang.reflect.Method method = testUtilClass.getMethod("getDataSource", new Class[] { prop.getClass() });
+ DataSource ds = (DataSource) method.invoke(testUtilClass, new Object[] { prop });
+ conn = ds.getConnection();
+
+ return conn;
+ }
+
+ /**
+ * Verify the product version from metadata
+ * @param version Old or new version
+ * @param conn Connection
+ * @throws SQLException
+ */
+ private boolean caseVersionCheck(int version, Connection conn)
+ throws SQLException{
+ boolean passed = false;
+ int actualMajorVersion;
+ int actualMinorVersion;
+
+ if (conn == null)
+ return false;
+
+ actualMajorVersion = conn.getMetaData().getDatabaseMajorVersion();
+ actualMinorVersion = conn.getMetaData().getDatabaseMinorVersion();
+
+ switch(version) {
+ case OLD_RELEASE:
+ passed = (actualMajorVersion == oldMajorVersion) && (actualMinorVersion == oldMinorVersion);
+ break;
+ case NEW_RELEASE:
+ passed = (actualMajorVersion == newMajorVersion) && (actualMinorVersion == newMinorVersion);
+ break;
+ default:
+ passed = false;
+ break;
+ }
+
+ System.out.println("complete caseVersionCheck - passed " + passed);
+ return passed;
+ }
+
+ /**
+ * In 10.2: We will write a ReusableRecordIdSequenceNumber in the
+ * header of a FileContaienr.
+ *
+ * Verify here that a 10.1 Database does not malfunction from this.
+ * 10.1 Databases should ignore the field.
+ */
+ static boolean caseReusableRecordIdSequenceNumber(Connection conn,
+ int phase,
+ int dbMajor, int dbMinor)
+ throws SQLException
+ {
+ boolean runCompress = dbMajor>10 || dbMajor==10 && dbMinor>=1;
+ final boolean passed;
+ switch(phase) {
+ case PH_CREATE: {
+ Statement s = conn.createStatement();
+ s.execute("create table CT1(id int)");
+ s.execute("insert into CT1 values 1,2,3,4,5,6,7,8,9,10");
+ conn.commit();
+ passed = true;
+ break;
+ }
+ case PH_SOFT_UPGRADE:
+ if (runCompress) {
+ System.out.println("caseReusableRecordIdSequenceNumber - Running compress");
+ PreparedStatement ps = conn.prepareStatement
+ ("call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?,?,?,?,?)");
+ ps.setString(1, "APP"); // schema
+ ps.setString(2, "CT1"); // table name
+ ps.setInt(3, 1); // purge
+ ps.setInt(4, 1); // defragment rows
+ ps.setInt(5, 1); // truncate end
+ ps.executeUpdate();
+ conn.commit();
+ }
+ passed = true;
+ break;
+ case PH_POST_SOFT_UPGRADE: {
+ // We are now back to i.e 10.1
+ Statement s = conn.createStatement();
+ ResultSet rs = s.executeQuery("select * from CT1");
+ while (rs.next()) {
+ rs.getInt(1);
+ }
+ s.execute("insert into CT1 values 11,12,13,14,15,16,17,18,19");
+ conn.commit();
+ passed = true;
+ break;
+ }
+ case PH_HARD_UPGRADE:
+ passed = true;
+ break;
+ default:
+ passed = false;
+ break;
+ }
+ System.out.println("complete caseReusableRecordIdSequenceNumber - passed " + passed);
+ return passed;
+ }
+
+ /**
+ * Perform some transactions
+ *
+ * @param conn Connection
+ * @param phase Upgrade test phase
+ * @return true if the test passes
+ * @throws SQLException
+ */
+ private boolean caseInitialize(Connection conn, int phase)
+ throws SQLException {
+
+ boolean passed = true;
+
+ switch (phase) {
+ case PH_CREATE:
+ conn.createStatement().executeUpdate("CREATE TABLE PHASE" +
+ "(id INT NOT NULL, ok INT)");
+ conn.createStatement().executeUpdate("CREATE TABLE TABLE1" +
+ "(id INT NOT NULL PRIMARY KEY, name varchar(200))");
+ break;
+ case PH_SOFT_UPGRADE:
+ break;
+ case PH_POST_SOFT_UPGRADE:
+ break;
+ case PH_HARD_UPGRADE:
+ break;
+ default:
+ passed = false;
+ break;
+ }
+
+ PreparedStatement ps = conn.prepareStatement("INSERT INTO PHASE(id) " +
+ "VALUES (?)");
+ ps.setInt(1, phase);
+ ps.executeUpdate();
+ ps.close();
+
+ // perform some transactions
+ ps = conn.prepareStatement("INSERT INTO TABLE1 VALUES (?, ?)");
+ for (int i = 1; i < 20; i++)
+ {
+ ps.setInt(1, i + (phase * 100));
+ ps.setString(2, "p" + phase + "i" + i);
+ ps.executeUpdate();
+ }
+ ps.close();
+ ps = conn.prepareStatement("UPDATE TABLE1 set name = name || 'U' " +
+ " where id = ?");
+ for (int i = 1; i < 20; i+=3)
+ {
+ ps.setInt(1, i + (phase * 100));
+ ps.executeUpdate();
+ }
+ ps.close();
+ ps = conn.prepareStatement("DELETE FROM TABLE1 where id = ?");
+ for (int i = 1; i < 20; i+=4)
+ {
+ ps.setInt(1, i + (phase * 100));
+ ps.executeUpdate();
+ }
+ ps.close();
+ System.out.println("complete caseInitialize - passed " + passed);
+ return passed;
+ }
+
+ /**
+ * Procedures
+ * 10.1 - Check that a procedure with a signature can not be added if the
+ * on-disk database version is 10.0.
+ *
+ * @param conn Connection
+ * @param phase Upgrade test phase
+ * @param dbMajor Major version of old release
+ * @param dbMinor Minor version of old release
+ * @return true, if the test passes
+ * @throws SQLException
+ */
+ private boolean caseProcedures(Connection conn, int phase,
+ int dbMajor, int dbMinor)
+ throws SQLException {
+
+ boolean signaturesAllowedInOldRelease =
+ dbMajor > 10 || (dbMajor == 10 && dbMinor >= 1);
+
+ boolean passed = true;
+
+ switch (phase) {
+ case PH_CREATE:
+ break;
+ case PH_SOFT_UPGRADE:
+
+ try {
+ conn.createStatement().execute("CREATE PROCEDURE GC() " +
+ "LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME" +
+ " 'java.lang.System.gc()'");
+ if (!signaturesAllowedInOldRelease)
+ {
+ System.out.println("FAIL : created procedure with " +
+ "signature");
+ passed = false;
+ }
+ } catch (SQLException sqle) {
+ if (signaturesAllowedInOldRelease
+ || !"XCL47".equals(sqle.getSQLState())) {
+ System.out.println("FAIL " + sqle.getSQLState()
+ + " -- " + sqle.getMessage());
+ passed = false;
+ }
+ }
+ break;
+ case PH_POST_SOFT_UPGRADE:
+ try {
+ conn.createStatement().execute("CALL GC()");
+ if (!signaturesAllowedInOldRelease)
+ System.out.println("FAIL : procedure was created" +
+ " in soft upgrade!");
+
+ } catch (SQLException sqle)
+ {
+ if (signaturesAllowedInOldRelease)
+ System.out.println("FAIL : procedure was created not in " +
+ "soft upgrade!" + sqle.getMessage());
+ }
+ break;
+ case PH_HARD_UPGRADE:
+ if (!signaturesAllowedInOldRelease)
+ conn.createStatement().execute("CREATE PROCEDURE GC() " +
+ "LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME " +
+ "'java.lang.System.gc()'");
+ conn.createStatement().execute("CALL GC()");
+ break;
+ default:
+ passed = false;
+ break;
+ }
+
+ System.out.println("complete caseProcedures - passed " + passed);
+ return passed;
+ }
+
+ /**
+ * Run metadata test
+ *
+ * @param classLoader Class loader to be used to load the test class
+ * @param conn Connection
+ * @throws Exception
+ */
+ private void runMetadataTest(URLClassLoader classLoader, Connection conn)
+ throws Exception{
+ Statement stmt = conn.createStatement();
+
+ Class metadataClass = Class.forName("org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata",
+ true, classLoader);
+ Object metadataObject = metadataClass.newInstance();
+ java.lang.reflect.Field f1 = metadataClass.getField("con");
+ f1.set(metadataObject, conn);
+ java.lang.reflect.Field f2 = metadataClass.getField("s");
+ f2.set(metadataObject, stmt);
+ java.lang.reflect.Method method = metadataClass.getMethod("runTest",
+ null);
+ method.invoke(metadataObject, null);
+ }
+
+ /**
+ * Shutdown the database
+ * @param classLoader
+ * @param dbName
+ * @throws Exception
+ */
+ private void shutdown(URLClassLoader classLoader, String dbName)
+ throws Exception {
+ Properties prop = new Properties();
+ prop.setProperty("databaseName", dbName);
+ prop.setProperty("connectionAttributes", "shutdown=true");
+
+ try {
+ getConnectionUsingDataSource(classLoader, prop);
+ } catch (SQLException sqle) {
+ if(sqle.getSQLState().equals("08006")) {
+ System.out.println("Expected exception during shutdown: "
+ + sqle.getMessage());
+ } else
+ throw sqle;
+ }
+ }
+
+ /**
+ * Display the sql exception
+ * @param sqle SQLException
+ */
+ public static void dumpSQLExceptions(SQLException sqle) {
+ do
+ {
+ System.out.println("SQLSTATE("+sqle.getSQLState()+"): "
+ + sqle.getMessage());
+ sqle = sqle.getNextException();
+ } while (sqle != null);
+ }
+
+ // The main method is only used for testing on command-line. This class is
+ // not intended to be used for adding to the harness. For harness tests,
+ // create individual tests for each old/new combination.
+ // e.g: Upgrade_10_1_10_2
+ public static void main(String[] args) {
+
+ if(args.length != 6) {
+ System.out.println("USAGE: java UpgradeTester <location of old jars> <location of new jars> <old major version> <old minor version> <new major version> <new minor version>");
+ System.out.println("e.g: java UpgradeTester C:\\derby\\10.1\\lib C:\\derby\\trunk\\lib 10 1 10 2");
+ return;
+ }
+
+ String oldJarLoc = args[0];
+ String newJarLoc = args[1];
+ int oldMajorVersion = Integer.valueOf(args[2]).intValue();
+ int oldMinorVersion = Integer.valueOf(args[3]).intValue();
+ int newMajorVersion = Integer.valueOf(args[4]).intValue();
+ int newMinorVersion = Integer.valueOf(args[5]).intValue();
+ boolean allowPreReleaseUpgrade = true;
+
+ try {
+ UpgradeTester upgradeTester = new UpgradeTester(oldJarLoc, newJarLoc, oldMajorVersion, oldMinorVersion, newMajorVersion, newMinorVersion, allowPreReleaseUpgrade);
+ upgradeTester.runUpgradeTests();
+ } catch(MalformedURLException mue) {
+ System.out.println("MalformedURLException: " + mue.getMessage());
+ mue.printStackTrace();
+ } catch (SQLException sqle) {
+ System.out.println("SQLException:");
+ dumpSQLExceptions(sqle);
+ } catch (Exception e) {
+ System.out.println("Exception: " + e.getMessage());
+ e.printStackTrace();
+ }
+ }
+}
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeTester.java
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java?rev=393115&r1=393114&r2=393115&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java Mon Apr 10 16:23:58 2006
@@ -1,61 +1,61 @@
-/*
-
-Derby - org.apache.derbyTesting.functionTests.tests.upgradeTests.Upgrade_10_1_10_2
-
-Copyright 1999, 2006 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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.upgradeTests;
-
-import java.net.MalformedURLException;
-import java.sql.SQLException;
-
-import org.apache.derbyTesting.functionTests.harness.jvm;
-
-/**
- * Test upgrade from 10.1 to 10.2
- */
-public class Upgrade_10_1_10_2 {
-
- public static void main(String[] args) {
-
- String oldJarLoc = System.getProperty("derbyTesting.oldJarLocation");
- boolean[] isJar = new boolean[1];
- String newJarLoc = jvm.findCodeBase(isJar);
-
- int oldMajorVersion = 10;
- int oldMinorVersion = 1;
- int newMajorVersion = 10;
- int newMinorVersion = 2;
- boolean allowPreReleaseUpgrade = true;
-
- try {
- UpgradeTester upgradeTester = new UpgradeTester(oldJarLoc, newJarLoc,
- oldMajorVersion, oldMinorVersion,
- newMajorVersion, newMinorVersion,
- allowPreReleaseUpgrade);
- upgradeTester.runUpgradeTests();
- } catch(MalformedURLException mue) {
- System.out.println("MalformedURLException: " + mue.getMessage());
- mue.printStackTrace();
- } catch (SQLException sqle) {
- System.out.println("SQLException:");
- UpgradeTester.dumpSQLExceptions(sqle);
- } catch (Exception e) {
- System.out.println("Exception: " + e.getMessage());
- e.printStackTrace();
- }
- }
-}
+/*
+
+Derby - org.apache.derbyTesting.functionTests.tests.upgradeTests.Upgrade_10_1_10_2
+
+Copyright 1999, 2006 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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.upgradeTests;
+
+import java.net.MalformedURLException;
+import java.sql.SQLException;
+
+import org.apache.derbyTesting.functionTests.harness.jvm;
+
+/**
+ * Test upgrade from 10.1 to 10.2
+ */
+public class Upgrade_10_1_10_2 {
+
+ public static void main(String[] args) {
+
+ String oldJarLoc = System.getProperty("derbyTesting.oldJarLocation");
+ boolean[] isJar = new boolean[1];
+ String newJarLoc = jvm.findCodeBase(isJar);
+
+ int oldMajorVersion = 10;
+ int oldMinorVersion = 1;
+ int newMajorVersion = 10;
+ int newMinorVersion = 2;
+ boolean allowPreReleaseUpgrade = true;
+
+ try {
+ UpgradeTester upgradeTester = new UpgradeTester(oldJarLoc, newJarLoc,
+ oldMajorVersion, oldMinorVersion,
+ newMajorVersion, newMinorVersion,
+ allowPreReleaseUpgrade);
+ upgradeTester.runUpgradeTests();
+ } catch(MalformedURLException mue) {
+ System.out.println("MalformedURLException: " + mue.getMessage());
+ mue.printStackTrace();
+ } catch (SQLException sqle) {
+ System.out.println("SQLException:");
+ UpgradeTester.dumpSQLExceptions(sqle);
+ } catch (Exception e) {
+ System.out.println("Exception: " + e.getMessage());
+ e.printStackTrace();
+ }
+ }
+}
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Upgrade_10_1_10_2.java
------------------------------------------------------------------------------
svn:eol-style = native