Cleanup01.java

/*
 * JBoss, Home of Professional Open Source
 * Copyright 2007, Red Hat Middleware LLC, and individual contributors
 * as indicated by the @author tags.
 * See the copyright.txt in the distribution for a
 * full listing of individual contributors.
 * This copyrighted material is made available to anyone wishing to use,
 * modify, copy, or redistribute it subject to the terms and conditions
 * of the GNU Lesser General Public License, v. 2.1.
 * This program is distributed in the hope that it will be useful, but WITHOUT A
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
 * PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
 * You should have received a copy of the GNU Lesser General Public License,
 * v.2.1 along with this distribution; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA  02110-1301, USA.
 *
 * (C) 2005-2006,
 * @author JBoss Inc.
 */
//
// Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003
//
// Arjuna Technologies Ltd.,
// Newcastle upon Tyne,
// Tyne and Wear,
// UK.
//
// $Id: Cleanup01.java,v 1.5 2004/04/21 08:30:54 jcoleman Exp $
//

package org.jboss.jbossts.qa.JDBCResources03Cleanups;

import org.jboss.jbossts.qa.JDBCResources03.*;
import org.jboss.jbossts.qa.Utils.JDBCProfileStore;
import org.jboss.jbossts.qa.Utils.OAInterface;
import org.jboss.jbossts.qa.Utils.ORBInterface;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Properties;

public class Cleanup01
{
	public static void main(String[] args)
	{
		boolean success = false;
		boolean trying = true;
		int tries = 0;

		try
		{
			ORBInterface.initORB(args, null);
			OAInterface.initOA();

			String profileName = args[args.length - 1];

			int numberOfDrivers = JDBCProfileStore.numberOfDrivers(profileName);
			for (int index = 0; index < numberOfDrivers; index++)
			{
				String driver = JDBCProfileStore.driver(profileName, index);

				Class.forName(driver);
			}

			String databaseURL = JDBCProfileStore.databaseURL(profileName);
			String databaseUser = JDBCProfileStore.databaseUser(profileName);
			String databasePassword = JDBCProfileStore.databasePassword(profileName);
			String databaseDynamicClass = JDBCProfileStore.databaseDynamicClass(profileName);

			Connection connection;
			if (databaseDynamicClass != null)
			{
				Properties databaseProperties = new Properties();

				databaseProperties.put(com.arjuna.ats.jdbc.TransactionalDriver.userName, databaseUser);
				databaseProperties.put(com.arjuna.ats.jdbc.TransactionalDriver.password, databasePassword);
				databaseProperties.put(com.arjuna.ats.jdbc.TransactionalDriver.dynamicClass, databaseDynamicClass);

				connection = DriverManager.getConnection(databaseURL, databaseProperties);
			}
			else
			{
				connection = DriverManager.getConnection(databaseURL, databaseUser, databasePassword);
			}

			while (trying)
			{
				try
				{
					Statement statement = connection.createStatement();

					System.err.println("DROP TABLE " + databaseUser + "_NumberTable");
					statement.executeUpdate("DROP TABLE " + databaseUser + "_NumberTable");

					statement.close();
					connection.close();

					trying = false;
					success = true;
					/* Server might have crashed and table might still be busy. */
				}
				catch (java.sql.SQLException s)
				{
					System.err.println("Cleanup01.main: " + s);
					System.err.println("SQL state is: " + s.getSQLState());
					if (s.getSQLState() == "42000" ||	/* no table to drop */
							s.getSQLState() == "42S02" ||	/* table not found */
							s.getSQLState() == null)		/* connection failed */
					{
						trying = false;
					}
					else
					{
						tries++;
						if (tries >= 6)
						{
							trying = false;
							System.err.println("Giving up.");
						}
						else
						{
							try
							{
								System.err.println("Sleeping " + (tries * 10) + " seconds and re-trying ...");
								Thread.sleep(tries * 10000);
							}
							catch (Exception e)
							{
								System.err.println("Cleanup01.main: " + e);
								trying = false;
							}
						}
					}
				}
				catch (Exception e)
				{
					System.err.println("Cleanup01.main: " + e);
					trying = false;
				}
			}
		}
		catch (Exception exception)
		{
			System.err.println("Cleanup01.main: " + exception);
		}

		try
		{
			OAInterface.shutdownOA();
			ORBInterface.shutdownORB();
		}
		catch (Exception exception)
		{
			System.err.println("Cleanup01.main: " + exception);
			exception.printStackTrace(System.err);

			success = false;
		}

		System.out.println(success ? "Passed" : "Failed");
	}
}