Setup02.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: Setup02.java,v 1.7 2004/04/20 10:55:36 jcoleman Exp $
//

package org.jboss.jbossts.qa.JDBCResources01Setups;

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

import java.sql.*;
import java.util.Properties;

public class Setup02
{
	public static void main(String[] args)
	{
        boolean useSybaseLockingHack = false;
        boolean useShortIndexNames = false;

		boolean passed = true;

		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);

                if(driver.contains(".sybase.")) {
                    useSybaseLockingHack = true;
                }
                if(driver.contains(".db2.")) {
                    useShortIndexNames = true;
                }

				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);
			}

			Statement statement = connection.createStatement();

            String tableName = JDBCProfileStore.getTableName(databaseUser, "Infotable");

			try
			{
				System.err.println("DROP TABLE " + tableName);
				statement.executeUpdate("DROP TABLE " + tableName);
			}
			catch (java.sql.SQLException s)
			{
				if(!(s.getSQLState().startsWith("42") // old ms sql 2000 drivers
						|| s.getSQLState().equals("S0005") // ms sql 2005 drivers
						|| s.getSQLState().equals("ZZZZZ"))) // sybase jConnect drivers
				{
					System.err.println("Setup02.main: " + s);
					System.err.println("SQL state is: <" + s.getSQLState() + ">");
					passed = false;
				}
			}
			System.err.println("CREATE TABLE " + tableName+" (Name VARCHAR(64), Value VARCHAR(64))");
			statement.executeUpdate("CREATE TABLE " + tableName + " (Name VARCHAR(64), Value VARCHAR(64))");

            String indexName = tableName;
            // db2 only allows index names max length 18 (for us that is 14 + "_idx")
            if(useShortIndexNames && tableName.length() > 14) {
                indexName = tableName.substring(0, 14);
            }

			// Create an Index for the table just created. Microsoft SQL requires an index for Row Locking.
			System.err.println("CREATE UNIQUE INDEX " + indexName+"_idx " +
					"ON " + tableName + " (Name) ");

            try
            {
                statement.executeUpdate("CREATE UNIQUE INDEX " + indexName + "_idx " +
					"ON " + tableName + " (Name) ");
            }
            catch(SQLException s)
            {
                if(!useShortIndexNames) {
                    throw s;
                }

                // the shortening of the name may have made in non-uniq. Try a different name...
                s.printStackTrace(System.err);
                indexName = "x"+Integer.toHexString(tableName.hashCode());
                System.err.println("CREATE INDEX failed, retrying with hashcode in the hope it's a name collision problem");
                System.err.println("CREATE UNIQUE INDEX " + indexName+"_idx " +"ON " + tableName + " (Name) ");
                statement.executeUpdate("CREATE UNIQUE INDEX " + indexName + "_idx " +
					"ON " + tableName + " (Name) ");
            }


            // sybase uses coarse grained locking by default and XA tx branches appear to be loose coupled i.e. do not share locks.
            // Unlike MSSQL, the presence of an index is not enough to cause the db to use row level locking. We need to configure
            // it explicitly instead. Without this the tests that use more than one server i.e. db conn/branch may block.
            if(useSybaseLockingHack) {
                // force use of row level locking
                System.err.println("configuring sybase row level locking: ALTER TABLE " + tableName+" lock datarows");
                statement.executeUpdate("ALTER TABLE " + tableName+" lock datarows");
            }

			for (int index = 0; index < 10; index++)
			{
				String name = "Name_" + index;
				String value = "Value_" + index;

				System.err.println("INSERT INTO " + tableName+" VALUES(\'" + name + "\', \'" + value + "\')");
				statement.executeUpdate("INSERT INTO " + tableName + " VALUES(\'" + name + "\', \'" + value + "\')");
			}

			statement.close();
			connection.close();
		}
		catch (Exception exception)
		{
			System.err.println("Setup02.main: " + exception);
			exception.printStackTrace(System.err);
			System.out.println("Failed");
			passed = false;
		}

		try
		{
			OAInterface.shutdownOA();
			ORBInterface.shutdownORB();
		}
		catch (Exception exception)
		{
			System.err.println("Setup02.main: " + exception);
			exception.printStackTrace(System.err);
			System.out.println("Failed");
			passed = false;
		}

		if (passed)
		{
			System.out.println("Passed");
		}
		else
		{
			System.out.println("Failed");
		}
	}
}