/*
* 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.6 2004/04/21 08:30:54 jcoleman Exp $
//
package org.jboss.jbossts.qa.JDBCResources02Setups;
import org.jboss.jbossts.qa.JDBCResources02.*;
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.sql.SQLException;
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("Setup01.main: " + s);
System.err.println("SQL state is: <" + s.getSQLState() + ">");
}
}
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");
}
}
}