public static FakeServer2				inst;

private static final String				proc_DoNothing	=
	"{ call proc_DoNothing(?, ?, ?, ?, ?) }";


public DriverManagerConnectionFactory	connectionFactory;

public static void main(String args[])
{
	inst = new FakeServer2();

	inst.init();
	inst.testDoNothingStoredProc();
}


public void init()
{
	try
	{

		try
		{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}

		String server = "10.10.10.10";

		String database = (((("mydb"))));
		String user = ("username");
		String password = "pwd";

		String url2 = "jdbc:sqlserver://" + server + ":1433;databaseName=" + database + ";user="
			+ user + ";password=" + password + ";applicationName=" + "FakeServer2"
			+ ";trustServerCertificate=true";

		connectionFactory = new DriverManagerConnectionFactory(url2, user, password);

	}
	catch (Exception e)
	{
		e.printStackTrace();
	}
	finally
	{
	}
}

public Connection getConnection()
{
	Connection c = null;
	try
	{
		c = connectionFactory.createConnection();
	}
	catch (SQLException e)
	{
		e.printStackTrace();
	}
	return c;

}

public void closeConnection(Connection conn)
{
	try
	{
		conn.close();
	}
	catch (Exception ee)
	{
		ee.printStackTrace();
	}

}

public void testDoNothingStoredProc()
{
	Connection dbconn = null;
	CallableStatement stmt = null;

	dbconn = getConnection();
	for (int j = 0; j < 10000000; j++)
	{
		try
		{
			System.out.println("iteration number " + j);
			stmt = dbconn.prepareCall(proc_DoNothing);
			int count = 20;
			for (int i = 0; i < count; ++i)
			{
				try
				{
					doNothingDB(stmt, 0, 0);
					doNothingDB(stmt, 1, 0);
					doNothingDB(stmt, 0, 1);
					doNothingDB(stmt, 1, 1);
				}
				finally
				{
				}
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				stmt.close();
				//dbconn.close();
			}
			catch (SQLException e)
			{
				e.printStackTrace();
			}
			stmt = null;
		} // end finally
	}

	try
	{
		dbconn.close();
	}
	catch (SQLException e)
	{
		e.printStackTrace();
	}
}

private void doNothingDB(CallableStatement stmt, int side, int book) throws SQLException
{
	try
	{
		for (int lev = 0; lev < 10; ++lev)
		{
			int ind = 1;
			stmt.setNString(ind++, "OK");
			stmt.setNString(ind++, "PHIL");
			stmt.setNString(ind++, "MORE");
			stmt.setLong(ind++, 1232);
			BigDecimal bd = new BigDecimal((long) (Math.random() * 100));
			stmt.setBigDecimal(ind++, bd);
			stmt.execute();
		}
	}
	catch (Exception e)
	{
		e.printStackTrace();
	}
	finally
	{
	}
}